I want to run some of my Access97 databases over 802.11B wireless network 

connections, but they run so EXTREMELY SLOWLY that it is unusable.



I'm looking for suggestions that will speed this up.



I have SQL Server 2000 but I'm only beginning to learn to use it.



How can I use VBA to select data from SQL Server (or Access) as it is 

needed rather than getting the entire database at once?



Thanks in advance,



Darron

Access is a bandwidth hog--of necessity since there is no server doling out

data--every client gets entire tables & wrangles them w/their own

processors.



ActiveX Data Objects (ADO) is the VB(A) way of interacting with a server db

(like SQL server)--that's likely your best bet.  You might also consider

switching to a more recent version of Access, which has better support for

ADO & also features 'data access projects'--a new type of Access application

that is tailored to working w/SQL server back-ends.  I've not worked w/ADP's

myself & understand that they are a bit rough around the edges in A2K.  I

would imagine that they are improved in AXP, but I have no actual

information on that...



HTH,



-Roy



-----Original Message-----

From: Darron Michael [mailto:darron.michael@h...]

Sent: Friday, July 27, 2001 8:35 AM

To: Access

Subject: [access] Speeding up Access97 - Optimum method?





I want to run some of my Access97 databases over 802.11B wireless network 

connections, but they run so EXTREMELY SLOWLY that it is unusable.



I'm looking for suggestions that will speed this up.



I have SQL Server 2000 but I'm only beginning to learn to use it.



How can I use VBA to select data from SQL Server (or Access) as it is 

needed rather than getting the entire database at once?



Thanks in advance,



Darron

---