[AccessD] Desperately Seeking!

Hi Sherri:

I am not familiar with .adp FE but have used AccessXXXX/VBX FE, SQL BE,
Unbound Forms and Recordsets for years. It is all in how you use and set the
recordsets.

First, ODBC is a little slower than ADO-OLE, in some cases much slower.
Second, All lists of downloaded are Read-Only and filled Forms are one
record at a time Read-Only.

Third, When selecting a record for modifying, Read that one record from the
SQL, open Dynamic, lock-it and check the errors.

If it is current being used then someone else the appropriate error code can
be captured. How you handle the locked record is of your own preference.
Maybe a user prompt like 'Current record is already being updated; Try
Again?'...

Fourth, When the user has completed the record, they can save it or moving
off the record cause a 'Do you wish to save' prompt. If the record is saved
the session is closed and they now are just viewing Read-Only records again.

If this method is used right you will be surprised how many users can be
using a BE without time-outs and slow responses.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Marcus
Tewksbury
Sent: Friday, May 02, 2003 7:16 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Desperately Seeking!


Can Anyone Help Me?

I have built a client server application using .adp front end and SQL
Server back end.  Within the application itself I use unbound forms and
retrieve records using ADO recordsets at run time.  The way I have
initially deployed the application is to copy an instance of the .adp to
each desktop and run it locally.  The problem has been that people keep
overwriting each other's updates - and changes are not reflected fast
enough.

I have a couple of different thoughts on how to tackle this - either
ratchet down the ODBC refresh rate, or run a single, centralized copy of
the .adp (which throws up some non-updateable warning every time it
starts which I don't know how to suppress).  Of course, I acknowledge
that I am a total newbie, and both of these options may be flawed.

Thanks a bunch,

- Sherri





_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com