• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 873
  • Last Modified:

Linked Table Manager in Access 2002 Error: "Not a valid file name"

I need help with an error I'm receiving from Access 2002 when I'm trying to use the Linked Table Manager.  The database I'm looking for is on "My Network Places".  I see the database I want to link to and when I click on it Access shows an error window that says "Not a valid file name".  I don't understand this.  What's wrong with the file name.  The file name of the database is employees.  Has anyone ever come across this before?
0
mikesandra
Asked:
mikesandra
  • 5
  • 4
  • 2
  • +2
4 Solutions
 
Rey Obrero (Capricorn1)Commented:
try opening the database from that folder.
see if you can open it.  { not using the  linked table manager }

go to the loaction and doubleclick on the db
0
 
rockiroadsCommented:
Do you know the full unc path of the database?
ie \\somenetwork\somefolder\file.mdb

try using that instead of browsing, see if it makes a differnence

Do u have any non alphanumeric characters in the path or filename? One of those might be why Access is complaning
0
 
mikesandraAuthor Commented:
I am able to open the database outside of the Linked Table Manager.  I have no non alphanumeric characters in the path.  I tried typing in the link manually but I received the same error back "Not a valid file name".
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
jefftwilleyCommented:
Always nice to hide a small function in your database that you can call on to give you the "path". tie it to a macro so you can Bat or Shell into it.

Function MyPath()
msgbox Application.CurrentProject.path & "\"
End function

0
 
rockiroadsCommented:
Just as a test, have u tried mapping that network folder then link the table using the mapped drive?
0
 
Rey Obrero (Capricorn1)Commented:
wb rocki!!!
0
 
mikesandraAuthor Commented:
I don't have permissions to do that.  However, I am able to access all the files through Dreamweaver.  I typed in the FTP username and password and I see all the files and can open them up.  But when I go through my network places I get the message "Not a valid file name" when I try opening up any access database.
0
 
Rey Obrero (Capricorn1)Commented:
these allows you to gain access  {FTP username and password  }
0
 
Rey Obrero (Capricorn1)Commented:
contact your network administrator and ask them how to gain access to server/folder  from access database.
0
 
twintaiCommented:
You should also try Compact & Repair on both database. Sometimes, Access Dbs just act wierd and that seems to help resolve the problem.

After C/R on both, try to link and see if it works.
0
 
rockiroadsCommented:
cap, warner brothers? LOL, sorry mate, dont know what wb means

if its ftp, you wont be able to link in tables like that. Dont think creating it as a ODBC entry will work either
What if you mapped your ftp server as a drive, then link in tables that way
eg  http://www.windowsitpro.com/Articles/ArticleID/14486/14486.html?Ad=1

Have u tried connecting like this
ftp://servername/file

0
 
Rey Obrero (Capricorn1)Commented:
welcome back { wb }
0
 
rockiroadsCommented:
oh,  doh!!

thanks cap :)

its good friday here in the UK (bank holiday), Ive been busy cleaning now taking a breather. Thought I'd check up on EE.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 5
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now