Link tables count trouble

F

Frank Johnson

I am pretty new to VBA and I have a quick question. When linking and
external table into access from another database, I cannot seem to get
counts to work on it. I have 1500 rows in that table, but when I print a
count it only shows 1. Why? I do the same thing on a local table and
everything counts up fine?

By the way, the tables are linked using file -> external data -> link tabes

Anyone happen to know the answer to this?
 
P

Perry

Does a MoveLast/MoveFirst as examplified below get you a correct
recordcount?

Set rs = CurrentDb.OpenRecordset(MySQL)
rs.MoveLast
rs.MoveFirst
MsgBox rs.RecordCount

Krgrds,
Perry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Radio Buttons to work, that are inserted via AutoText 0
Access Linked Tabled Treated Differently? 2
"Compile error in table level validation expression " after format 0
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Table Macro Question 4
Database name added to link tables! 1
How do I break a link to an external database but keep table data? 1

Top