Workgroup 97

[Arne Garvander]

I have Access 2003 and Access 2007 installed.
I am writing an ad hook program in .Net that needs to open and old Access 97
database . I get the Error {"Cannot start your application. The workgroup
information file is missing or opened exclusively by another user."}
My connection string is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tapelib\roster97.mdb;User
Id=admin;Password=;
What am i doing wrong?

 

[david]

Can you open roster97.mdb in 2003 or 2007?
Can you link to tables in roster97 from a 2003 or 2007 database?
Can you open a 2003 or 2007 mdb using that Provider?
Is the system.mdw file in an unusual location?

You can add the full path to the provider string:

Jet OLEDB:System database=C:\Program Files\Common Files\System\System.mdw;

 

[Arne Garvander]

I can open Roster97.mdb in Access 2003 and 2007.
I can't open it in a .Net app. I tried the System.mdw in the connection
string but it does not do anything. (Might do something when Access 97 is
installed on the system) I have to try another approach.
Thanks for the answer.

 

[david]

string but it does not do anything. (Might do something when Access 97

installed on the system) I have to try another approach.

If you can open in A2003, A2003 must be able to find
and open a suitable MDW. Installing A97 will probably
try to put another MDW on your machine, but that clearly
is not required, because you can already open in A2003.

If you have found a MDW and pointed to it, I guess the
next thing is to check the permissions on that file and folder.

(david)

 

[Arne Garvander]

I found another solution.
I made a linked table inside Access 2007 that poins to my access 97 table.
Now I can open my linked table directly from a .Net program with no
complaints about the system database/workgroup.