Solved

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

Posted on 2007-04-06
13
654 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

757 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

22 Experts available now in Live!

Get 1:1 Help Now