DCount table in another db

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Any advise/suggestions on the following would be appreciated.

A make table query is run from the current db - that table is made in a 2nd
db.

I want the user to know how many records that new table contains.

Can you use Dcount, if so how, or is there a better way?

TIA

Tom
 
hi Tom,
Any advise/suggestions on the following would be appreciated.
A make table query is run from the current db - that table is made in a 2nd
db.
Click to expand...
How do you create it, a code sample would be nice.
I want the user to know how many records that new table contains.
Can you use Dcount, if so how, or is there a better way?
Click to expand...
A query could do it:

SELECT Count(*)
FROM NewTable
IN PathAndFilenameOtherMDB


mfG
--> stefan <--
 
Many thanks

Works perfectly

Tom

Stefan Hoffmann said:
hi Tom,

How do you create it, a code sample would be nice.

A query could do it:

SELECT Count(*)
FROM NewTable
IN PathAndFilenameOtherMDB


mfG
--> stefan <--
Click to expand...
 
Back
Top