Problem saving changes to table field on Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Piri - 04 Dec 2005 01:32 GMT

Using Access97
We have our data mdb on a server with users with their own FE MDE on
their local PCs.

An issue we have is that we cannot make a change to a data.mdb table
field (say increasing the length of a text field from 10 to 15) using
the server. After making the change we attempt to compact the mdb, but
the compact is unsuccessful and the data files is corrupted.

Yet we can make the change by copying the data mdb to a local PC, make
the changes and compact the data mdb - then copy back to the server.

Given we are also having some mdb corruption issues I wonder whether it
could be a Jet version issue?

Thanks,
Piri

Reply to this Message

G. Vaught - 04 Dec 2005 06:34 GMT

Do not make file structure changes while the database is in use. Any data
structure changes needs to be done after hours or ensure everyone is out of
the database. Open the database BE in exclusive mode and then make the
change. To open exclusive open Access first, then from the little dropdown
box at the right-hand corner select the Exclusive mode.

The reason it works on a different computer is because there are no links
to that computer from the front-end, thus the database is opened
"exclusive".

> Using Access97
> We have our data mdb on a server with users with their own FE MDE on their
[quoted text clipped - 13 lines]
> Thanks,
> Piri

Reply to this Message