Hello,

I'm Using ADOX and try to Connect with mdb3x Database (Access97 version ). Everything Is OK, but if I use Provider: "Microsoft.Jet.OLEDB.4.0", I receive an error, '0x80004005' --> 'Unspecified Error' and Description :
"Could not open table 'MSysAccounts' in the workgroup information file.". If I repair this Database with MSAccess, Everything is OK, but I cannot repair it from my program via DAO, OLEDB, MSJRO (that has been interrupted... ). All methods give me same Error.

Any Ideas? Does somebody know which way use MSAccess to repair DataBases ???

P.S. I want to use 4.0 provider, becouse 3.50 and and 3.51, are very bugs.

Regards:
KalliMan

I found my Solution.
In Cnn String u must Specify System DB path i.e. Your Connection String must be :
L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\MyDB.mdb;Jet OLEDB:System database=C:\\System.MDW" !
KalliMan

I had the same problem. But the solution was to change the database name from system.mdb. The problem will stay if you have a database called system.mdb in that directory. I found the solution accidently.

"Could not open table 'MSysAccounts' in the workgroup information file."

I received this error when trying to migrate an access 2000 DB to SQL 2005 using the migration assistant.

DB name was system.mdb!

Changed the name and voila.

Thanks bakour.

I have had the same problem and no-one seemed to know why.
After reading your post it all became clear.

Thanks for posting your solution.. It helped me no-end

Regards from
~Mike~

Wow, man you are Ginus :) ... i had same problem and couldn't find solution till i read this post

Thanks a lot for posting :)