Editing data in SQL Server

[dcmageddon]

HI all,

I am trying to connect to a SQL Server database from Access. I am new to VBA and don't have a clue how to connect to the db or edit the data using VBA.
Any help would be appreciated.
Thanks,
DC

 

[Bodisathva]

couple of different choices, the easiest being link the tables through Access and you would reference them just as you would a local table. The second choice would be using pass through queries to allow the server to do the heavy lifting.

search the forum for linked tables or pass through queries and you should find more than enough information to get you started.

 

[dcmageddon]

Thanks for that Bo.