Continuous form corrupting database?

[jabrony76]

Hi all,

I have a multi-user mdb (split frontend and backend with the backend on our network and a frontend (.mde) local on everyone's c: drive) that becomes corrupted every once and a while (every couple of weeks).

I am determined that our network and people closing the app incorrectly are the reasons for this but one of the users insists that every time she uses this one specific continuous form, the database crashes.

Has anyone heard of a continuous form corrupting a MDB? Or even a specific form in general?

Thanks!
Andy

 

[NilsBevaart]

Do you have any special events on the form that might collapse?
Perhaps if two or more users try to edit or view the same data or apply the same VBA code this might cause your database to crash.

Nils Bevaart

 

[jabrony76]

Nils,
Not sure what you mean about the "collapse" reference.

Other than the normal "close form control", there is vba on the form to open a detail form for any record based on the ID# criteria.

Pretty basic function:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_MainForm"

stLinkCriteria = "[CMM ID #]=" & Me![CMM ID #]
DoCmd.OpenForm stDocName, , , stLinkCriteria


If two people were to attempt to run this vba at the same time, it would crash the database?

What about vba for save records or close form or open form? Why does that not crash the database also? (not that I'm hoping or anything...)

Thanks