• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 780
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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