Could not open table MSysAccounts

[sanjay84]

Hi I'm experiencing a problem with opening/creating a MS Access database, an .mdb (MS Access 2000). whenever I try to establish a connection to a database I get this problem:

Run-time error '-2147217843(80040e4d)':
Could not open table 'MSysAccounts' in the workgroup information file.

I have googled this problem a few times and there was no clear solution to my problem. It is related to the file system.mdw it could be corrupted. when I run the application on someone else's computer it goes fine.

Anyone who has experienced the same?

 

[Remou]

Someone else probably does not have a corrupt system.mdw. I guess you do not have Access security on any databases that use this file (you shouldn't have)? You can search the registry to find out where system.mdw is supposed to be, rename it and copy a working system.mdw from the PC that worked, or add it, if it is missing.

 

[sanjay84]

thanks remou for the answer.

I found a solution on this site:

http://www.compaid.nl/content/view/52/58/

if you create/open a database with a ADOX.Catalog one need to add the system database in the connectionstring.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;

it worked for me so far ... crossing my fingers