Advice - Forms all recordset driven

[LisaB]

I current have a database that has several tables and subforms. Right now
the forms and subforms are table driven. We have employees at other
locations that are having speed issues, assuming due to network. What I want
to try is to have all of my forms recordset driven rather than table driven
to see if this helps with speed. Can you give me some pointers on when/where
I should assign recordset as the form datasource? Also, at what point/how do
I do the updates to each field? Is there a way easier that .updating each
field individually? Thanks for you help.

 

[Jack Leach]

I think this is the wrong approach altogether... switching to recordsets will
only slow things down further. You would have to manually code everything,
instead of letting Access forms handle it natively (recordsets are considered
a last resort for just about any kind of operation due to the inefficiency...
they are very versitile, but pay for it in performance).

You generally want to run froms from a table or query (a query saved as an
object, not build through vba... saved queries are more efficient because
they are pre-optimized).

There's a plethera of different things to do to increase performance, and
practically none of them have to do with what drives your forms. Instead you
do things like keep a persistent backend connection, turn off Name
Autocorrect, set all table subdatasheet properties to None, make sure you
don't reconnect your linked tables every startup (causes "bloating"), compact
and repair often... etc., etc..

For each of the above named performance enhancers there's a website that
someone or another has covered well, including all of the reasons why. I
don't have the links handy at the moment... google what you can, if you need
more let me know and I'll look them up.

Good luck!
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

In addition, you mention that you have users at other locations... this is a
tough one to work with, especially for the beginner. Albert Kallal has a
great article on the in's and out's of working in this scenario, and Devid
Fenton provides much information on replication methods as well.

http://members.shaw.ca/albertkallal/Wan/Wans.html

http://www.dfenton.com/DFA/Replication/index.php?title=Main_Page


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)