Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lin100
Yak Posting Veteran
70 Posts |
 Posted - 2009-02-18 : 00:26:31
|
| Can Access VBA DAO code work in SQL Server 2008?If I have Access VBA code written in DAO thencan this same code works directly on SQL 2008 Server without modification ?Can Access query works on SQL 2008 Server without modification ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-18 : 05:22:34
|
| Do you mean from access or within SQl Server itself?!?If you mean from Access, then it would depend on the query.. |
 |
|
|
Lin100
Yak Posting Veteran
70 Posts |
Posted - 2009-02-24 : 23:16:34
|
| I heard somebody said that DAO VBA code written for MS Access table (ex: recordset, table, table def, query def, etc...) will work on SQL 2008 table without any modification. |
|
|
|
Lin100
Yak Posting Veteran
70 Posts |
Posted - 2009-02-24 : 23:17:06
|
| I heard somebody said that DAO VBA code written for MS Access table (ex: recordset, table, table def, query def, etc...) will work on SQL 2008 table without any modification. Is this true? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-02-25 : 06:39:59
|
| If you mean that DAO can be used on a SQL Server linked table in Access, then that's probably true. But the code will not work in a SQL Server stored procedure, and certainly not without modification. |
|
|
|
|
|
|
Can Access VBA work in SQL Server 2008?