"You do not have exclusive access to the database" error message

[Kim]

Hi all,

I have a database that others use and I have the problem that I can't
alter certain forms because others have the database open.

Is there a way to bypass this problem? I have been told that holding
the "shift" key down while opening the database gives me access, but
it doesn't seem to work.

FYI... I am only trying to change a form that no one else would be
using so there should be no need to restrict access.


Thanks all


Kim

 

[John Spencer]

In any Access database after Access 97 you must have exclusive use of the
database to make design changes.

That said, you should have your database split into two components - a front
end and back end. The back end contains your tables and the front end
contains, the forms, reports, code, macros, and LINKS to the table in the back
end. Each user should have a copy of the front end.

Now you can open a copy of the front end and make design changes to it and
test them. Once you have a good working design, you would replace the user's
copy of the front end with the new, improved front end.

There is a built-in option to split the database in all versions of Access.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Kim]

In any Access database after Access 97 you must have exclusive use of the
database to make design changes.

That said, you should have your database split into two components - a front
end and back end.  The back end contains your tables and the front end
contains, the forms, reports, code, macros, and LINKS to the table in theback
end. Each user should have a copy of the front end.

Now you can open a copy of the front end and make design changes to it and
test them.  Once you have a good working design, you would replace the user's
copy of the front end with the new, improved front end.

There is a built-in option to split the database in all versions of Access.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County








- Show quoted text -

Thanks a heap John. I'll try setting it up like that and see how I
go.

Kim