Access 97-2000 conversion

[Wiszh]

Hi,

I'm tyring to convert some access 97 databases to access 2000. As you can imagine this is not a simple feat. When simple conversion does not work, I create a new database and import the objects one by one. I often run into problems importing forms and reports any ideas ?

Thanx
Wiszh

 

[thornmastr]

Well, you are doing it wrong and are going to end up with some nasty problems. First of all, before you start to convert, be sure that your A97 database compiles properly. If I remember from A97 you can specify compile all or just the current module. Make sure you get a clean compile across the entire database.

Never forget that A97 defaults to the DAO library and A2K defaults to the ADO library. Use A2K to do your conversion, then go into your converted database and check the DAO reference. Get into the VB Editor>tools>references, and then add a reference to the DAO library. Compile your
New database and you are converted.

Be aware that if you leave the reference to the ADO library you will have to specify each object that shares a common name. For example, the A97 statement

Dim rs as recordset
You will need to specify
Dim rs as DAO.recordset.

I simplified the issue and just removed the reference to ADO.

It really should not be an overly complex process unless you have some very esoteric code.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[cheerio]

If you have an ambiguous keyword such as recordset where it might be ADO.recordset or DAO.recordset then the ambiguity is resolved by working down the libraries from the top as shown in Tools, References.

Therefore you do not actually have to untick the ADO library. What you need to do is promote the DAO library above ADO so that it is considered first. This becomes important if you wish to be able to use ADO code later in your converted project.

Ken

 

[Wiszh]

Firstly thaks, but
belive it or not I have tried and used the aforementioned suggestions. They have help for some items but not for others.

I just found something that seems to help:
open the guilty form or report in design view in access 97, make some silly modification,
save,
then import

This time it works! go figure!!

Wiszh

 

[aqm]

WOULD YOU PLEASE HELP ME ON SECURITY IN MS ACCESS? I TRIED ALL I CAN ON THE ACCESS SECURITY BUT IS TOTALLY UNSAFE. CAN YOU HELP HOW PROGRAMMABLY