how to disable Record-Locking
Started by
wes77morris
, Mar 19 2009 10:02 AM
#1
Posted 19 March 2009 - 10:02 AM
#2
Posted 26 March 2009 - 02:16 PM
Split the tables away from the rest of the database. Create a front-end/back-end program. One database (the back-end) contains only Tables, the other database (the front-end) contains only Queries/Forms/Reports/and other objects. Map the network drive where the back-end will reside to a standard drive letter. Then link the tables from the back-end to the programs on the front end database following the pre-mapped drive letter. Allow the back-end to reside on a server drive. Then put a copy of the front-end on to the work stations of the users of the database.
Make all program revisions to a 'template' copy of the front-end, then place a copy of the front-end on the workstation of each user after the revision is complete.
Split the data from the programs using a tool available in MS Access 2003.
Open the original database (backup first!).
from the menu at the top of your screen:
Tools ---> Database Utilities ---> Database Splitter
Follow the directions.
Make all program revisions to a 'template' copy of the front-end, then place a copy of the front-end on the workstation of each user after the revision is complete.
Split the data from the programs using a tool available in MS Access 2003.
Open the original database (backup first!).
from the menu at the top of your screen:
Tools ---> Database Utilities ---> Database Splitter
Follow the directions.
Edited by db@philly, 26 March 2009 - 02:19 PM.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users