Refresh data in Access

[wtgamer2003]

Hello Everyone,

Id like to know if anyone could let me know if it is possilble to automate Access to retrieve refreshed data from an SQL database.

I have an Access database with the folowing fields (SQL database has the same data):

Account UserDetail Notes
12345 Company1 No Pay
23456 Company2 Paid

I was interested in pulling the UserDetail (Based on button press on my from) for only those members with an account number in my access database - while not updating the Notes field. Do you have any ideas?

By the way, I have the code to pull from the SQL database; however, I am unsure of how to cycle through the data and pull only data elements which match on account.

 

[Thomko]

Link the SQL table via an ODBC link. Then you can construct an UPDATE query by joining the local and the remote table on the Account. Let Access do the work your you.

Thomas