views:

115

answers:

3

So I have been working with multiple different MS Access apps at work (about 8) for different departments. And it looks as though there are going to stand up a SQL Server at work, which makes sense from a capacity/integrations standpoint.

Soooo......I have experience with Access, SQL and VBA, but having never used any of it in a SQL Server capacity, are there any resources for learning, books, websites, etc where I can start? Can you "face plate" (yeah sorry that is my term I suppose, and may sound ridiculous) access applications on the SQL Server app so that I can continue to develop, utilize and have end users utilize SQL Server through these access applications?

Thanks

+5  A: 

Lots of foilks have successfuly upsized their Access apps to SQL Server with a minimm of trouble. There will be some tweaking required and some areas which were slow in Access that you can speed up. Do ensure the users do lots of testing of course. For now avoid merge replication on SQL Server as that and Access seems to have some troubles.

See my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page

There is a tool from the SQL Server group which is better than the Upsizing Wizard that comes with Access SQL Server Migration Assistant for Access (SSMA Access)

Tony Toews
Tony is right -- it's generally pretty painless, unless your Access app does lots of bad things. The key point is that your app should be retrieving the minimum number of records necessary for the user to do her work.
David-W-Fenton
Thanks guys! That puts my mind at ease a bit!
Justin
+1  A: 

W3schools.com has good tutorials and quizzes in many fields including SQL and ASP.NET.

You can find articles about using SQL server on SQLserverCentral.com.

Irina C
Thanks very much! This will certainly help get me started!
Justin
Hmm, the SQL Server Central site "Free registration required...To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters." That site won't be on my recommended reading list.
Tony Toews
+1  A: 

As for SQL Server sites, I'm favoring Simple Talk these days. I think it has something for everybody, newbies and seasoned professionals.

I like their "cribsheets", with the facts on most SQL Server resources (Reporting Services, Security, OLAP, pivot, regex,...).

ezingano
hey thanks. i will check it out!
Justin