problem running my program on network

[micky500970]

Hi,

I have written a program in VB using ADO and Access. I am ready to start trialing it now and have placed the DB within a shared folder on the server. However I get the following error when I run my program:

Run time error -2147217843 cannot start application. The workgroup file is missing or opened exclusively by another user.
Nobody is using it yet and I can open the DB by using \\10.0.0.116\bts$\db1.mdb orthis shortcut:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" \\10.0.0.116\bts$\db1.mdb /WRKGRP "\\10.0.0.116\bts$\masha.mdw" /user jono /pwd.

This is drivingme crazy - any ideas would be much appreciated.

Cheers

Mick

If I run it from the "C" drive it works fine - ovbiously changing the path.

 

[kmfna]

We had a problem similar to this, where I work. There was somehow a difference in the versions of Access on the server and on the local box. Strangely, we even had the same error, though the two things do not seem related. You may try copying the data to a new table. If that fails, you may try checking the user permissions on the share folder, is it possible that the user doesn't have permission to use the file? Or maybe not see it?

Good luck,
Kevin

- "The truth hurts, maybe not as much as jumping on a bicycle with no seat, but it hurts.

 

[SonOfEmidec1100]

Maybe the prob is in the connection string, does it look something like this ?

    .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"
        & "Data Source= \\server\share\db1.mdb;"
        & "User Id=jono;Password=MyPassword;Jet OLEDB:System database = '\\server\share\mash.mda';"