It was a year ago that I first attempted to migrate to SQL server, so I can't remember the details of all the headaches I had, but I remember a lot of headaches. Forms linked directly to server tables lagged withe every click, SQL needed translated to T-SQL, queries couldn't be edited directly so I had to make edit functions. But then, also, I started learning about things SQL server could do that Access could not, like more advanced table triggers. I made a pass-through query function to simplify updating vba modules to work with the server. So, things I'd like (or would have liked at the time) would be a) understanding what's different - appreciating the differences between Access and SQL server, understanding what features will no longer work or will not work the same; b) understanding migration - best practices for linking forms; how to use views, temp tables, or cache data; translating SQL to T-SQL; and c) a tour of the fancy new bag of tricks available, like table triggers, server-side functions, or more advanced sql not available in access.
Sam Domino
@Reply 7 months ago
Lisa Love it!!! Several years ago, I built an Access db to track action items (owner, due date, current status, etc.) for a military organization. On the login screen I would show random pictures of military "stuff" like ships, tanks, planes, missiles, etc. Your picture brought back a lot of good memories! Thank You!!!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Beginner Level 1.