workgroup information file is missing

[dino624]

I receive the message 'Workgroup information file is missing when I try to open the following database.

psDB_CONNECT = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\IDEFIX_Offline\Reception_MATP.mdb;" & _
"System Database=c:\IDEFIX_Offline\IDEFIX.MDW;" & _
"User Id=UUUUUU;Password=pppppp;"

I have looked all over and can not find the answer.

HELP!!!

[RobDog888]

I think that the .mdw file is default location in the Winnt\system directory.
If you move it you need to change the registry setting telling
Access where it is located. Or if manually running, you can specify
a startup parameter of the .mdw location and name.

[dino624]

Can you give me an example of what the registry would look like?
I can access the database using access.

Thanks,

[RobDog888]

Sure, here it is.

'Reg location:
HKEY_CURRENT_USER\Software\Microsoft\Office\x.x\Access\Settings
 
'Pass a startup parameter for a particular db in the shortcut path 
'of a shortcut link.
/Wrkgrp "C:\secure.mdw"
 
'Access 2000 mdw location
\Program Files\Microsoft Office\Office\1033

[dino624]

I was not able to locate anything about the .MDW file in the registry. I did find the reg location.
I am also confused on how to set up the link you talked about. Do I use my .MDW file or the name "secure.mdw"

I am also not sure what I am supposed to do with this line youi sent: \Program Files\Microsoft Office\Office\1033

Thanks for the help...