Hi,

I cannot figure out the syntax to create a datasource to a db located on a mapped drive. I get the same error which is [location of db] is not a valid path'. I've tried all the following but none work:

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=M:\MergedActions.mdb", "", ""

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=M:/MergedActions.mdb", "", ""

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\sharedFolder\db\cis\MergedActions.mdb", "", ""

Shouldn't that be

\\ServerName\ShareName\SomeFolder\SomeFile.mdb??


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

No that did not work either.

Can you describe "did not work"??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

I agree with Imar, your UNC path CANNOT be what the sharefolder is called, it has to be referenced with \\ServerName\share\folder\some.mdb

and really it should be something like this:

\\Server\C$\sharedfolder\theMDBfile.mdb

C$ should be replaced by the appropriate drive letter (but you must maintain the $ symbol)
so:
D == D$
E == E$

etc.

Hth.

"The one language all programmers understand is profanity."

Not necessarily.

The $ syntax is used to access administrative shares that are always present. However, you can also create and name your own shares. So, a path like:

\\ServerName\ShareName

could be perfectly valid.

If we know the error, we may be able to advice more. Maybe this is a security issue?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Error Type:
Microsoft JET Database Engine (0x80004005)
'\\myserverName\sandshare\winSHARE\db\cis\Web_Deve lopment\MergedActions.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/metrics/CommitToClose.asp, line 42

Right, that's what I thought. 80004005 errors are almost always security related. Check out these FAQs:

http://Imar.Spaanjaars.Com/QuickDocId.aspx?quickdoc=263
http://Imar.Spaanjaars.Com/QuickDocId.aspx?quickdoc=276
http://Imar.Spaanjaars.Com/QuickDocId.aspx?quickdoc=287

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

thank you, I'll take a look at these articles.

Thanks for pointing that out Imar, I assumed since he was mapping a network .MDB that the share would always be available, you are correct however.

"The one language all programmers understand is profanity."