Break the linked tables

I have two Access programs, one was created in version 2003 or before and the
anther one is in 2007. The newer one is the updated version from the old one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but the
message box shows that the name of the table is missing and stop the re-link
process. Actually the table which showed missing is inside of the database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

AJ

Delete all the linked tables and then import them from the backend they were
linked to. That way you have one db again.

Ofcourse before doing such a thing as deleting you have to make a copy of
the db just in case..
--
Maurice Ausum


"A. J." wrote:

I have two Access programs, one was created in version 2003 or before and the
anther one is in 2007. The newer one is the updated version from the old one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but the
message box shows that the name of the table is missing and stop the re-link
process. Actually the table which showed missing is inside of the database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

I'm not sure I have a complete picture of your situation yet...

First, are you saying that there is an automatic routine that "refreshes"
the links when you start up the program?

If you have any linked tables in any version, you probably have a "split"
design: the front-end (generally) holds forms and queries and ..., while
the back-end holds (only) the tables. It's the front-end that has the links
and that folks use.

Does this match your situation?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"A. J." wrote in message
...
I have two Access programs, one was created in version 2003 or before and
the
anther one is in 2007. The newer one is the updated version from the old
one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but
the
message box shows that the name of the table is missing and stop the
re-link
process. Actually the table which showed missing is inside of the
database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

On Mon, 15 Mar 2010 14:36:05 -0700, A. J.
wrote:

I have two Access programs, one was created in version 2003 or before and the
anther one is in 2007. The newer one is the updated version from the old one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but the
message box shows that the name of the table is missing and stop the re-link
process. Actually the table which showed missing is inside of the database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

You can't "link a database to itself". Your database does not contain any
data, nor any tables! All of the "tables" that you see are just links,
pointers to the backend. Linking to it will therefore find... nothing.

The backend *contains the actual tables*. Upgrading the frontend from 2003 to
2007 leaves all your data as it was, still stored in the 2003-level backend
database; you would need to separately open the backend database, and upgrade
IT. You would then need to relink the 2007 frontend to the (newly created)
2007 backend.

On the other hand, 2007 uses Access 2003 format .mdb files by default; if
you're linking to a .mdb (as opposed to an .accdb) I see no reason to make any
change at all.
--

John W. Vinson [MVP]

John;

where do you get off spreading lies like this:

2007 uses Access 2003 format .mdb files by default;

What you meant to say is
2007 uses Access 2007 format .accdb files by default;

RIGHT?

RIGHT?






On Mar 15, 4:01*pm, John W. Vinson
wrote:
On Mon, 15 Mar 2010 14:36:05 -0700, A. J.
wrote:

I have two Access programs, one was created in version 2003 or before and the
anther one is in 2007. The newer one is the updated version from the old one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but the
message box shows that the name of the table is missing and stop the re-link
process. Actually the table which showed missing is inside of the database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

You can't "link a database to itself". Your database does not contain any
data, nor any tables! All of the "tables" that you see are just links,
pointers to the backend. Linking to it will therefore find... nothing.

The backend *contains the actual tables*. Upgrading the frontend from 2003 to
2007 leaves all your data as it was, still stored in the 2003-level backend
database; you would need to separately open the backend database, and upgrade
IT. You would then need to relink the 2007 frontend to the (newly created)
2007 backend.

On the other hand, 2007 uses Access 2003 format .mdb files by default; if
you're linking to a .mdb (as opposed to an .accdb) I see no reason to make any
change at all.
--

* * * * * * *John W. Vinson [MVP]

Hi All,

Thanks for all your advices. The old version program is the original
program; it has been updated to the 2007 version. It looks like the same as
the old program (Same forms, reports, queries, tables, macros and modules),
but linked to the old one.

I guess the 2007 version of the program as a frontend and use the old the
version as a backend. Now the new version has the problem to open and the old
version asks for the administrator permission if I click on it. I have
checked on the old Access program properties and added myself in for full
control to the program and our Administrator has given me the permission to
open this program on their system side, but when I clicked to open the old
one, the message box still shows the administrator permission is required. I
cannot either open the old program or relink to the old program from the new
one. Where is the other possible place to set up the administrator's
permission other than the two places as I mentioned above? Thanks.

"A. J." wrote:

I have two Access programs, one was created in version 2003 or before and the
anther one is in 2007. The newer one is the updated version from the old one.

In some reason, the newer one is linked with the old one (I found from the
Linked Table Manager). I try to re-link the newer one back to itself, but the
message box shows that the name of the table is missing and stop the re-link
process. Actually the table which showed missing is inside of the database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

Were you trying to be rude? If so, why?

I believe Access 2007, by default, out of the box, uses Access 2003 (mdb)
format. It is possible to set an option that will have it use Access 2007
(accdb) format by default.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message
...
John;

where do you get off spreading lies like this:

2007 uses Access 2003 format .mdb files by default;

What you meant to say is
2007 uses Access 2007 format .accdb files by default;

RIGHT?

RIGHT?






On Mar 15, 4:01 pm, John W. Vinson
wrote:
On Mon, 15 Mar 2010 14:36:05 -0700, A. J.
wrote:

I have two Access programs, one was created in version 2003 or before and
the
anther one is in 2007. The newer one is the updated version from the old
one.

In some reason, the newer one is linked with the old one (I found from
the
Linked Table Manager). I try to re-link the newer one back to itself, but
the
message box shows that the name of the table is missing and stop the
re-link
process. Actually the table which showed missing is inside of the
database. I
cannot re-link the table.

I would like to break the link between those two databases, could someone
show me how? Thanks.

You can't "link a database to itself". Your database does not contain any
data, nor any tables! All of the "tables" that you see are just links,
pointers to the backend. Linking to it will therefore find... nothing.

The backend *contains the actual tables*. Upgrading the frontend from 2003
to
2007 leaves all your data as it was, still stored in the 2003-level
backend
database; you would need to separately open the backend database, and
upgrade
IT. You would then need to relink the 2007 frontend to the (newly created)
2007 backend.

On the other hand, 2007 uses Access 2003 format .mdb files by default; if
you're linking to a .mdb (as opposed to an .accdb) I see no reason to make
any
change at all.
--

John W. Vinson [MVP]