I am using Access to analyze data in a remote SQL server. I cannot
"link" these tables, because Access doesn't like the SQL's replication
ID, so I need to import these table each time I run a report to ensure
I get the latest data, therefore:
I would like to run the following procedure, and assign it to a button
on a form:
1) Delete the following tables:
- dbo_ActivityPurposeTypes
- dbo_AnalysisChecklistItems
- dbo_AreaTypes
- dbo_Bays
- dbo_Companies
- dbo_LeaseBaseRents
- dbo_Leases
- dbo_Users
2) Run an import, which connects to an ODBC DSN on my PC called
JOKE.DSN, and import the above same tables
Can anyone walk me through this ? I'm relatively new to code, but I
know my way around Access pretty well.
Any help would be ever so greatly appreciated, and please email me as
well as post, since I don't get to log on here as often as I'd like.
Thanks
Shai
ny****@yahoo.com