Linked Databases/ Tables

[jwells07]

I've been using Access with a remote SQL Server for quite a while and sometimes the client loses internet connection which is an issue. I've been trying to understand linked tables and have linked some local tables to the SQL Server and it seems to work fine as long as I have an internet connection which doesn't make it very useful for me. I would like to be able to continue working on a record even after the internet connection is lost using the local table and then refresh the remote table when eventually the internet connection is remade. Is there a way to configure this? If not, is there another method?

[Welshgasman]

Crossposted https://www.utteraccess.com/topics/2063882?post=unread

[ranman256]

you would need code to relink to the local db, enter your data, then when you are reconnected to the server, run update/append queries to update the server from your local tbls.

My db had 3 tables for each tbl:
tCustomers (the table in use)
tCustomers-Sql
tCustomers-Lcl

user would open a form and select LOCAL or SQL then THAT table would replace the working name. (the one without the dash)
for LOCAL selection it would run thru the list and :
copy tCustomers-Lcl to tCustomers

for every table. Then all entries are now entered local tables only.

When back connected, running the SQL option would
FIRST ask user to run updates,
run the updates,
then copy Sql tbls to main name.

[jwells07]

Thanks for the reply. Before I started trying to write a lot of code and trying to make it transparent for my employees I was hoping there was something a little more built in that you could just specify to write to the local table and then a remote connection would trigger updates to the changed the remote records. Wishful thinking.