CANNOT JOIN SYSTEM.MDW 1

[kw2oak]

I created a new 'workgroup information file' and joined 12 PC's to it.

After changing some workgroup settings I found I could not get other pc's to join, suddenly I started to get 'Access Denied' messages.

 

[psemianonymous]

Has everyone 'disconnected' from the MDW file? If so, and upon reconnect they get the same message, then ... I don't know exactly what the problem is.


For step one, get absolutely everyone off of the workgroup file (i.e. close down all Access windows), then try and reconnect them after everyone's out. This may fix the problem.


There's too many possibilities. Another possibility: your MDW file has corrupted (it's just a different-extension MDB file, after all). See the corruption link below, though I doubt this is your problem.


Good luck, and reply back if you have more specifics.


Pete

 

[kw2oak]

Thanks for the suggestion. I have made everyone log out of Access and close all windows but still no luck. (There were others using Access when I initially went to each PC and made them 'join' the workgroup, but this appeared not to affect the task.)

I do not know whether I should be able to 'repair' the MDW file but I tried anyway. The 'compact and repair' will not complete, It just 'hangs' - a copy of the file has been made (i.e. when I look in Windows Explorer) but the file cannot be opened.

 

[psemianonymous]

I think your MDW has corrupted -- and, again, I could be wrong.

But if I'm right, you need to get a working copy. Maybe there was some sort of automatic backup that you can restore from? Maybe your IT/IS department can do that for you?

That, or you get to recreate a MDW.

Or, you try and fix the one you have. I have a link to Tony Toews' page on corruption.

When I'm compacting/repairing MDW files, I just manually rename them to .MDB, then compact/repair, then rename back to .MDW . So far that hasn't failed.

 

[kw2oak]

Thanks for this tip - I suspected a corruption of the MDW but was put-off this by the fact that the 12 PC's already joined appear to work fine.

I am visiting the site where this is a problem again next week and I will let you know how I get on

 

[psemianonymous]

One more thing. I mentioned a 'link', and I consistently forget to include the link. See below:

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm