Modify be

P

Pietro

Hi,
Mu database is used by around 50 users,I always need to modify some fields
properties while it's being used,is there a way to modify the be tables of my
database while it's being used ?
 
D

Douglas J. Steele

Unless the table being changed is actually in use while you're trying to
make the change, you should be able to make changes to the back-end even
while the database is in use.
 
D

Douglas J. Steele

Why can't you open the database to modify its design?

Do you get an error? If so, what's the error? If you don't get an error,
what do you get instead of the database opening?
 
E

Esperanza Ornelas

Pietro said:
Hi,
Mu database is used by around 50 users,I always need to modify some
fields
properties while it's being used,is there a way to modify the be tables of
my
database while it's being used ?
 
J

Jeff Boyce

If your Access application is "split" (front-end on each PC, back-end on
your network), you won't be able to modify the back-end FROM the front-end.
You'll have to open the back-end itself to change it.

All bets are off if the files are .mde files rather than .mdb files.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top