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 |
|
hollymatrix
Starting Member
3 Posts |
 Posted - 2008-03-21 : 16:36:43
|
| Hi there i have an application that uses a MS Access database and i want to port it to SQL Server Database. but i dont have the source code. so i need to know if there is an application that can monitor the activity(Select, insert, update, ...) in a MS Acess database. any help is appreciated. Thanks |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-03-21 : 17:57:03
|
| so after transfering to SQL Server, how is application going to access the sql server. I am asking how are u going to change the connection string.There are several change you may have to do to your application.in access, DELETE * FROM TABLENAME and in SQL Server, DELETE FROM TABLENAMEwhen quering dates, in Access it is, SELECT * FROM TABLENAME WHERE Date = #12/12/2008# and in sql server it is SELECT * FROM TABLENAME WHERE Date ='12/12/2008'So, if you don't have the source code how are u going to do those changes---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
|
|
|
about MS Access