Acc97 Recordsets vs Acc2000/2002

[thivar]

Hope group is correct. Just upgraded from Acc97 to Acc2002(OffXP
Dev.Ed), a new app I made seems to have automatically chosen Acc2000
as its format, as DatabaseUtils-ConvertDatabase offers conversion to
Acc97 and Acc2002, while Acc2000 is grey. Is this normal, what are
pros/cons of using different formats? Can I by the way still
develop/deliver apps that work in Acc97?

MAIN CURRENT PROBLEM - pleeeaaase help )
How would this code need to look to function in newer versions (new
objects/methods?):

Dim dbs As Database
Dim rst As Recordset
Dim str As String
str = "tblTable" 'OR some SQL statement
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset(str , dbOpenSnapshot) 'OR
dbOpenDynaset

Sure would appreciate help on this.

By the way, I read in help about objects ADO/DAO but am as you see
confused, is there any good starting point/overview in help or maybe
online articles to help deconfuse me?

thank you!
Thor Ivar

 

[Allen Browne]

From your code window, choose References from the Tools menu.
Check the box beside:
Microsoft DAO 3.6 Library
Uncheck everything else except the 2 required libraries (Access and VBA).
The DAO library works better than ADO for native Access databases. More info
on references:
http://allenbrowne.com/ser-38.html

Access 2002 can save the database back to A97 format if needed. From the
main Access window:
Tools | Database Utilties | Convert.

To choose what database format to use by default:
Tools | Options | Advanced | Default File Format.
There is no great difference between the 2000 and the 2002/2003 formats.
2000 has the advantage that computers using Access 2000 can use the file. If
you plan to release an MDE from Access 2002, you must use the 2002/2003
format.