why split the db

i have tried splitting my database, it produces the main database with all tables,forms,queries and a backend - just the tables. if i have tables in the front end as well, what's the point of splitting it?

2.if i were to place my db on the server, can i set it for exclusive use? meaning, i want only one person to open it at one time.

3. my database does a search function. no entering new records, just search. if this is placed on the server, and so that a few people can use it at the same time, it is safe to set the default open mode to 'shared'? or is it better to set the open mode to exclusive so that only one person can search at a time.

plz help.thanx.

1. You split a database so that

-You can run in a multi user enviroment with less problems
-So you can edit the interface (forms, queries, reports) with out interfering with the data (espically when developer is not on site)
-Provide more overall flexiblity

There are lots more reasons


2. Sure if that is what you want

3. You can do what ever works best for you app. The best method (as far as locking) is decided by your needs.



S-

Baxter were you able to open the DB i sent at FTP. iv run out of ways in figuring them out.plz help?

I uploaded you a modified DB, with code under the ETC Date, to the FTP site

The I changed the form to allowedits yes and locked all the fields

S_

Thank you Baxter. U did a miracle. The locked fields really make a difference.
However when the actual date length = 0, i want the status OPEN.
Now what happens is - even when i key in an empty actual date, status = CLOSED.

this is the code :

Private Sub Actual_GotFocus()
Dim Password As String
Dim Actual As String

Password = InputBox("Password is required to edit this field,please enter now.")
If Password = "password" Then
Me.Actual = InputBox("Please enter the Actual date")
If Me.Actual = "" Then
Me.Status = "OPEN"
Else: Me.Status = "CLOSED"
End If

Else
MsgBox " You don't have the right to edit this field"
End If
End Sub

* this part - Status = CLOSED even when Actual date has 0 length.

------------------------------------------
have also tried :

Password = InputBox("Password is required to edit this field,please enter now.")
If Password = "password" Then
Me.Actual = InputBox("Please enter the Actual date")
If Len(Me.Actual) = 0 Then
Me.Status = "OPEN"
Else: Me.Status = "CLOSED"
End If

* this part makes status = CLOSED even when date field is clicked on,enter password, but no date is entered.
__________________________________________________ ____

also this :

Private Sub Actual_GotFocus()
Dim Password As String
Dim Actual As String

Password = InputBox("Password is required to edit this field,please enter now.")
If Password = "password" Then
Me.Actual = InputBox("Please enter the Actual date")
If Len(Actual) = 0 Then
Me.Status = "OPEN"
ElseIf Not Len(Actual) = 0 Then
Me.Status = "CLOSED"
End If

* this part makes status when field is filled up with a date remain at OPEN. when it should be CLOSED.

what should i do?
thanks a million for yr help.

also baxter how do you lock all fields?

i think i know how to do that...look at txt box properties,right?