Access and Linked Table Problem

  • Thread starter Thread starter James Edwards
  • Start date Start date
J

James Edwards

I have an access database that has been developed by someone else. I believe
there is a linked table in the table and when I try and open the database,
it is saying:

"\\ServerName\ShareName\FolderName\LinkedDatabase.mdb" is not a valid path.
Make sure that the path name is spelled correctly and that you are connected
to the server on which the file resides.

I am not on the network it was developed on, but have a copy of the
LinkedDatabase too. I want to get into the main menu to run Linked table
manager but the custom menu prevents it from displaying. It's been a few
years since i have worked with access, but I seem to remember a shortcut key
or startup parameter you could use to display the database window and full
toolbar even if it started straight into a form. I have tried F11, Ctrl+F1,
but I am not getting any further than the error message.

Any Idea's??

thanks in advance...James
 
Hi James

Try holding down the shift key while opening the database. Unless the shift
key has been disabled, you should see the Access window on startup as well as
the full menus, allowing you to then relink your tables.


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Thanks, I have just tried that but the problem remains. The database is
actually not
password protected, but is using it's own internal code to show a logon form
and prompt for a password. Is there a way of modifying the paths externally?
 
Hi again James

Are dealing with an MDB or MDE database file? Or would there be a Workgroup
file associated with the database ( MDW) ?
(you can email if you want)

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Before executing the code below, the MDB "TestApp.mdb" contains links to
tables in the MDB "OldData.mdb". After executing the code, "TestApp.mdb"
contains links to tables in the MDB "NewData.mdb". All MDBs are in the same
folder as the MDB from which this code is executed. This is DAO code, and
requires a reference (Tools, References in the VBA editor) to the Microsoft
DAO 3.6 Object Library.

Public Sub ChangeLinks()

Dim db As DAO.Database
Dim tdfs As DAO.TableDefs
Dim tdf As DAO.TableDef
Dim strOldData As String
Dim strNewData As String

strOldData = CurrentProject.Path & "\OldData.mdb"
strNewData = CurrentProject.Path & "\NewData.mdb"
Set db = DBEngine.OpenDatabase(CurrentProject.Path & "\TestApp.mdb")
Set tdfs = db.TableDefs
For Each tdf In tdfs
If UCase$(tdf.Connect) = ";DATABASE=" & UCase$(strOldData) Then
tdf.Connect = ";DATABASE=" & strNewData
tdf.RefreshLink
End If
Next tdf
db.Close

End Sub

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Hi Maurice,
It's just an access 2000 .MDB. I am trying to open it in Access 2003, but
after I get the warning about the macro's, I get the form asking for login
info. There is no .MDE and no .MDW. I have tried using SHIFT as I open it,
but it doesn't prevent the code running..I don't get the full toolbar or the
DB window.
 
Back
Top