Search results for query: *

Hi, I have a multi-user database (access 2000 with most users using XP). Data is entered into a main table with an autonumber reference. There are then 3 nested sub tables that use this reference as part of the Key. I currently have an SQL duplicate function in place on the main table's...

Could really do with some assistance/Advice on this one. I have a very simple database - Switchboard, two tables, one form linked to one table. When a user has the switchboard open multiple users can access the database, When the form is open - the database is locked by the passive Shutdown...

I understand that is is possible to use api calls to read the lbd file for access databases to identify who and which computers have the database open, Can anyone provide me with the starting point on how to retrieve this info. Thanks

Hi, I am building a menu system in an intermediary database to control the way users open a selection of other databases. I want to open one of the databases exclusivly if the data needs refreshing, once the refresh is complete close the database and open as Shared again. The method I am...

We have a database that contains confidential information. I have been requested to supress the printing of three feilds on a Access 97 Report but to have them visible on the PrintPreview - much the same as the property on Forms that allow a control to be visible on Screen only/Print only or...

We are about to migrate our shared network drives to a new structure that involves the change of the letter ID from J:\ to I:\. I have written some code to change the connection string on some linked tables in Access using the .connect property and substituting the new path. However I have an...