Query Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Glenmore said:
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
Click to expand...

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

Cheers,

Chris.
 
Glenmore said:
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
Click to expand...

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.
 
Back
Top