Access Developer Extensions (ADE) 2003

[ajetrumpet]

Folks,

Does anyone have any idea where these extensions are in this day in age? Are they available for purchase? If so, where? I think MS has kindof said "goodbye" to them, and they are now not available from those geniuses. I may have to resort to Ebay, but I don't even know if they can be found there anymore. Are there any leads out there? Thanks folks!

 

[ajetrumpet]

For anyone interested, I have found this website: http://support.microsoft.com/kb/243957/EN-US/

Has anyone ever deployed a runtime version of Access that is of an earlier version that what their product was developed in? For example, our product is developed in 2003, but I'm wondering if using the Access runtime version 2000 would work after saving the .MDB as a 2000 format in Access 2003. Anybody have any experience with this? Thanks...

 

[ByteMyzer]

If your database, saved in A2000 format, is fairly vanilla, there should be no issue. If it contains extensive code, particularly code with reference to methods available in A2002/2003, but not in A2000, such as binding ADO Recordsets to listboxes/comboboxes, you will have issues.

Do you have access to a machine that only has A2000 RunTime on it? If so, I recommend comprehensive testing in both environments.

 

[ajetrumpet]

Myzer,

The database is more than 100 MB in size, so vanilla is probably out of the question. I have never really gotten the difference between the ADO and DAO, but I don't believe I even use ADO recordsets. How would I know? The only recordsets I use in this problem are dynasets. And all combos and list boxes are bound using the recordsource property, not ever in code.

 

[ByteMyzer]

dbOpenDynaset is a DAO.RecordsetTypeEnum, so your Recordsets are DAO.

That issue aside, there are numerous other factors (too many to list here) that could prevent it from working properly in A2000 if it was designed with A2003, regardless of its format. I recommend strenuous testing in the following environments and noting any differences in its behavior:
* A2003 (with the RunTime switch, ex. "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime C:\MyFolder\MyDatabase.mdb)
* A2000 RunTime

 

[giovaanni]

The extensions are included with VSTO 2005. You should still be able to find a copy of this hanging around somewhere.