William Benson
vbacreations at gmail.com
Tue Jan 17 01:14:30 CST 2012
Hi,
I was able to get a foreign table's recordcount with this
?currentdb.OpenRecordset("Select Count(Site_DB) from [Tbl_GIB] in
'D:\Documents and
Settings\502001258\Desktop\DB\Data.accdb'").Fields(0).Value
Is there a way to get DCOUNT to work instead?
I tried
?DCount("Site_DB", "[Tbl_GIB] in 'D:\Documents and
Settings\502001258\Desktop\DB\Data.accdb'")
but got a runtime error