Table on SQL Server BE needs to be exactly same as table in FE

[SilkCityFlorida]

I have a speed issue. I am relegated to a fairly slow server, and my users
must work over a VPN. I have converted an Access BE to SQL Server, and am
now trying to tune the Access FE for speed.

Several of my forms have numerous dropdowns which are filled from tables on
the server. Every time I open the form or and, I think, go to another
record, each dropdown is completely reloaded.

I have this idea to keep the master dropdown tables on the server because
they are also needed by lookups in numerous stored procedures and views. But
I would like to maintain a set of those tables in the FE and load them at
startup. Then my dropdown rowsources could point to the local tables instead
of the BE tables. But I MUST ensure that both the BE copy of the table and
the FE copy of the table are identicle, including the record IDs
(auto-generated values).

How can I copy a table in its entirety from the BE to the FE, completely
replacing the existing contents of the FE table, and making sure the record
IDs on the FE are identical to the ones on the Be table?

 

[Rick Brandt]

I have a speed issue. I am relegated to a fairly slow server, and my
users must work over a VPN. I have converted an Access BE to SQL
Server, and am now trying to tune the Access FE for speed.

Several of my forms have numerous dropdowns which are filled from
tables on the server. Every time I open the form or and, I think, go
to another record, each dropdown is completely reloaded.

I have this idea to keep the master dropdown tables on the server
because they are also needed by lookups in numerous stored procedures
and views. But I would like to maintain a set of those tables in the
FE and load them at startup. Then my dropdown rowsources could point
to the local tables instead of the BE tables. But I MUST ensure that
both the BE copy of the table and the FE copy of the table are
identicle, including the record IDs (auto-generated values).

How can I copy a table in its entirety from the BE to the FE,
completely replacing the existing contents of the FE table, and
making sure the record IDs on the FE are identical to the ones on the
Be table?

Create identical local table structures and just use Long Integers for the
fields that are auto-generated on the server. Then all you need to do is run a
delete query to clear the local table and then an append query to load it from
the server table,