Acc2003 converts linked tables to local tables (2k -> 97)

G

Guest

When converting a front-end from 2000/2003 format to 97 format, Access 2003
converts the linked tables to local tables (the back-end is in 97 format).
This makes it impossible to convert a 2000/2003 front end for use with
Access 97 without using Access 2000 or 97 on another workstation to delete
and re-link the tables in the converted front-end.
This type of conversion worked perfectly with Access 2000, so it looks like
this has been changed intentionally.
Is there a workaround anyway?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-a419-14e0b41c0d15&dg=microsoft.public.access
 
A

Arvin Meyer [MVP]

It hasn't worked that way for me. All linked tables work just fine. I
suggest that you simply open the database front-end, delete all the links,
convert the fornt-end, then add the links back. That way you will not need
to use another version.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

JRS said:
When converting a front-end from 2000/2003 format to 97 format, Access 2003
converts the linked tables to local tables (the back-end is in 97 format).
This makes it impossible to convert a 2000/2003 front end for use with
Access 97 without using Access 2000 or 97 on another workstation to delete
and re-link the tables in the converted front-end.
This type of conversion worked perfectly with Access 2000, so it looks like
this has been changed intentionally.
Is there a workaround anyway?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=35ec250a-3e
c8-4041-a419-14e0b41c0d15&dg=microsoft.public.access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top