Only one person can use my DB at the time

[David]

When some one opens my DB, it creates a .ldb file and no other users can open
it. some users have MS2007 and others MS2003. Help!

 

[Arvin Meyer [MVP]]

Make sure that no one is opening it exclusively. Secondly, make sure that
your database is split, and that each user is working on a front-end from
their own workstation:

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

 

[MikeJohnB]

(USE A COPY OF THE DATABASE)

Split the front end from the back end (All forms Queries reports etc = front
end Tables = Back end) There is a wizard to do this it will link the tables
to the queries, forms and reports part.

Once you have done that, copy the front end to the 2003 users. (Each will
have his own front end)

Open a copy of the front end in Access 2007, convert that copy front end to
2007, copy and distribute a copy of that to all the 2007 users (Each will
have a 2007 copy on their computers)

Now you have many front end users both in access 2003 and 2007 which all
address the same tables and hence the same data.

There are pitfalls to entering data in seperate front ends. If two people
enter a new record at the same time, things like sequence numbers or record
numbers can cause problems but there are ways around that to a degree.

 

[Tony Toews [MVP]]

There are pitfalls to entering data in seperate front ends. If two people
enter a new record at the same time, things like sequence numbers or record
numbers can cause problems but there are ways around that to a degree.

Generally users should never see those autonumber keys anyhow.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[MikeJohnB]

Generally users should never see those autonumber keys anyhow.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Agreed, the comment wasn't aimed at the users, but thanks for clarifying the
statement