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

Active Content in this file is blocked issue 1
Name of file opened, being viewed 2
How do I clear a form? 0
Encryptimg dosn't work when connecting to a remote drive 0
Update syntax for a remote table access 1
Acces 2007 performance 1
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0

Top