For question relating to Microsoft Access, use the tag 'microsoft-access'. This tag is not helpful and should not be used at all.
1
vote
2answers
57 views
How to forbid programs from accessing a folder
I use firefox as my default browser. IE and chrome are used as secondary browsers.
Apart from these, i need to have a alternate browser. I tried opera, but when installing it, opera automatically ...
1
vote
2answers
210 views
MS Excel and Access - which is better for reports?
Where I work, staff have just started to use a basic table in excel (1 october) to record sales which has about 10 columns (name, client, renewed, discount, paid etc). I record the data (total sold ...
1
vote
2answers
2k views
Windows 7 hangs with 100% disk activity but only when online
I have the same problem as seemingly many other people here, and I think we might all be experiencing the same issue: a compatibility issue in Windows 7 between hard drive and network controller or ...
1
vote
2answers
346 views
Obtain file access permissions on read-only-mounted volume? (Windows 7)
I made an image of my entire C:\ drive using EaseUS Todo Backup Free, before formatting and setting up a new Windows (7 Professional) system. I can mount that image read-only in Todo Backup and copy ...
0
votes
2answers
666 views
Microsoft Access Macro - is there a way to copy records with a macro?
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and ...
0
votes
2answers
67 views
Two Access fields into Word without delimitation
I have two fields in Access, FN and LN that need to be converted to word without being separated by anything except a space. For instance, John in FN and Doe in LN should appear as John Doe, rather ...
0
votes
2answers
67 views
How do I relate these access tables without losing data?
I have an excel flat file with about ~6k records I want to put into a MS Access database. The original Excel fields are:
Name
Address
City
State
Zip
DOB
CaseNumber
DateSentenced
AmountDue
I saved ...
1
vote
1answer
481 views
Access query to combine two columns into one longer column with both sets of data
I need an MS Access query that will combine data from two identical fields in two different tables into one field. The two tables are "Payroll_2011" and "Payroll_2012"; and both tables have columns ...
1
vote
1answer
268 views
Files not accessible
My system is running on a pc with C:\ Drive out of space. So I tried to delete some file and clean up to get more space. I found that the %Temp% {C:\Users\Username\AppData\Local\Temp} takes lots of ...
1
vote
1answer
176 views
UTF/unix time conversion in access
I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number ...
0
votes
1answer
52 views
No access via cygwin to USB connected device (Samsung Galaxy tab II)
In Cygwin, I am used to being able to have access to a USB-connected device via a drive letter. For example, my Droid X2 appeared as E://, so I could do:
$ cd E:/<something>/
and get access ...
0
votes
1answer
457 views
Access 2007 wont open in 2013 just gives errors saying not compatible
This is my first attempt at a big access project so please be gentle :)
I have created a database in Access 2007 on my works PC and it is a .accdb format files. I tried to open it in Access 2013 on ...
0
votes
1answer
90 views
linux: access mounted volumes as normal folders/files
I have a closed source software (client) running on a linux machine (debian) to deliver files to a backup machine.
This works fine except this client software does not access the mounted volumes ...
0
votes
1answer
620 views
Remote access to ip camera
I am trying to set up remote access to an ip camera I've just bought. The camera is tuned wirelessly to my Huawei HG520B router and works fine on my LAN. My ip address is public, so I've set up a ...
0
votes
1answer
252 views
CMD - Prevent user copy files in a directory to somewhere else
Would be happy to know if there's a way to prevent users to copy files from a directory under local file system to somewhere else(e.g. to USBs, or to another folder in the same local file system)?
...
0
votes
1answer
468 views
Looking to report on last file access for our archives
We are looking to generate a report that would let us know when files in our archive were last accessed. We are trying to determine which files can be moved to lower cost and slower storage devices, ...
0
votes
1answer
296 views
hard wired remote WiFi access point
I have a 1 gig netgear router connected to a 1 gig netgear switcher & then patched to my distribution throughout the house. My router is in the basement & I would like to have a ethernet hard ...
0
votes
1answer
379 views
Apache deny access to subdirectories
my goal is to deny access to certain sub-directories. my localhost configuration allows overriding like that:
<Directory />
Options FollowSymLinks
AllowOverride None
...
-1
votes
1answer
79 views
How to connect to my lan from the outside (e.g. internet)
I want that my router will see me as an inside the LAN host when i access him from an outside IP that is not in the LAN so i can access my printer and storage device that are connected to him. I can ...
-1
votes
1answer
60 views
How to deny access to network (Internet) for users group in Windows?
I have Windows 7 prof installed without any AD. Just notebook for example. And I need to create Users group with limitations to access Internet via my application. Some accounts needs to have access ...
-2
votes
1answer
38 views
have values in excel, im trying to find the end result based on two sets of criteria
im trying to identify matches between column D & K, AND THEN, out of those matches, which ones have matches on column A & H. Basically columns D (ABC) & A (123) are linked, and K (ABC) ...
2
votes
0answers
45 views
Microsoft Access 2010 Error
Ok, so I am not a pro in MS Access (or databases), but I tried googling this and no answers, so here goes nothing:
I am trying to create a field to convert currencies from one of 2 fields, thus I am ...
2
votes
0answers
59 views
Insert Excel Spreadsheet Into Word From Access Database
I have an Access database with Excel spreadsheets (files) linked to a field in each record.
In Word, I have setup a mail merge which picks up the data from each record and I want to insert the ...
2
votes
0answers
202 views
Access 2010. Create list of checkboxes (automatically) for separate values, not multivalue
I'm trying to create a form whereby I can add multiple values to a table. I want to select the values using a list of check boxes, but there are a lot of values- is there anyway to automatically ...
1
vote
0answers
32 views
Changing the connection information on a linked QUERY in Access 2007
This is about linked queries, not linked tables. With no linked tables, the Linked Table Manager is disabled.
I know how to see the connection of a linked query, linked to SQL Server:
...
1
vote
0answers
87 views
Access 2010 Superscript, Subscript, and Math Notations
I am creating an Access 2010 database to read rich text files full of math questions. I have the necessary fields in rich text, but rich text does not seem to support superscript, subscript, and ...
1
vote
0answers
92 views
Wifi Multi-AP Roaming, connected to single authentication server
We are thinking of setting up a configuration where 10 or so wifi APs are setup in our building all with the same SSID for roaming, connected to a wired ethernet for backhaul.
Our solution requires a ...
1
vote
0answers
85 views
Give part of LDAP tree access to SVN repository
This is a relatively simple question. The company I work for has an SVN server with multiple repositories. Everyone has access to this one repository in particular; it contains employee contact ...
1
vote
0answers
157 views
Mirror a Microsoft Access 2007 file as a SQL database?
We have a Microsoft Access 2007 database that we would like to mirror as SQL database (typically MSSQL or MySQL, but we are flexible here). The mirrored database is only used for read-only purposes. ...
0
votes
0answers
9 views
Access Query Designer Woes — select by multiple values not working
Table 1 Names
Table 2 Services
If I do a simple select of both tables together, I get a list as follows:
Name1 Service X
Name2 Service X
Name2 Service X
Name2 Service Y
Name3 Service Y
Name3 ...
0
votes
0answers
35 views
How do I export to CSV without decimals using MS Access 2010?
Is there a way to export numeric data to csv file in MS Access 2010 without decimals? I am using ImportExportText in my macro. I don't see anywhere where you can specify this.
The macro is ...
0
votes
0answers
15 views
Passing Query Parameter to Sub-Report
It has been a long time since I have worked with MS Access and am not sure if I am doing this right.
I have a Report bound to a query of single list of user names. The report groups on the user name ...
0
votes
0answers
10 views
Alternate User profile without internet access
I want to use two user profiles in Windows 7, the default one should have internet access, and the other should not get any chance to access internet. He should be able to access all the files but ...
0
votes
0answers
52 views
advice on generating reports with Excel vs Microsoft Access
I have a Microsoft Access based tool that lacks the reporting capability I need. The tool is able to extract extract each table from its relational database as a separate CSV file. These files aren't ...
0
votes
0answers
91 views
Windows XP SP3 to Mac mini server Mountain Lion
I am replacing an old 1997 windows server with a mac mini server running ML server edition. I would like to store my old windows files on the new server as well as our MS Access database. Will it be ...
0
votes
0answers
252 views
Cannot open all .SNP snapshot files on Windows 7 x64
We receive .snp snapshot files from legacy MS Access databases out in the field. Our new Windows 7 x64 machines are running Office 2003 and the Snapshot Viewer (SNAPVIEW.EXE), however the vast ...
0
votes
0answers
74 views
replace " with access replace function in query
I'm running a make table query for exported data and need to replace user typed " (double quotes with "
What I have is:
Thickness: Replace([Flooring Products]![Thickness],'"', """)
...
0
votes
0answers
18 views
Accessing A Shared Directory That Has An Account White List
I'm on a LAN here at work and I have my desktop sharing some of my project folders. I can access the computer via \\ComputerIP\, but I can't actually open any of the folders. Upon attempting, I get ...
0
votes
0answers
80 views
Windows 7 x64, TeamViewer not connecting
My remote computer was not logged in and I can not connect to it.
Actually I can, TeamViewer says "Authentication", then hides but no window appears.
What's that bug?
0
votes
0answers
127 views
Convert Word 2010 document to Excel or Access?
I have about 700 Word 2010 documents, each with 10 headings. I have to create an Excel file so that each line in it corresponds to one Word document and each heading of the corresponding document must ...
0
votes
0answers
155 views
Can I connect my tablet to the PC using VNC while connected to an access point
I recently relocated to South East Asia. I have stayed in a guest house for two months and my PC and cell phone are connected wirelessly to an access point.
The IP address of the PC is: 192.168.1.10
...
0
votes
0answers
52 views
Access Password popup
Using Access 2007, I have a login page which lists the names from a table. That table has a value for password. Came someone direct me as to to how to password protect the sign on. Another words when ...
0
votes
0answers
54 views
Folder is not accessable, owner is not changeable. What should I do?
I'm facing currently a problem with a folder in windows 7, that is not accessable. Such a problem I had treated often in the last years on several pc's. But today the problem seems harder than the ...
0
votes
0answers
259 views
Can't access to my VPS
I try to connect to my VPS but I can't, even if i use an another computer. But when I use a different connection (other IP) it works.
So I was wondering, why my VPS blacklist my IP ? And where can I ...
0
votes
0answers
336 views
When using the Access Table Analyzer Wizard, I get the error “Cannot define field more than once”
I'm trying to normalize a very simple dataset:
user_id | role_id
I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table ...
