Multiple users, on LAN, working on the same data base

[gocoder]

Can some one tell me how mutliple users can work on the same database across LAN, without using share point

 

[CJ_London]

If not already done, split the database into frontend and backend.

The backend consists of tables only and is placed on the network in a location that all users have access to.

The frontend consists of everything else (queries, forms, reports and code/macros) and a copy is place on each users local drive.

Ensure the front end is linked to the back end in it's new location.

Working across LANs can be slow - primarily depending on the LAN capacity/speed. Maximum number of concurrent users is 255 but a more realistic level before performance begins to suffer is around 30-40 (in my experience). Performance can also be affected by a poorly designed database and/or frontend which (typically) is bringing too much data across the network.

 

[gocoder]

Thanks for your suggestion, CJ_London!!
Before I try this across LAN, there is a small constraint which i need to fix.
-There is a form which the user fills in 8 fields and saves it. Once saved, a new record opens.
However, I want to modify the save button to save the previous record and display a new record with only a limited no of fields to display from previous record, say 4 fields display from previous record, and the user fills the remaining 4 and saves it. Thus, the save cmd should continue to display 4 fields from the previous record.Already tried below code but it displays the previous record as it is, doesn't display blank space for combo.118 and text2

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToRecord , , acPrevious
Combo118.Text = ""
text2.Text=""

 

[CJ_London]

I would post that on a new thread since it is not related to working across a LAN.

You should post this to a new thread since it is not related to LAN, but my quick response would be that in the form beforeupdate event put the following

myControl.defaultvalue=myControl

however this won't work for the first time you open the form so you probably need to expand on what you have to be clearer to other responders

 

[gocoder]

I've posted the same question in a new thread as this thread is more related to LAN .#post1407388
You can leave your reply there directly. I've tried this command for the field which needs to go blank, before update event->code builder. Like you said, it shows run time error 424.

Private Sub Combo118_BeforeUpdate(Cancel As Integer)
myControl.DefaultValue = myControl
End Sub

 

[CJ_London]

sorry I meant before update event of the form

 

[Albert D. Kallal]

I outline the concept of splitting here:
http://www.kallal.ca/Articles/split/index.htm

And here is a great primer of mine on running multiple users on a LAN and WANS:
http://www.kallal.ca//Wan/Wans.html

Regards,
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada