workgroup information file using OLE DB

[Guest]

Hi I am trying to utilize the label printing program I have to print from
Access. It has an option for OLE Db, and I can choose the Jet 4.0. But when I
select the database - which is for now just a copy of the actual database -
it gives me the message: The Workgroup information file is missing or opened
exclusively by another user. (The actual database is secured by joining the
workgroup). I know no one is using it since its the test database. Can anyone
give me an idea of how to workaround?

My main intent is to print product labels using a query or exported excel
spreadsheet from the Access Database. Perhaps the software I'm using just
isnt saavy enough (Teklynx LabelView Pro 6.0) Does anyone have a label
program that plays well with Access?

Any information that anyone can provide will be greatly appreciated....

 

[Brendan Reynolds]

If you're not using the default workgroup file, you need to specify the file
to be used in the connection string. Here's an example ...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\Brendan Reynolds\My Documents\Northwind.mdb;Persist Security
Info=False;Jet OLEDB:System database=c:\dsdata\test.mdw

 

[Guest]

Is the default name System.mdw? <thanks>

If you're not using the default workgroup file, you need to specify the file
to be used in the connection string. Here's an example ...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\Brendan Reynolds\My Documents\Northwind.mdb;Persist Security
Info=False;Jet OLEDB:System database=c:\dsdata\test.mdw

 

[Brendan Reynolds]

When Access is installed it defaults to using system.mdw, yes. But that
could have changed. Do you usually start this database from a shortcut icon?
If so, look at the properties of the shortcut icon to determine which
workgroup file is used. If you don't start from a shortcut icon, check the
workgroup administrator to see which workgroup you're joining. (Tools,
Security, Workgroup Administrator in Access 2003, details may differ in
other versions).

You mentioned that this is a copy of the database. Is it a copy of a
database on your PC, or did you copy it from another PC? If the latter, you
may need to copy the workgroup file from that PC too. If you do, avoid
overwriting your own system.mdw or you may have problems with other
databases. It would be a good idea to make backup copies of any mdw files
you have on your system before changing anything.