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

Daily Coping 4 Jun 2020

By

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

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

Database Extended Properties

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Extended Properties

Date Join Issue

By nymets86

I joined two tables together trying to get a field out of one and...

estimated execution plan

By sizal0234

  I have an SP which is truncating a table and then insert into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers