Solved

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

Posted on 2007-04-06
13
667 Views
Last Modified: 2008-02-01
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
Comment
Question by:mikesandra
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 18864331
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
 
LVL 65

Expert Comment

by:rockiroads
ID: 18864372
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
 

Author Comment

by:mikesandra
ID: 18864450
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
 
LVL 34

Assisted Solution

by:jefftwilley
jefftwilley earned 100 total points
ID: 18864461
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
 
LVL 65

Expert Comment

by:rockiroads
ID: 18864485
Just as a test, have u tried mapping that network folder then link the table using the mapped drive?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 18864707
wb rocki!!!
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:mikesandra
ID: 18864724
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
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 18864753
these allows you to gain access  {FTP username and password  }
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 200 total points
ID: 18864760
contact your network administrator and ask them how to gain access to server/folder  from access database.
0
 
LVL 6

Assisted Solution

by:twintai
twintai earned 100 total points
ID: 18864887
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
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 100 total points
ID: 18864923
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
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 18864985
welcome back { wb }
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 18864996
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Creating and Managing Databases with phpMyAdmin in cPanel.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now