Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
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