Wortz, Charles
CWortz at tea.state.tx.us
Fri May 2 09:50:22 CDT 2003
Marcus, If more than one person is trying to update the same record at the same time, it sounds as if you have poor business procedures in place. In an organized organization two or more people do not to try to update the same record at the same time! Now that we have disposed of the business problems which you are probably not in a position to solve, let us tackle your technical problems. With unbound recordsets you do not have exclusive access to the records and you cannot lock the data until the user makes their changes. If you need to allow users to hit against the same data, then you need to bind and lock the data until the first user is done. If you stick with unbound recordsets, then limit the recordset to only one record. That limits the possibility that somebody else is trying to update the same record. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Marcus Tewksbury [mailto:tewksbum at hotmail.com] Sent: Friday 2003 May 02 09:16 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