V
Vel
Hello,
I've noticed that whenever I do a Compact/Repair on the
backend of one of my most important network-databases, I
somehow "break" the link to its tables. After doing this
I get the Opened Exclusive or Read Only error, and I can
also no longer just go view the file from other computers
on the network. This only happens after a Compact/Repair
on the backend. It is EXTREMELY frustrating. I can
overcome the problem by moving the file somewhere else
and relinking it.
Things I've checked to solve it:
1. Folder Permissions are all appropriately set.
2. Individual file permissions are all appropriately set.
3. Temporary files created in folder are deleted or non
existant.
It's a very strange problem, and it is quickly fixed
simply by moving and relinking the tables, but this is a
workaround I'd rather not have to deal with. The file
becomes inaccessable over the network after the
compact/repair. I can see it to open it, but if I try it
says something along the lines of
Could not find file //Server/Databases/TrackingBE.mdb
Any suggestions?
Vel.
I've noticed that whenever I do a Compact/Repair on the
backend of one of my most important network-databases, I
somehow "break" the link to its tables. After doing this
I get the Opened Exclusive or Read Only error, and I can
also no longer just go view the file from other computers
on the network. This only happens after a Compact/Repair
on the backend. It is EXTREMELY frustrating. I can
overcome the problem by moving the file somewhere else
and relinking it.
Things I've checked to solve it:
1. Folder Permissions are all appropriately set.
2. Individual file permissions are all appropriately set.
3. Temporary files created in folder are deleted or non
existant.
It's a very strange problem, and it is quickly fixed
simply by moving and relinking the tables, but this is a
workaround I'd rather not have to deal with. The file
becomes inaccessable over the network after the
compact/repair. I can see it to open it, but if I try it
says something along the lines of
Could not find file //Server/Databases/TrackingBE.mdb
Any suggestions?
Vel.