Upsizing & Local Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trauton - 24 Sep 2005 06:05 GMT

Hi,

I have an Access application which was split as FE and BE (BE with only
tables). I recently upsized to a SQL server and all FE is working with the
SQL tables.

Is there any reason not to delete the Local tables that the Upsizing Wizard
created? They seem to be just taking up space... and what about the previous
Access BE? The FE is still linked to it since I can see the Local tables,
but I don't think I need it since I will only be distributing the FE.

Thanks!!

Trauton

Reply to this Message

Jeff Boyce - 25 Sep 2005 18:41 GMT

If you have an Access BE, a SQL-Server BE, and are not keeping the Access BE
synchronized, using it would give you out-of-date info.

A "local" table, in Access parlance, lives in the .mdb file you are in --
and I'm assuming you are working from an Access FE file.

Rather than delete the Access BE tables, you could open the FE and delete
the links to the Access BE tables. This won't affect the Access BE, but
will remove the links from the FE, leaving you with, I assume, only the
links to the SQL-Server tables.

Signature

Regards

Jeff Boyce
<MS Office/Access MVP>

> Hi,
>
[quoted text clipped - 10 lines]
>
> Trauton

Reply to this Message

Trauton - 26 Sep 2005 01:15 GMT

Jeff,

Thanks, your assumptions were correct. I am using an Access FE. Since I
have no need to connect to the local tables, I have deleted the links as you
suggested.

I appreciate your time,

Trauton

> If you have an Access BE, a SQL-Server BE, and are not keeping the Access BE
> synchronized, using it would give you out-of-date info.
[quoted text clipped - 24 lines]
> >
> > Trauton

Reply to this Message