Help! Mental Block!

G

Greg Franke

I am having complete mental block on this.

Using Access VBA I want to establish a connection to a remote SQL server
database and a Local Access table. What ADO connect strings should I use for
each? I am trying to write a program that will do the following....

if connection to remote db valid (or open) then
if (STORED_DATA) in local table then
read (STORED_DATA) from local table
upload (STORED_DATA) to remote SQL DB
upload (CURRENT_DATA) to remote DB
delete (STORED_DATA) from Local Table
else
Upload (CURRENT_DATA) to remote SQL DB
endif
else
Save (CURRENT_DATA) in Local DB table.
endif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zero Upload Speed 6
Need help with RecordSource and subform 3
Record insert/delete anomaly 0
Update syntax for a remote table access 1
Query using VBA with local and remote tables 2
Acces 2007 performance 1
Front End being locked 7
MS Access - Form - Upload document to Sharepoint Server (whoes folder is mapped to my PC) from Acce 0

Top