Query Access Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenmore - 03 Nov 2005 16:23 GMT

Please can someone let me have some example code for querying an Access
database via a VB script.

I would like to be able to return a count of rows in a table in an Access
database via a VB script.

I have tried various options from Google but none of them seem to work in
the way I would like.

Thanks

Reply to this Message

Denis Dougall - 03 Nov 2005 16:40 GMT

Post your code and let us have a look at it.

Denis

> Please can someone let me have some example code for querying an Access
> database via a VB script.
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Chris M - 03 Nov 2005 16:41 GMT

> Please can someone let me have some example code for querying an Access
> database via a VB script.
[quoted text clipped - 6 lines]
>
> Thanks

Where will the VB Script be running from? What exactly are you trying to
acomplish?

Cheers,

Chris.

Reply to this Message

Chris2 - 04 Nov 2005 02:21 GMT

> Please can someone let me have some example code for querying an Access
> database via a VB script.
[quoted text clipped - 6 lines]
>
> Thanks

Glenmore,

Which data access method? DAO, ADO, RDO, ODBC Direct, or VBSQL?

And why vbScript? Is this for a web page? (Usually VBA is just fine
for most MS Access tasks.)

Sincerely,

Chris O.

Reply to this Message