DCount table in another db

[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

 

[Stefan Hoffmann]

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.

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?

A query could do it:

SELECT Count(*)
FROM NewTable
IN PathAndFilenameOtherMDB


mfG
--> stefan <--

 

[Tom]

Many thanks

Works perfectly

Tom

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 <--