MFC + Access XP

[noble]

Can one use the CDaoDatabase/CDaoRecordset with databases
created with Access XP?

If not, what classes support access (no pun intended) to access
xp databases?

Thanks in advance for any help.

[CornedBee]

I don't think so, the newest MFC version (7.0) uses DAO 6, which is used by Access 2k. I think XP uses a new version of DAO, which would make those databases unusable for MFC.
You can use the ODBC or OLE database classes instead, but they only provide a subset of the capabilites of DAO.
Or you can use other means, like ADO (but the C++ docs for ADO suck).

[noble]

doesn't microsoft provide some sort of update to msvc6 that
allow programmers to have functionality such as this? or do I
have to move to .NET?

In the meantime i can simply convert my databases as they
are only going to be available to the prog and not the client.

If using .NET is the only solution, is the version of C++
which is included comparable to MSVC6.0's implementation?
I don't care for any of that .NET, C# cross-coding capability.

[CornedBee]

The Visual C++.NET (7) C++ compiler is better than the one of 6, so don't worry there. Do you use 6? Then your DAO version is even older (DAO 5).

If you only want your app to use the database (as I do) you can create the database with your app and only edit it with your app and you'll be fine. If you already have an Access XP DB, I think there's an option to export for an older version.

If you want to use .NET I recommend programming in C#, not Managed C++. It's easier to use and you probably don't need any of the features of Managed C++.

[noble]

Thx CornedBee, you're a help as always.

Yes, I'm using 6.0.

Yes, Access XP does have an option to convert the databases
to earlier versions as that is what I'm doing.

I'm not worried about the difficulty of either language, I'm just
the kind of person who doesn't like drastic change too much.
I want something similar to what I'm doing now because it works
well for me and I'm very comfortable with it.

I think shortly I'll slowly move to C++.NET.
Thx again!

[noble]

Also, is managed C++ the equivalent to MSVC7.0?
Is that where MS hides MFC 7.0?