Accessing Database by multiple user at a time

[prasadmng555]

Hi,



I have created one microsoft access and would need help in getting it accessible for multiple users at a time. I am not getting it. I did try with Split option but getting below error attached error message. Can someone help me in getting the access database working by multiple user at a time.


This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs

[ranman256]

This is a 'false positive' error. The error is not on the vb code but rather an error in a property.
either a control is missing on the form, ( because its missing on the PC)
or
A bad field propery is set.

these are the toughest errors because access does not point you to the problem.

[RuralGuy]

If you actually have something like "if the OnOpen property of a form is set to =[Field]" you need to know that the Open Event is too early in the process to reference a control on your form. You would need to use the OnLoad Event for such a procedure.

[NTC]

I suggest you sanity check your situation. Return to an unsplit database and verify that all works. Then do the split putting the new back end file in a local folder, and again verify that all works. Then move the back end file to its ultimate common location and perform your table linking.