Upgrade Access 97 to Access 2010

[mercury]

Hi All,

I have a client requirement to upgrade our existing application which is running with Access 97 Win Xp to Access 2010 Win 7.

The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010.

• This application involves more than 20 forms and sub-forms with VBA
• Reports generation

Can someone, please suggest a way to upgrade form Access 97 to Access 2010.


Quick Questions:

• What are the thing to be in handy before migration?
• Is there anything to be re-create?
• Performance issues?
• Any expected issues after post migration?
• Access 2010 is compatible with Win XP and Win 7

Thanks in advance.

[AlexHedley]

You could create a blank/new .accdb then import all your objects (Tables, Forms etc) from the old one to the new one.

Or you could open the .mdb in the new Access and Save Database As and change the version.

Are you using the Calendar Control or any ActiveX Controls. There might be some compatibility issues here.
In the VBA Window (Alt+F11) go to Tools | References and check the Libraries.

[SteveH2508]

If you have an MDW file that suggests that you have security enabled on your database. This is no longer supported in A2010 I believe. I have never used security on an Access db so I cannot help further - hopefully someone else can pitch in on this one.

[mercury]

Hi Alex,

Thanks for the quick reply. just to update you, this application is already developed and i just have to upgrade this from access 97 Win XP to Access 2010 with Win7. Also, this application .MDB is having an .MDE file where all the code exist.

Could you please let me know, how can i proceed further here and also if any of forms has interlinking between them then, how can i import this?

[mercury]

Hi Steave,

Thanks for your quick reply, Actually i was looking for the blogs which say about .mdw file is not supported with access 2010. Do you find such blogs? if yes, could you please share.

Also is there a way to have security enabled with Access 2010? please let me know.

[AlexHedley]

If it's a split fe/be when you import them into a new databases you could use the Linked Table Manger to re-establish the links or change them to the new .accdb

I'd not spotted the security file, this will be some extra work.
Access got rid of it cos it wasn't that secure.
You could build your own User Level Security.

I'll see if I can find some blog posts that can help you.

Check out these outlines, they might be of some help too
http://www.599cd.com/site/courselist...ey=AlexForumAF

http://www.599cd.com/site/courselist...ey=AlexForumAF

[mercury]

Alex,

i have a little knowledge on MS-Access.
Could you please drive me the steps for importing FE and BE to a new database and how to use this linked table manager to reestablish the links or change them to new .accdb.

[AlexHedley]

Hi @mercury

There are few steps you will have to take.

Create a blank/new database then in the Ribbon click on External Data then Access.


Now choose your file you wish to Import the objects from.

There are two options here, Import and Link.
Select Import to actually copy over the Tables/Queries. (Back End)
We will choose Link next time. (for the Front End)

There will then be a window with all the Objects to select from.

There is a tab for each Object Type, highlight the Tables that you want and then press OK.
This will Import them into the new database.

Now create a second blank database, do the same for the Queries/Forms etc.

Now repeat the process but this time click LINK and choose the Tables from your new Back End.
Select the ones you need.
They will appear in the Navigation Window with an arrow beside them to denote they are linked. (>)

To check the Links go to External Data and this time click Linked Table Manager


You can then see all the Tables that are Linked.


You can select any Tables and change them if necessary.

--
Alex Hedley
TechHelp Team Leader
599CD.com

[mercury]

Alex,

Thanks for above brief steps, i have not yet started working on this but i will update you when i will start working. I have a concern that, if we upgrade from Acc97 to Acc2010 the file extension gets changes from .mdb to .accdb correct? if yes, then is there a way to keep the extension .mdb instead of .accdb? because .mdw security is only supportive to .mdb file but not .accdb file.

Is Access2010 is compatible with Win 7 and Win XP?

[AlexHedley]

What is the reason you need to upgrade the db?
You can still open mdbs in Access 2010/2013.

You might find this article useful.
http://office.microsoft.com/en-us/ac...010341994.aspx

[mercury]

Alex,

my client is looking for the user level permissions, which are only supportive with .mdbs only. So, I wanted to suggest to my client. please see below
1. Open Access 97 .mdb file under Access 2010
2. Work on issues after opening into Access 2010
3. check the tables and reports connections
4. Then, from File --> Save & Publish --> Access 2002-2003 database (*.mdb)

Question:
1. If i save the file to "Access 2002-2003 database (*.mdb)", will they open into Access 2010 with user level security? if not, could you please suggest/guide me that, how can i move forward from here?