Help! Multi-user conflicts: VB4/Access 2 DB 
Author Message
 Help! Multi-user conflicts: VB4/Access 2 DB

Quote:

> Hello,

> I have a serious problem on which I have lost a lot of time, and I don't
> seem to be getting any closer to solving it.

> I have a fairly straightforward database application with one large data
> entry form intended for use by multiple users simultaneously.
> Unfortunately, despite my best efforts, when multiple users are entering
> data into the database simultaneously some receive errors, and in the end
> no records are properly saved.  The application works nicely with a single
> user.

> Can anyone suggest some places where this subject is dealt with in depth,
> or some ways I might approach this problem?  So far the manuals and the
> Knowledge Base have not helped me at all.  Is there any significant
> advantage to upgrading this application to VB 5?

There are articles in the knowledgebase for this.  If you are getting
record locking conflicts then make sure you are using dbengine.idle
[dbfreelocks].  Also don't run an edit till you are actually ready to
update.  something like this
data1.edit
data1.fill values here
data1.update.
dbengine.idle [dbfreelocks]

The trick is to wait till you are ready to update then use the edit fill
the fields in and do an update.  The quicker you are in and out the less
chance you'll have for locking problems.



Mon, 18 Oct 1999 03:00:00 GMT
 Help! Multi-user conflicts: VB4/Access 2 DB

Hello,

I have a serious problem on which I have lost a lot of time, and I don't
seem to be getting any closer to solving it.

I have a fairly straightforward database application with one large data
entry form intended for use by multiple users simultaneously.
Unfortunately, despite my best efforts, when multiple users are entering
data into the database simultaneously some receive errors, and in the end
no records are properly saved.  The application works nicely with a single
user.

Can anyone suggest some places where this subject is dealt with in depth,
or some ways I might approach this problem?  So far the manuals and the
Knowledge Base have not helped me at all.  Is there any significant
advantage to upgrading this application to VB 5?

With gratitude,

-- C. Luc Reid
   Owner, Reid Software Development

   http://www.ariasoft.com/
   Haddonfield, NJ



Mon, 18 Oct 1999 03:00:00 GMT
 Help! Multi-user conflicts: VB4/Access 2 DB

Something else to keep in mind is the Access 2k PAGE locking scheme!!

dave



Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Help with VB4 & Access 2.0 Multi User

2. VB4 /access 2 (Multi User performanc Problem - Help

3. Multi-user db access PLEASE HELP !

4. Re VB4 / Access 2 (Multi user performance problem)

5. VB4 16 bit / Access 2: Multiuser DB Error

6. Multi-User DB with Access

7. Delphi multi user app: Access Db regularly corrupting

8. Forcing update after multi-user conflict

9. Forcing update after multi-user conflict with optimistic locking

10. Multi-user tips for VB4-->MDB??

11. VB4 DataControls not multi-users ?

12. VB4: Problem with multi-user


 
Powered by phpBB® Forum Software