system.mdw

[Bob724]

Does anybody have any experience with the problem of not being able to access the system workgroup file ("system.mdw")? This is run-time error 3358. It says "Can't open the Microsoft Jet engine workgroup file".

Do you guys know what to do in this situation? I tried this:
I created a text file 'system.mdw' in 'C:\Windows', and then wrote the following code:
DBEngine.SystemDB = "C:\Windows\system.mdw"


But I still get the error.

Can anybody help out? I'd really appreciate it.

Thanks,

______

Bob K.

[Jimbob]

the easiest way i know of making a system.mdw is by using the workgroup administrator

run the file Wrkgadm.exe which likes in c:\windows\system click create and fill in your details

hey presto you've got an system.mdw made.

alternativeley, there should already be a system.mdw in c:\windows\system that you cna log into as Admin with no password - usually looks something like this


DBEngine.SystemDB = "c:\windows\system\system.mdw"
Set ws = CreateWorkspace("Ticketing", "Admin", "", dbUseJet)

obviously need to declare was as a workspace..

[Bob724]

That sounds great, but I can't find that file-Wrkgadm.exe or anything that even looks like it.

The actual system.mdw file isn't anywhere on my computer, either. I searched Windows help, and it didn't say anything about it.

I'm kinda lost here. Got any more suggestions? Is there some place that I can find some files on the internet or something?

By the way: I don't know if it matters, but I'm using an NT computer. Does that make a difference?

Please Help!

Thanks,

______

Bob K.

[Jimbob]

that's a bit of a downer....

under NT it lives in winnt\system32, and has the same file name.

have you got office installed, because i've a funny feeling it's installed during access setup

if not, try installing it, then having another look. it's worth doing anyway, because the access help gives lots of useful information about creating accounts etc

if you do heve access installed, you could try having a look on the ms website to see if there's a download. it's quite a small file (less than 50k think) so shouldn't take too long to download

[Bob724]

You're absolutely right!

I got it all squared away now.

Thanks a lot.

______

Bob K.