MSysAccounts & MSysGroups

[HomeGrowth]

One of my databases has linked the System MDW file to access the MSysAccounts and MSysGroups tables. The database was developed under Access 2000, and now we are upgraded to Access 2003. The upgrade didn't generate a problem until I.T. change the directory of the backend data. Now I have trouble re-link these tables via the System MDW file. Here are my problems.

When I tried to re-link, it gave an error message: "MSysAccoutns is not a valid name. Make sure that it does not include invalida characters or punctuation and that is not too long."

Then I tried to delete, it gave an error message : "Could not lock table 'MSysAccounts', currently in use by user '(unknown)' and machine '(unknown)'"

And I couldn't link those tables again because I couldn't see them any more (under Microsoft Access type file).

Can someone offer suggestion to work around this problem. I use these tables to lookup what group of the user belongs to, so different start form will be opened. Thanks

 

[JerryKlmns]

You can always open a connection object to your mdw file (which after all, it is just another Access database) and execute your queries using that conection!

And ofcourse link those tables with VBA. ADOX worked for me

All these on A2003 format database. MDW a A2000 format
Can't test for MDW A2003 format though!