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 |
|
jleiker
Starting Member
13 Posts |
 Posted - 2005-08-17 : 11:15:46
|
| Is there an easy fast way to do this:We are having problems upgrading to SQL server for only our backend tables. The problem is we have SQL reserved words that can only be used by SQL Server. There is a huge list I was given. I assume this applies to all objects, in our ms access database. Any suggestions on how to at least 'find' all of these at once? Or fix this easily? I know which tables would not upload ...but in looking through them I don't even see which reserved word is causing the issue???Also..our front end application with stay Ms access 2003. Do I still need to update any reserved words in that or just the tables? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-08-22 : 10:18:16
|
| Often it is not worth the effort to split back end from front end. Some of the objectives of doing so, such as better performance, better scalability, and accomadating more concurrent connection will be better served in the long run by re-writing the app.Having said that, there is product called Access Find and Replace, that will find the words for you.Also, you don't have to update the reserved words on the front end, unless they are in the querries that are going to be processed in the back end server. |
 |
|
|
|
|
|
ms access 2003 upgrade to sql server backend