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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

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

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Read the latest Blogs

Forums

How to update table partwithcompany column name company id by companyid for max

By ahmed_elbarbary.2010

How to update table partwithcompany column name company id by companyid for max partid...

Appttime add with duration how to get endtime please

By DBA.k

  Hoe to get appt_time+duration = end_time can you please help on this

SQL Sever becoming Non Responsive

By IT researcher

SQL  server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers