General discussion

Locked

Conversion of Access 97 to 2000

By mcorr ·
I have a fully functioning Access 97 application, but when I try to convert it to Access 2000 I get several errors "There was an error...converting form x." and then "The VB for A project in the database is corrupt." Of course MSDN has nothing about this problem, so has anyone had similar experiences and maybe a solution?

I am using Access 2000 version 9.0.2720 (latest patch I believe) and the existing database was created in Access 97 SR-2b and not encrypted.

This conversation is currently closed to new comments.

15 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Conversion of Access 97 to 2000

by Larry H. In reply to Conversion of Access 97 t ...

I had a similar problem moving an Access 2 database into Access 97. In my case the problem stemmed from changes to VBA between the two versions. One of the variable names in the old version was now a reserved name in Access 97. Another possiblityis that you were using a "legacy" function that has been replaced, and Access 2000 no longer supports it.

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...

I don't know of any unsupported functions in Access 2k like that.

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...

>I had a similar problem moving an Access 2 database into Access 97.
I am going in the other direction, which should work except for the few exceptions mentioned in the help. But the form is a simple splash form with two labels and an image, and it does nothing but close itself. I also get an error on a straightforward entry form.

>Another possiblity is that you were using a "legacy" function that has
>been replaced, and Access 2000 no longer supports it.
Nope, checked the list, andeverything I am using should be supported.

Thanks, Chris

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...
Collapse -

Conversion of Access 97 to 2000

by klennon-WF In reply to Conversion of Access 97 t ...

One thing that I ran into was that Access 2000 is now default with ADO instead of the old DAO - have you verified references? If the references are correct then I would reevaluate the DAO code in your modules and/or form events.

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...

I really don't use all that much of DAO; mostly I used queries to do that sort of thing.

Collapse -

Conversion of Access 97 to 2000

by labinter In reply to Conversion of Access 97 t ...

Yo tengo experiencias similares con la conversion de funciones del SQL como Format (); Right$() y Left$ () en las consultas y adm?s en la conversi?n de gr?ficos. No poseo experiencias como las tuyas, pero si te comento que en muchas ocasiones he tenido que reprogramar las rutinas bajo Access 2000 ya que la b?squeda de soluciones ma llevaba m?s tiempo, y tampoco he encriptado mis programas.
Suerte !!!
Sorry for the spanish language. If you have problems to translate this, tell me.
My name is Ricardo from Argentina
By...

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...

Hablo espanol un poquito, pero su somentos no ayudame. Gracias.

Collapse -

Conversion of Access 97 to 2000

by Joe Giaquinto In reply to Conversion of Access 97 t ...

1. As mentioned before, check the references. For example, Access 97 uses the 8.0 object library while Access 2000 uses 9.0. In the VB editor, check for missing references under Tools/References. You can re-reference the new objects by clicking the checkbox next to the appropriate object.

2. Here's a syntax gotcha...
For Access 97 (DAO 2.5x/3.5x): OpenDatabase
For Access 2000 (DAO 3.6x): DAO.OpenDatabase

3. Try rebuilding the project by exporting your data, forms, modules and then importing them into the new DB.

4. Use late binding (create objects as needed rather than explicitly referring to their object libraries.)

5. Avoid running 97 and 2000 on the same machine.

Collapse -

Conversion of Access 97 to 2000

by mcorr In reply to Conversion of Access 97 t ...

1. Already did that, didn't help.
2. Don't use direct DB access, used queries instead.
3. I tried that, but it gave the same error on the splash screen.
4. I am familar with this concept in other more OO languages, but how does this apply here? Do you create and place the buttons run time? I didn't really use any structures or user-defined objects.
5. Of course, that would be against the Will of Bill.

Back to Web Development Forum
15 total posts (Page 1 of 2)   01 | 02   Next

Software Forums