Upsizing & Local Tables

[Trauton]

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

 

[Jeff Boyce]

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.

 

[Trauton]

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