Re: File/record locking
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 May 2006 17:28:16 -0400
I'd ask in one of the access newsgroups for the location of
documentation and samples. Basically you'll want to use optimistic
locking to handle multi-user concurrency issues. In order for this to
be successful, you need to normalize the database schema and partition
tables to avoid having users edit the same row in the same table at
the same time. If you handle normalization properly at design time,
then you'll never need to worry about locking no matter which database
engine you use.
--Mary
On Wed, 31 May 2006 08:43:02 -0700, Salvador
<Salvador@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi..
What is the recommended way to lock files/records for an Access 2003 DB in a
multi-user environment?
If you can refer me to any documentation and samples, it would be great.
Basically I want to correctly handle updates/queries to records in a
multiuser environment
I'm using Visual Studio .Net 2003 Pro
Thank you.
- Next by Date: invalid path error while accessing FOXPRO table from c#
- Next by thread: Re: File/record locking
- Index(es):
Relevant Pages
|
