ADO Recordset.Filter in Excel 2002

Hi All
Have been using Excel to generate custom reports on data from remote
databases quite happily.
I now have a need to avoid making lots of calls to the DB by downloading the
complete table concerned and using a rsABC.Filter in a loop to do a
different multi-column FIND in each iteration to get the various records I
need.
However any statement as ' rsABC.Filter "..." ' throws a compile error
'Invalid Use of property' with the '.Filter' highlighted.


Any suggestions as to what I am missing will be much appreciated.

TIA

Dash


.

Relevant Pages

  • Re: What can you do with a Virtual Private Network?
    ... VPN drops in the middle of a database transaction can be "deadly" ... RWW probably isn't realistic for any more than 2-3 remote users ... Terminal Services is your best bet for databases and large file manipulation. ... Install another Windows 2003 server as a Terminal Server and run the apps on ...
    (microsoft.public.windows.server.sbs)
  • Re: Sync Database via Internet
    ... seems that SocketPro is a new startup product for remote data access. ... I develop apps on MS Access and SQL Server. ... My clients need real-time updating with their databases. ... Most of them do their syncing through ActiveSync which does not support ...
    (microsoft.public.pocketpc.developer)
  • Re: Feature Matrix Question...
    ... > No. Local vs. Remote applies to client/server databases such as Interbase ... > or DBase o Access files across the network is not a license issue. ... So the c/s restriction is purely related to the specific native db drivers ...
    (borland.public.delphi.non-technical)
  • RE: SBS 2003, SQL and remote access to database
    ... Have you used the SQL Server Utility to create a TCP/IP DSN? ... internal workstation you won't be able to connect to anything remote using ... > It seems the built-in firewall, although very easy to configure for the ... We need to replicate two databases - one ...
    (microsoft.public.windows.server.sbs)
  • Can you keep it from replicating the printers?
    ... I am setting up a master database that will be symced with several remote ... databases to centralize the data. ... I want the reports to stay replicable because I do ...
    (microsoft.public.access.replication)