Can anyone help.

In the following statement where I declare the source database, I want to put the full path of the network drive and not just the letter. There is a good reason for this.


+++++++++++++++++++++++++++++++++++++++++++++++++++++
db.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Developers\SCR Database\SCRsystem.mdb;"
+++++++++++++++++++++++++++++++++++++++++++++++++++++

Unfortunately it doesn't seem to like my syntax !

The full path for drive G is "\\nantserv\depts\it"

I even tried putting an IP address in front of that as well, but to no avail.

Can anyone let me know where I am going wrong ?


Thanks in advance.