Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compact and Repair Causes Problem

Status
Not open for further replies.

mkatz13

Technical User
May 26, 2003
17
0
0
US
Hi.

I have a 3 machine windows network connected by hub. Two machines run Xp and one is 2000 professional.

I run access 2000 on all machines and the mdb resides on a shared folder on one xp machine.

All is fine until I run compact and repair. After I run this, the 2 machines on the network cant find the mdb. If I move the mdb out of it's folder and then copy it right back, all is fixed.

All open access in shared mode, and when I run compact and repair all other users are logged off before I start. All is fine on the machine on which the mdb lies.

Any Ideas?

Thank

Mike Katz




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top