Access

Migrating Microsoft Access Databases to SQL Server 2008

  • Article

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.

2011-07-26

3,430 reads

Modifying Microsoft Access Linked Tables from SQL Server

  • Article

In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.

2008-05-14

3,960 reads

Blogs

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

Daily Coping 3 Jul 2020

By Steve Jones - SSC Editor

Today’s tip is to thank a friend for the joy they bring into your...

Connecting To Quickbooks via SSIS

By stricknyn

Hello everyone, Been doing some googling trying to find some info on connecting to...

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers