| | |
|
|
|
Updating the link in a Linked Table. |
|---|
| message from =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004 |
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".
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 replied to =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004 |
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.
|
| Jeff Boyce replied to =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004 |
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.
|
| =?Utf-8?B?S2xpbGxlc3RvbA==?= replied to =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004 |
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 replied to =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004 |
represented by "->Px" in the database.
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.
|
|
Archived message: Updating the link in a Linked Table. (MS Access)
