Opening 2003Db from multiple users in 2007

[JJ Runnion]

One of our departments has a database that they share and used to be able to
have several different users have open at the same time from a mutually
shared link to the db. However, since we upgraded to Office 2007, they find
that only one of them can open the file at a time.

They are able to open Access, then go to the file open and get it. However,
they would like the funcionality they previously had without having to search
the explorer folders for the correct folder and filename.

Any ideas what may be going on here? Please note: I am in IT, but i am not
an Access user or developer so be kind

Thanx!

 

[John W. Vinson/MVP]

One of our departments has a database that they share and used to be able to
have several different users have open at the same time from a mutually
shared link to the db. However, since we upgraded to Office 2007, they find
that only one of them can open the file at a time.

They are able to open Access, then go to the file open and get it. However,
they would like the funcionality they previously had without having to search
the explorer folders for the correct folder and filename.

Any ideas what may be going on here? Please note: I am in IT, but i am not
an Access user or developer so be kind

Thanx!

You *really* need to "split" the database into a "backend" containing
the tables, and a "frontend" containing the forms, reports, queries,
etc. Each user should have their own copy of the frontend, all
pointing to the data in the backend. See

http://www.granite.ab.ca/access/splitapp.htm

or do a Google search for "Access database split".

 

[Tom Wickerath]

Hi JJ,

As John Vinson as already said, you need to split the database and
distribute a copy of the FE to each user's local hard drive. Here is an
article that I think you will find helpful:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________