We have 8 computers that access the same database on our server that are all
access 2003. The database itself was create in 2003. When one computer that
is running Access 2007 opens the database no one else can open the database.

When a 2007 client doesn't have it open all the other 2003 clients can open
it up at the same time. I believe that their is a security setting I am
missing, any help would greatly be appreciated.

You need to split your database. The front-end with the objects should be on
EACH workstation, linked to the data on the server. There is a wizard to
help you:

Tools >>> Database Utilities >>> Database Splitter

Not splitting your database will eventually cause corruption.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Nicholas Alexander" <Nicholas (E-Mail Removed)> wrote in
message news:5FA27462-2056-4758-85C2-(E-Mail Removed)...
> We have 8 computers that access the same database on our server that are
> all
> access 2003. The database itself was create in 2003. When one computer
> that
> is running Access 2007 opens the database no one else can open the
> database.
>
> When a 2007 client doesn't have it open all the other 2003 clients can
> open
> it up at the same time. I believe that their is a security setting I am
> missing, any help would greatly be appreciated.
>
>