Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

how to disable Record-Locking


  • Please log in to reply

#1
wes77morris

wes77morris

    New Member

  • Member
  • Pip
  • 9 posts
I am new to MS Access we are building a database that needs to be accessed by multiple users over a network drive. we all have access to the network and all have MS Office 2003. When ever we have the file on the network opened on one pc it can not be opened on another this are the settings we have it under any help would be greatly appreciated

Attached Thumbnails

  • 4564.gif

  • 0

Advertisements


#2
db@philly

db@philly

    New Member

  • Member
  • Pip
  • 3 posts
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.

Edited by db@philly, 26 March 2009 - 02:19 PM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP