Unlinking Tables

[DS]

How do you unlink tables in a split database. Or change the link?
Thanks
DS

[fredg]

On Mon, 21 Feb 2005 19:57:02 -0500, DS wrote:

How do you unlink tables in a split database. Or change the link?
Thanks
DS

Open the database (Front end).
Show all the tables.
Click on the table you wish to un-link.
Delete it (you're deleting the link not the table).

Or if you just want to relink, click on
Tools + DataBase Utilities + Link Manager.

Select the tables wanted.
Click on the "Always prompt for new location" check box at the lower
left corner of the dialog.
Click OK.
Navigate to the database that has the new back end tables.
Click OK.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[DS]

fredg wrote:

On Mon, 21 Feb 2005 19:57:02 -0500, DS wrote:

How do you unlink tables in a split database. Or change the link?
Thanks
DS

Open the database (Front end).
Show all the tables.
Click on the table you wish to un-link.
Delete it (you're deleting the link not the table).

Or if you just want to relink, click on
Tools + DataBase Utilities + Link Manager.

Select the tables wanted.
Click on the "Always prompt for new location" check box at the lower
left corner of the dialog.
Click OK.
Navigate to the database that has the new back end tables.
Click OK.

Great, Thank you! This whole thing sounds scarey but I heard its the
right thing to do when your going to be in a multi-user enviroment.
Also whenever you add a new field to a table, do you add it to the
tables database or the other one with the forms, querys, etc? Thank you.
DS

[fredg]

On Tue, 22 Feb 2005 08:36:36 -0500, DS wrote:

fredg wrote:

On Mon, 21 Feb 2005 19:57:02 -0500, DS wrote:

How do you unlink tables in a split database. Or change the link?
Thanks
DS

Open the database (Front end).
Show all the tables.
Click on the table you wish to un-link.
Delete it (you're deleting the link not the table).

Or if you just want to relink, click on
Tools + DataBase Utilities + Link Manager.

Select the tables wanted.
Click on the "Always prompt for new location" check box at the lower
left corner of the dialog.
Click OK.
Navigate to the database that has the new back end tables.
Click OK.

Great, Thank you! This whole thing sounds scarey but I heard its the
right thing to do when your going to be in a multi-user enviroment.
Also whenever you add a new field to a table, do you add it to the
tables database or the other one with the forms, querys, etc? Thank you.
DS

Since the tables are in the back end, you must add the new field to
the Back end. As a matter of fact, if you try to open the Front end
table in design view, you'll get a message that you cannot modify the
table design.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.