Updating the link in a Linked Table.

[Guest]

Recently at work we moved an Access Database from a local drive to a network drive. When it was moved the DB came up with the error "C:\Audio Conference is not a valid path", which makes sense because the database is now on our F: drive. It also comes up with an Action failed dialog that looks like the following

Macro Name
Autoexe

Condition:
Tru

Action
OpenQuer

Arguments
qrySaveSched, Datasheet, Edi

Now here's the killer... I have some Access experience but I didn't design this Database. The designer has moved to a different department and can't be bothered with this little DB he created a couple years ago. From what I have gathered so far it uses loops to create schedules (for Audio Conferences) that people can access via the web. Now I have determined that there are two linked tables that need to be updated. The program still thinks they're both on the C: drive. So I tried to use the linked table manager to update their location to the F: drive, but when I try hitting "Open" after browsing to their new location on the F: drive, I get "External Table is not in the expected format"

If anyone can give me some insights as to what is going on here, I would be very grateful

Thanks a lot for the help

Kris

 

[Arvin Meyer]

Are they Access tables? Can you open them independently? Access can link to
many kinds of data and you may need to delete the links and re-create them
using the correct file type.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Recently at work we moved an Access Database from a local drive to a

network drive. When it was moved the DB came up with the error "C:\Audio
Conference is not a valid path", which makes sense because the database is
now on our F: drive. It also comes up with an Action failed dialog that
looks like the following:

Macro Name:
Autoexec

Condition:
True

Action:
OpenQuery

Arguments:
qrySaveSched, Datasheet, Edit

Now here's the killer... I have some Access experience but I didn't design

this Database. The designer has moved to a different department and can't
be bothered with this little DB he created a couple years ago. From what I
have gathered so far it uses loops to create schedules (for Audio
Conferences) that people can access via the web. Now I have determined that
there are two linked tables that need to be updated. The program still
thinks they're both on the C: drive. So I tried to use the linked table
manager to update their location to the F: drive, but when I try hitting
"Open" after browsing to their new location on the F: drive, I get "External
Table is not in the expected format".

 

[Jeff Boyce]

The first thing I'd check is whether the new, back-end tables are still in
Access. The second is whether the Access back-end tables were written using
the save version of Access as the front-ends. It is this latter condition
that typically causes a problem with Access not being able to recognize the
format.

 

[Guest]

I can't tell exactly what the tables are because I can't open them
When I try to open them I get C:\Audio Conference is not a valid path
Like I said, I didn't make this database so I'm not sure what they are linked to
Is there any way to find out
In the properties they are called "Table: Linked Paradox" and are represented by "->Px" in the database

Hope that helps to narrow it down some

 

[Arvin Meyer]

I can't tell exactly what the tables are because I can't open them.
When I try to open them I get C:\Audio Conference is not a valid path.
Like I said, I didn't make this database so I'm not sure what they are linked to.
Is there any way to find out?
In the properties they are called "Table: Linked Paradox" and are

represented by "->Px" in the database.

Hope that helps to narrow it down some.

I t certainly does. The tables are Paradox tables, not Access, so you'll
need to delete the old links and create new ones to the path on the server.
That's done by selecting the tables in the Access front-end, then deleting
them. They should be links (i.e. have a small black arrow pointing to them)
so you are not deleting the table, just the link. Then choose File ... Get
External Data ... Link Tables, and a dialog form will open. Change the file
type to the Paradox version you have and find the tables on the server. Then
select them and create new links. Make sure the files have the same name in
Access that they previously did or nothing will work correctly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access