## MS Access DB on a network drive...

Hey,<BR><BR>I&#039;m trying to connect to a DB on a mapped network drive, but I&#039;m having problems. The following connection seems to work because my error is coming from much later in the code.<BR><BR> dbPath = "\snapSnapMikeDBWeb.mdb"<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath<BR><BR>The error I do get is:<BR>"&#039;Z:DatabaseDataTablesDataTables.mdb&# 039; 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."<BR><BR>So it looks like my network drive of (\snapsnap...) is requesting tables from Z:Database... and can&#039;t get them. The network drive with the original DB I&#039;m connecting to (\snap...) is also mapped to the Z: drive, but is in a different folder z:Database...<BR><BR>What have I done wrong? I have also tried connecting with:<BR><BR> dbPath = "Z:MikeHeritageDBWeb.mdb"<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath<BR><BR>but that gives the following error:<BR><BR>&#039;Z:MikeHeritageDBWeb.mdb&#039; 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.<BR><BR>My page used to work, but since I got a new computer (and had to remap the network drives) it &#039;s not working anymore...<BR><BR>Thanks,<BR>Mike