Could Not open table 'MSysAccounts' in the workgroup information file.

  • Thread starter Thread starter Neil Stevens
  • Start date Start date
N

Neil Stevens

Hi,

Let me explain a little first, i am writing a website and a backend console
application. The user (once logged in) can upload a file to the server and
the page will fire off a new process to the console application which will
run in the background on the server and verify the contents of the file,
since the files can be quite large i don't want the browser held up while
the ASP.NET server code processes the file, i just want it to upload the
file and fire off a process which will do all the work (if anyone knows a
better and quicker way of parsing and validating an ascii file im all ears).

Now, the problem that i have is that i am using an Access database, and all
the connections and data connectivity through the web site works fine, but,
when i try to run the console application i get the following exception
message when i try to open the connection to the database

dim myConnection as oledbconnection=new
oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path to db;")
dim myCommand as oledbcommand=new oledbcommand(strsql, myconnection)
try
myConnection.Open
catch ex as exception
' Exception occurs with this message
Could Not open table 'MSysAccounts' in the workgroup information file.
end try
......


does anyone know why this error is caused and what the resolution would be.

Regards
Neil
 
¤ Hi,
¤
¤ Let me explain a little first, i am writing a website and a backend console
¤ application. The user (once logged in) can upload a file to the server and
¤ the page will fire off a new process to the console application which will
¤ run in the background on the server and verify the contents of the file,
¤ since the files can be quite large i don't want the browser held up while
¤ the ASP.NET server code processes the file, i just want it to upload the
¤ file and fire off a process which will do all the work (if anyone knows a
¤ better and quicker way of parsing and validating an ascii file im all ears).
¤
¤ Now, the problem that i have is that i am using an Access database, and all
¤ the connections and data connectivity through the web site works fine, but,
¤ when i try to run the console application i get the following exception
¤ message when i try to open the connection to the database
¤
¤ dim myConnection as oledbconnection=new
¤ oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path to db;")
¤ dim myCommand as oledbcommand=new oledbcommand(strsql, myconnection)
¤ try
¤ myConnection.Open
¤ catch ex as exception
¤ ' Exception occurs with this message
¤ Could Not open table 'MSysAccounts' in the workgroup information file.
¤ end try
¤ .....
¤
¤
¤ does anyone know why this error is caused and what the resolution would be.

Are you using user-level security for your Access database?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
No, there is no security on the database at all.

I have duplicated the application on a seperate machine with the database
under a different name and it works fine. I believe the problem could be
related to me having called the database system.mdb.


 
¤ No, there is no security on the database at all.
¤
¤ I have duplicated the application on a seperate machine with the database
¤ under a different name and it works fine. I believe the problem could be
¤ related to me having called the database system.mdb.
¤

I believe that is the internal filename that the Jet database engine uses to reference the physical
user level security file (system.mdw).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
I had the same issue - The following fixed the problem:


opened up Access 2003 went to work groups - selected create ==> did not enter a workgroup ID ==> it came back with a default of system1.mdb ==> issue resolved ==> user happy to close off the case
 
Back
Top