coverting to access 2000 (off97 – acc 2000)

Topic

New Reply

I created an acc97 DB for a network here at work. however some of the network users have acc2000 installed and not 97. thus we have a problem since the two arent compatible, or so i’ve heard. since we are all sharing the same DB i was thinking i could convert the current access DB to Acc2000 by following these instructions i got from MSFT

Make a backup copy of the Access database you’re going to convert, to keep until you’re comfortable working with the Microsoft Access 2000 database.

Close the Microsoft Access database you’re going to convert.
If the Access database is a multiuser database located on a server or in a shared folder, make sure that no one else has it open.

In Microsoft Access 2000, point to Database Utilities on the Tools menu; point to Convert Database and then click To Current Access Database Version.

In the Database To Convert From dialog box, select the database you want to convert and then click Convert.

In the Convert Database Into dialog box, do one of the following:
Type a new name (without the .mdb extension) for the Microsoft Access 2000 database file.

Select a different location for the Microsoft Access 97 database file. (You can keep the same name, or change it.)
You cannot convert an Access database into a file with the same name and location as the original database.

Click Save.
Microsoft Access converts the database to Access 2000 format.

OK it seems fine but if i do this will the different users who make changes to one version be bale to make those changes int he other. so if i edit the 2000 version and remove a client from the DB, will that client also be removed from the 97 version. what i am asking is will the updated DB be linked to the old one or am i simply creating 2 instances of a dupliacte DB. thanks a lot. any solutions?

Reply | Quote

Replies

Depends on how your db is setup. Are the tables in the same file as the forms and reports? If so then changes made to one will not be reflected in the other db. If this is the case I would recommend splitting the 97 version into a front end and a back end where only the tables are in the back end and all other objects are in the front end. Then convert the front end to access 2k and link to the access97 back end. Microsoft doesn’t recommend this (probably because they want you to upgrade everyone to A2k) but I’ve done this with AccessXP without any problem. Ideally, the best solution would be to upsize the back end to SQL server but that is not something taken lightly.

Reply | Quote

This appears to be the same issue you posted on here. I’m going to post a link to the current post in the other thread and lock it, since there’s no point at all in having two threads dealing with the same issue.

If you need to use an Access 97 backend with an Access 2000 front end, that is perfectly possible. You just convert the front end and not the backend. You should be aware, however, that the performance will suffer in the Access 2000 front end. I haven’t tried this with Access 2002, but I have with A2k and the performance against a 97 backend is poor.

If the “changes” you mention are to the data in the backend, then both front end versions will see the same data. If you’re talking about permissions, are those front or backend permissions/users you would be removing? Design changes would have to be made to each separate front end version since you now have two independent front ends. Since permissions live in the database, you would have to make changes to each of them for that as well. That has always been true in every version of Access.

Reply | Quote

thanks for the reply,

We have decided to upgrade everyone here to Access2000. my question now is how to convert my acc97 DB so that i wont lose it in the upgrade. should i install both on my comp at first? or cani just install the upgrade and then “convert the acc97 db to acc2000 by specifying a new name” by going to ‘database utilities’ , convert database’ and then ‘to current database version’. if i do it this way do i need both versions on my computer.

FYI – the DB file is just one file created in 97 that exists on a network accessible to multiple users. some of us currently have 97 while others have 2000. i will be converting to 2000 soon and we dont really care aboutt he 97 users regarding this db anymore. only 1 or 2 people need access to the db, so as long as 2 people can work it it is fine. however it needs to be 2000 not 97 for the few users of the DB. i dont want to make a front/back end files. i just want one 2000 DB that the needed users can access. will the simple covert option work fine. there are no modules or reports in this DB. only tables, forms, queries and macros.

NOTE – one of the macros imports an xls97 file. will i have to edit anything there or will it still recognize the file even though it will be upgraded? thank a lot. if you need more detaisl please let me know.

Reply | Quote

You can convert and Access 97 database to 2000 by opening it in 2000 and telling it to convert when you see the dialog. Or you can use the Database Utilities menu to convert to current version.

Before you do either, though, decompile and then compile your A97 code in Access 97 and do a compact and repair. You may still need 97 for a while because not all conversions go smoothly, although I’ve never had one that failed entirely.

Reply | Quote

Charlotte – You recommend “decompile and then compile your A97 code in Access 97”.

The compile is accessed off the Debug menu in 97 …. but HOW do you decompile???

Thanks, Gwenda

Reply | Quote

It’s a command line option /decompile, so at the command prompt
msaccess.exe /decompile yourdatabase.mdb

Reply | Quote

You can find a detailed explanation here.

Reply | Quote