Solved

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

Posted on 2007-04-06
13
693 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 18864707
wb rocki!!!
0
 

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 120

Expert Comment

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

Accepted Solution

by:
Rey Obrero (Capricorn1) 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Industry Leaders: 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!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

733 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