Converting Access 97 Database to Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BobT - 28 Sep 2007 21:19 GMT

I have an Access Database which I designed about 8 years ago with Access 97.
I now have the task of converting it over to Access 2003. In compiling the
code I am getting errors with this statement

Dim TORG12A As Database, ssMaxONE As Snapshot

DAO reference is enabled..........

Any help is appreciated.

Signature

Reply to this Message

Alex Dybenko - 29 Sep 2007 07:30 GMT

Hi,
Looks like in Access 97 you have used DAO 2.5/3 compatibility layer. now
you need to replace Snapshot with recordset

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I have an Access Database which I designed about 8 years ago with Access
>97.
[quoted text clipped - 7 lines]
>
> Any help is appreciated.

Reply to this Message