I wonder...

[miffe]

We all know that it's dead easy to execute Query's and bring data from access into excel, as well as outputing cells from excel into access (.mdb)'s...

BUT...

Is it possible to execute a query from excel to retrieve the number of records in an access database in a remote computer? If so... how?

Thx -
Miffe

 

[SydneyGeek]

Miffe,

The steps would be...

1. Create a recordset based on the table
2. MoveLast in the recordset
3. Return the RecordCount

You can only get the number of records by going to the end of the recordset, as far as I know

Denis