access

[bpaquette]

at work i use access 2k, but at home i have xp. are there any huge differences to consider when purchasing literature on access? ie i planned on buying a book on VBA, is there a diff between versions?

 

[Fizzio]

It really depends on what system you will be developing for - if most of your users are A2k then buy an A2k book but remember that there will always be a few still using A97.
This has implications as ADO, for example, is only supported in A2k onwards and some functions (such as Split for example) are only available in A2k onwards. Control of the Printers collection only in XP, etc.

 

[bpaquette]

well i work for the gov't so we have enterprise office2k, so i guess it would be safe to use 2k

thanks!

 

[Pat Hartman]

Fizzio, you can use ADO in A97. You just have to add the ADO library reference. Since you will have both ADO and DAO libraries referenced, you'll need to qualify ALL ADO and DAO operations to avoid confusion.

The nice thing about the library support of Office programs is that it allows you to link in "newer" libraries and make use of their functionality even though that functionality was not available when the Office version was issued.

 

[jeremie_ingram]

Keep in mind that the default for Access XP is actually Access 2000. You literally have to change it to 2002 mdb if you would want to take advantages of any of the few changes that were made. Anything you develop in 2002 should be based on the 2000 system.