Connecting to SQL Server 2005 with Access 2007

B

Brian

I have a database with a front-end in Access 2007 and the back-end in SQL
Server 2005. I use dsn to link the data tables into the Access 2007
front-end and then reference the tables in my forms by using something like:

Dim rst as DAO.recordset
Set rst = currentdb().OpenRecordset("<SQL Statement here>;", dbOpenDynaset,
dbSeeChanges)

Does anyone know if there is a way of programatically (VBA) using the data
tables in SQL without using dsn? Or is what I'm already doing the best way
of handling this?

Thanks
Brian
 

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

Access 2003 and SQL Server 2005 and DAO recordset 1
Connecting to a SQL Server 2005 using VBA and ADO 2
Please help with ADO Code 1
Why my records are read only? 2
moving _be to sql server 2005 8
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
Connection String to SQL Server in VBA 3
Why linked sql database is read only 2

Top