Sharing Access Database over a Network

[Brad]

Please Help. I have an Access (2002) database that I want to share with
another person over a network. I would like the database to state resident
on my harddrive. I use Win XP the other box is Win 2k. When I map a drive to
the win2k box I get an error on opening saying access can not lock file. If
I close the database on my drive the win 2k box opens the database in read
only.

Both boxes have the full version of ms access xp. What am I doing wrong?
Your help would be greatly appreciated.

Thanks in advance,
Brad

 

[Duane Hookom]

You should split your database into a front end containing forms, reports,
queries, code,... and a backend mdb containing only the tables. Each user
can have their own copy of the front end on their hard drive and access the
tables in the back end that resides on a network drive.

 

[Brad]

Duane,

Thank you that works great.

Brad

You should split your database into a front end containing forms, reports,
queries, code,... and a backend mdb containing only the tables. Each user
can have their own copy of the front end on their hard drive and access the
tables in the back end that resides on a network drive.

--
Duane Hookom
MS Access MVP


drive