Make Table Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I am trying to add a UNC path in a Make Table Query in an external Access
2000 database.

I have used:

\\severname\pathname\databasename

but it always says that it is not a valid path.

Can someone suggest where I could be going wrong

Thanks again.

Alastair MacFarlane
 
Did you include the .mdb at the end of the db name?

Permissions? Write access?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...
 
Allen,

As far as I can see I have entered the correct path. The only complication
is that I am linking between a Citrix Server with an Access 2000 instance and
and another server on our domain. I have checked and I can browse to the
database using the Citrix logon so it is not a permissions and I have copied
the url from the file properties and the server name.

I thought the issue was to do with a quote round the UNC path or three
backslashes instead of two, etc.

I can work around this problem but it is an annoying one.

I appreciate your help.

Alastair MacFarlane
 
It should work, so there must be another factor here.

The fact you can browse there does not mean you have write access.
The network share might be read-only, or the file could be.

Open the Immediate Window (Ctrl+G), and enter:
? Dir ("\\severname\pathname\databasename")

If that works, try copying another file to that same folder, e.g:
FileCopy "C:\MyFile.txt", "\\servername\pathname\MyFile.txt"


If that all works, post the SQL statement you are trying to use.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
 
Allen,

I have to rush out of the office. I will try out your suggestions and get
back to the group.

In haste.

Alastair
 
Back
Top