Access 2000

[jp_schwartz]

Hi all!!!

The only way for making a recordset to Access 2000 is ADO?
Can I use DAO?

Can someone give me some code?

Thanks!!

[smh]

Try this site...

This is where I refer to:

http://www.vb-world.net/articles/database3/index3.html

smh

[parksie]

DAO 3.6 is the earliest version that works with Access 2000.

[jp_schwartz]

Thank you very much.
So, I guess it´s time to move onto ADO.

[honeybee]

What made you switch from DAO to ADO?

DAO 3.6 can be safely used with Access 2000. And if you are using DAO 3.51 or something, you just have to change the reference from DAO 3.51 to DAO 3.6 There is no need to change any of the code. So before switching to ADO, consider the re-coding exercise.

[jp_schwartz]

Thanks, but, between ADO and DAO...
Which one is faster?, lighter?, better?

[paulw]

ADO is the future. Microsoft are not going to update DAO for much longer.

ADO is much lighter and more flexible. Better, well depends on your point of view.

My advice, use it for all new projects. Don't bother converting current DAO - its too much hassle.

Cheers,

Paul.

[jp_schwartz]

Thank you very much guys!!!

[parksie]

DAO is faster and easier to program, but it only works with Access.

[SmashingPiggy]

JP,

Word of caution. I have been working with both Access 97 and Access 2000 databases in the same program. The current version of ADO is great and manipulates both versions well. The Jet Engine 4.0 tool CompactDatabase, however, will destroy your Access 97 database.

So to compact, use the JETCOMP.EXE tool that is provided by Microsoft. It can run from a command line, use JETCOMP.EXE -? to get all of the paramaters. You will have to call it from a shell script, use the information in the Knowledgebase article Q129796 "HowTO: 32-bit App can determine when a shelled process ends" to set it up. Since you need to wait for JETCOMP to complete so that you can verify it before you "Kill" the old database.

You can get the JETCOMP.EXE from:

http://support.microsoft.com/support/kb/articles/Q273/9/56.ASP?LN=EN-US&SD=gn&FR=0


Hope that helps,

[jp_schwartz]

Thank you very much!!!