DAO with Access XP

[PaulSpell]

I've happily been using Access97 for a few years but am now on the verge of moving to XP.

Up until now I've always used the DAO method:

Dim DbName as Database
Dim TabName as Recordset

Set DbName = CurrentDB
Set TabName = DbName.Openrecordset("SomeTableName").....etc

Is all this still supported in Access XP or does it mean re-coding everything?

Incidently, would it be prudent to learn more ADO, is this a better approach?

 

[chrismcbride]

Paul
Just FYI, I am in the same boat. I am moving the office and our DB from Office 97 to Office XP. I can offer some information.

1. Yes DAO is supported as long as you set a reference. This will happen automatically if you use the conversion wizard.
2. Changing over from DAO to ADO, which is supposed to be the default since A 2000, has not been too difficult so far. Not done yet, but can see light.
3. Is there any reason to do the conversion? None that I can get anyone to attest to. I have even had postings (perhaps on other groups/forums) that suggest that it is not a good idea to try. However I though it best as there is a possible move to SQL Server BE and A XP FE in the future, so there you go.

Oddly A XP appears to still create some DAO type objects. There is no reference to DAO set in a new XP db, yet certain DAO objects and methods are still used...

Wish you luck (and mee too!) and will view any additional postings in this thread with interest.
Chris

 

[llkhoutx]

Dim DbName as DAO.Database
Dim TabName as DAO.Recordset

I've migrated to XP too. I've resisted going to ADO, as DAO meets my needs.

Note also that the expression builder is not available in vba coding with XP. Go to a query frame and use the expression builder in the criteria, then cut and paste into your code.

 

[chrismcbride]

One thing is for certain. There are far less useful resources out there when you are using XP than there are for 97. Seems that there are still way more people using good ol' 97...
Chris

 

[PaulSpell]

Thanks for the replies.

This is a load off my mind, I was having nightmares about having to re-code everything.