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
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