View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DHM DHM is offline
external usenet poster
 
Posts: 13
Default How do I resolve recordset overflow?

I am using VBA in Excel to open an Access2003 database (~150M in size). It
worked fine but now I'm seeing an overflow error (#6) when I do an
OpenRecordset. Are there any ways to avoid this problem without using
Server? I ran the compress/repair option on the database and split the
database between tables and queries with no luck. ALSO, if I move to
Server, will I still have this problem, i.e., is it a recordset size problem
in EXCEL?

Thanks,
-David