Multiple User Lockup

[mdavis1]

every time more than one person is in the database to add files, it locks up.. i need for more than one person to enter at a time. this happens if one person is searching and one is adding,.....help...quickly...thank you.
monica

 

[MichaelRed]

A host of possabilities.

1.[tab]Are both (ALL) users set up to default to Multiuser access?

2.[tab]Do you use Autonunber for the addition of records to tables? If so, see the FAQ on Autonumber (under Ms. Access; Tables and Relationships?)

3.[tab]Are the Users (pesky little ...) attempting to access the same records?

4.[tab]What is the recordlocking setting (Optimistic; Pesimistic, ...) (Probably should be Optimistic)

5.[tab]Is this a 'split' database? (Tables in one, forms/code ... in another?)

6.[tab]If it is split what actual database is the 'backend'? If not Ms. Access MDB native tables, what connection are your using?



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[mdavis1]

1. yes
2. yes..done the faq
3. well...trying to access the same table...not same record.
4. i have it set to no locks
5. i've tried combining everything into one database, splitting into two databases....forms/queries in one and tables in another.

6. just made a blank database, imported the forms from all four databases....and linked the tables.....it still locked up....BUT..only when you accessed ONE database inparticular. same thing for when i made a blank database and imported everything. works fine until someone accesses this particular table/form (XREF). when you try to do anything in that while someone else is in anything else...you get an "out of memory" message...i've tried everything....help.
thanks in advance.
monica

 

[MichaelRed]

Obviously "table/form (XREF)" is the Key. You should check every use/instantation of this. Is it being instantiated (as a recordset object) in some type of Loop? Check especially for somethign which is (inadvertantly) accessing this via recursion.

A quick check MIGHT be to check the call stack when the error occurs. If it has a repetitive pattern, then you are doing this access in some loop or self referential process.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[mdavis1]

i've tried, looked, checked and rechecked..i am completey bumfuggled...for lack of a better word.

any POI would be greatful..thanks