Upgrade MS-Access to SQL-Server

Home :: SQL Server :: MS Access to SQL-Server

You need a good reason to upgrade from an Access database to SQL server. You know it’s going to hurt. However, if you’re thinking about it you’re probably only ever going to postpone the inevitable!

In my case, I was using MS Access to run a busy website (that was getting busier all the time). In fact, I had multiple URL's on the same domain sharing the same Access db and I was worried about the load.

Trouble is there’s not much on the web to help you, even on the Microsoft site! I went through it the hard way and hopefully can save you some grief.

Why upgrade to SQL Server?

My Access database worked fine but every now and then I would get an error on the connection object. Then it became every week, then every 3 days... It crashed the site. The only way to get your site back up is to stop/start IIS (that fixes a multitude of other sins too) but is only possible locally. I had to rely on my ISP doing it (they are good like that) but the sites could be down for an hour or two even so.

I looked for a workaround. No, you can’t open the connection on Session start – you must do it on each page!

The rest of this page is hidden, you must be a member to view it

To become a member and get immediate access to the course please join here Free!

Already Enrolled? please click here to Login