1. Home
  2. Computing & Technology
  3. Databases
photo of Mike Chapple
Mike's Databases Blog

By Mike Chapple, About.com Guide to Databases since 2000

Transferring an Access 2007 Database

Sunday November 16, 2008
In a recent forum message, Vikram wrote:

"I have set up a database using Access 2007. Data is being entered but a modification was requested to make data entry easier. I would like to work on the modification at home but am unable to figure out how to transfer the data already entered into the modified database. I do not want them to stop entering data as the modification may take some time."

Do you have any advice for Vikram? Interested in solutions to the same problem? Visit our forum and join the discussion.
Comments
November 18, 2008 at 12:23 pm
(1) Steve says:

I have faced the same for my website.. http://www.deathrecordsobituarysearch.com

November 26, 2008 at 4:35 am
(2) Alec Wood says:

If it’s Access then just copy the mdb file(s). If it’s split front-end and back end then at home you’ll need to update the linked tables location.

If the back end is SQL then it’s a bit more work, you’ll need to download a copy of SQL express edition for home and make the appropriate connections

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases

©2009 About.com, a part of The New York Times Company.

All rights reserved.