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

[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

[Paul Clement]

On Tue, 2 Dec 2003 11:41:17 -0000, "Neil Stevens" <stev...@iata.org> wrote:

¤ Hi,

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

Paul ~~~ pcle...@ameritech.net
Microsoft MVP (Visual Basic)

[Neil Stevens]

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.

"Paul Clement" <UseAdddressA...@swspectrum.com> wrote in message
news:2b5psv4i9lnc944ss...@4ax.com...

[Paul Clement]

On Tue, 2 Dec 2003 14:25:41 -0000, "Neil Stevens" <stev...@iata.org> wrote:

¤ 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).