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!

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"David" <David@discussions.microsoft.com> wrote in message
news:690E372F-7A8F-4396-9D6B-F1E2E9D77C57@microsoft.com...
> 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!

(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.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"David" wrote:

> 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!

MikeJohnB <MikeJohnB@discussions.microsoft.com> wrote:

>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/

"Tony Toews [MVP]" wrote:

> MikeJohnB <MikeJohnB@discussions.microsoft.com> wrote:
>
> >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/


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

--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B