Converting Access 97 to Access 2000

[polina]

Hi,

I need to convert Access 97 database to Access 2000. I did not go through Convert option, but simply imported all the objects from 97 to new 2000 database.

Once I have done that, I encounter lots problems that I didn't have in Access 97. For instance, some of my INSERT INTO queries run very very slow (even though I recreated all the indexes in my tables).

If anyone has done the conversion and knows about the potential problems with that, please let me know how to go fixing them.

I will appreciate any comments on that issue.

Thanks.

 

[WayneRyan]

polina,

I have converted several A97 databases to A2000.
They generally have a lot of VBA code (with DAO).

I haven't had any problems at all. The conversions
were done by opening A2000, opening an A97 app, then
letting Access do the conversion.

I've heard that A2000 is slower, but I haven't seen
it.

I'd be interested in hearing of any specific problems.

Wayne