The Access Developers Handbooks, by Getz, Litwin and Gilbert contains sample
functions to verify links and perform relinks in code. This approach is veryReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/5842-re-multiple-users-connecting-access-database.html
useful if you want to develop linked to one backend and then deploy front
ends that connect to production backends
"glenno" wrote in message
> OK, I have split the database, but when I move the front end to another
> machine the path to the back end is not right and I can not find where to
> change it. Can you point me in the right direction? Thanks...
> "Dean" wrote:
>> In this scenario, only one user will be able to update data because the
>> be opening the file exclusively. You should split the database into a
>> Front-end and backend, and put copies of the front-end onto each users
>> computer, with back-end on the server. Each user will then have
>> accesst to the data. There is a Database splitter wizard to help you do
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5842
>> "glenno" wrote in message
>> > Hello,
>> > I am using Access 2000 and have a database that is centrally located in
>> > a
>> > shared folder on the network that has full read and write permissions
>> > open.
>> > If one user is connected to the database from their machine then no
>> > other
>> > user can open the shared folder in Windows Explorer and double click on
>> > the
>> > database to open it. They must start Access and then use file->open to
>> > access the database. Why is this and can this behavior be changed?
>> > Thanks...
>> > Glenn Olsen