Compacting database limits network access

[Zepher2]

I have a database one computer running WindowsXP. Two other computers were accessing this database without problem. I compacted the database and now the other two computers are unable to access the database.

What did I do wrong and how do I fix it? Any help will be appreciated.

 

[KenReay]

Hi

What is the error message you are getting?

Could it be a permissions problem?

Compact creates a new mdb, and then renames it, so it may not have inherited the same permissions as the original Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Zepher2]

Thanks, it was the permissions,which were reset. I fixed the problem by deleting the database from my XP computer. I copied a backup of the database to a Win 98 computer, compacted it and then copied that database to the XP computer. Probably not the best way to resolve the issue, but it worked/