Allow Multiple Users

  • Thread starter Thread starter T Liden
  • Start date Start date
T

T Liden

I can see my last posting that states that I can't see my other postings in
this newsgroup, so I am going to try one more time. I apologize for the
duplicate messages, if there are duplicates.

When I try to open a database on two different computers, I get an error
stateing that the file cannot be open because it is already in use. How do
I correct this?

The database's default open is shared and it is not open exclusively.

Under the properties of the file itself, nothing is checked for readonly,
hidden or archive.

Thanks in advance for your help!!
Tim
 
T Liden said:
I can see my last posting that states that I can't see my other postings in
this newsgroup, so I am going to try one more time. I apologize for the
duplicate messages, if there are duplicates.

When I try to open a database on two different computers, I get an error
stateing that the file cannot be open because it is already in use. How do
I correct this?

The database's default open is shared and it is not open exclusively.

Under the properties of the file itself, nothing is checked for readonly,
hidden or archive.
Click to expand...

Do both users have FULL permissions to the network folder? They need to be able to
create, edit, and delete files so Access can create, edit, and delete the locking
file (LDB) for the database when it is opened by each user.
 
Thanks Rick for your response!!

What it came down to was the two users were using different versions of
Access, one was using Access 2000 and one was using Access XP. If there is
a way for these two users to work on the same database, that was created in
Access 2000, please let me know.

Thanks!!

Tim
 
Popsie Robinson said:
What it came down to was the two users were using different versions of
Access, one was using Access 2000 and one was using Access XP. If there is
a way for these two users to work on the same database, that was created in
Access 2000, please let me know.
Click to expand...

You need to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It also supports
Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top