Access 2000 Conversion to Access 2010

Question

I have an Access 2000 database (with four linked tables) that I now need to convert to Access 2010. I understand that I can either open the database, then save it as an .accdb, or I can create a new database in Access 2010, using the same field names from the 2000 database, then import the old into the new (which outwardly seems to be a pain in the butt, but I've read where several folks have chosen this option over just saving as an .accdb). I'm not sure which to do, and I am really wary--will I lose all of my queries, forms, reports, and macros originally created with Access 2000 doing either of these conversions???? I'm retirning at the end of Feb, and I am the sole person chosen to update the database, so I need an answer ASAP,  Thanks.

Answer 1

A2007 and A2010 are much starchier about security than previous versions. Anything with VBA code (including some functions called from queries) will be flagged as "UNSAFE" (and will not run) unless the database is "signed" by a trusted publisher, or unless you use the Trust Center to mark the folder containing the database as a trusted location.

To do so, click the Office medallion in the upper left of the screen; select the "Access Options" button; choose the Trust Center from the menu; select "Trust Center Settings" and then "Trusted Locations". Add the path to your database to the trusted list and check the "Allow Trusted Locations on my network" (even though it says "not recommended").

Answer 2

Which maths functions do you have in the queries?

Answer 3

OK, I understand that I don't have not convert. However, I have quite a few documents that merge with my database (and some even merge with excel, access, and word). I've merging a doc that uses a query containing math functions. The system said it couldn't find the source. When I attempted to re-path to my database, the selection of queries did not include queries that I have math function in (when I go into the database and look at the queries, they are still on the list and I can open them from that point). How would I go about fixing the queries so that the docs can be pathed to them?

Answer 4

I've converted several DBs to 2010 without major problem. In some cases where were some minor code issues, but the forms and reports worked fine.

When you convert, you don't lose your old file but create a new, accdb, file. So you still have the old MDB file to go back to.

Answer 5

You can use an Access 2000 format database (.mdb) in Access 2010 without needing to convert it to the new format (.accdb). You will be able to enter and edit data, and also to modify the design of the database.

You only need to convert to the new database format if you want to use some of the new features of Access 2007/2010.

If you do convert, all tables, queries, forms, reports, macros and modules will be transferred, and most things should still work. It's best to test extensively to find out what, if anything, breaks.