We have a small network. Several users are able to update the Access 2000
db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I compacted the db. I did this by opening the db on the pc where the db exists. I went to tools/database utilities and selected "Compact an repair database". Since compacting the database users who log on via the shared network drive can no longer open the db. The message they get is: "Microsoft Access can't find the database file 'H:\filename.mdb'". If I open Windows Explorer and log onto the network drive "H:\" I can see "filename.mdb" in the file list, but if I try to open the db I get the same message. I made a copy of the db before I compacted and the copy works just fine from the remote PC's. However, changed to the compacted db have already been made so we cannot revert to the copy. How do I correct this problem?
db from their workstations because I've shared the folder in which the db is saved. They have complete access to do changes to the design of the db as well as update data. Because the db size was getting excessive I compacted the db. I did this by opening the db on the pc where the db exists. I went to tools/database utilities and selected "Compact an repair database". Since compacting the database users who log on via the shared network drive can no longer open the db. The message they get is: "Microsoft Access can't find the database file 'H:\filename.mdb'". If I open Windows Explorer and log onto the network drive "H:\" I can see "filename.mdb" in the file list, but if I try to open the db I get the same message. I made a copy of the db before I compacted and the copy works just fine from the remote PC's. However, changed to the compacted db have already been made so we cannot revert to the copy. How do I correct this problem?
