Half-hearted "Could not open table 'MSysAccount' in the workgroup information file

  • Thread starter Thread starter Ilan
  • Start date Start date
I

Ilan

I am using Access xp on Windows xp on my own standalone computer.

I have written a program in VB6, and am still testing it on my computer.
The program accesses an Access database.

The code has these lines:

Dim cnnNet As ADODB.Connection
...
cnnNet.Provider = "Microsoft.Jet.OLEDB.4.0"
cnnNet.Open strDB

Each and every time I run the code, the line "cnnNet.Open strDB" causes the
error "Could not open the table 'MSysAccount'. The cursor then stays on
that line, waitimg for me to debug. The solution is easy: press F5 (or F8)
and the program continues happily (error trapping and then resume does not
work though).


This behavour is very odd of course, an error which resolves itself if the
computer is allowed to hang for a while. But my main concern: when I
compile the program and send it to others, will they get the same error? I
think not, because connecting to database is more to do with the end user
database. Nonetheless, if any one could offer a solution so that the
program runs smoothly while testing it on my computer, I would be grateful.

Many thanks


Ilan
 
Back
Top