Exclusive Access problem

G

george

How do i make changes to the data base when someone else is in the data base
it tells me i do not have exclusive access i know what it means but i need to
do running repairs while they work in the data base

Thanx
George
 
B

Brian

george said:
How do i make changes to the data base when someone else is in the data base
it tells me i do not have exclusive access i know what it means but i need to
do running repairs while they work in the data base

Thanx
George
Click to expand...

Can't be done. If Access says you need exclusive access, then you need
exclusive access.
 
N

Nick Coe \(UK\)

In george typed:
How do i make changes to the data base when someone else
is in the
data base it tells me i do not have exclusive access i
know what it
means but i need to do running repairs while they work in
the data
base

Thanx
George
Click to expand...

From Access 2000 on that's not possible. The way that
design data (also sometimes called metadata) is stored
within Access now makes exclusive locking of the application
necessary. I'm afraid you'll have to work on a copy then
substitute the copy for the production application, after
having kicked everyone out first.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
D

Douglas J. Steele

Just to expand on what the others have told you, the normal approach to
working with a shared database is to split it into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing just the tables). Only the back-end is on the server: each user
should have his/her own copy of the front-end on their hard drive. This
means that you can easily make changes into your copy of the front-end. Once
you're satisfied with the changes, you can give everyone a copy of the new
front-end. Tony Toews has a free utility to help with the redistribution at
http://www.granite.ab.ca/access/autofe.htm
 
J

John Vinson

anyone know how setup the outlook express
Click to expand...
Microsoft's Help system has landed you in the wrong newsgroup: this
one is for the database program Microsoft Access.

Please use the dropdown box (the one that says "Access" by default)
to select a more appropriate newsgroup.


John W. Vinson[MVP]

John W. Vinson[MVP]
 
Top