Hi,

I just wrote a small Excel 2003 VBA app which uses ADO to generate a
temporary database during operation.

I know that all the potential users of the application have Excel 2003
installed; however, some of them do not have Access 2003. When I ran
my first test on a non-Access machine, I got the following error:

Run-time error -2147217887 (80040e21)
ODBC driver does not support the required properties

Could anyone please advise which runtime files I will need to
distribute with my Excel 2003 spreadsheet in order for the app to run ?

Thanks and regards

Nick

Nick,

Since this hasn't been answered...

I think your best bet is to install MDAC in whatever version of ado you are
using in your code on the target machine.

If you are going to do this, you might as well upgrade everything to 2.8
(including the ado lib reference in your code) with service packs since
there have been a few security holes patched.

You can get the install packages off msdn.

It's a hassle, but you ensure you have all the latest datest provider
libraries by going this route.

Robin Hammond
www.enhanceddatasystems.com

wrote in message
oups.com...
Hi,

I just wrote a small Excel 2003 VBA app which uses ADO to generate a
temporary database during operation.

I know that all the potential users of the application have Excel 2003
installed; however, some of them do not have Access 2003. When I ran
my first test on a non-Access machine, I got the following error:

Run-time error -2147217887 (80040e21)
ODBC driver does not support the required properties

Could anyone please advise which runtime files I will need to
distribute with my Excel 2003 spreadsheet in order for the app to run ?

Thanks and regards

Nick