ms access database

[samson]

Hello all,

Is there anyone that can help me out of this problem:

I have an access database application runing on my system and i want it to be available to number of users on the network that will post data and the data will reflect on the server.

Please kindly assist me. I will really appreciate it.

samson

[cdishawaii]

If you are running this database on a network, the best solution, for multiple users to enter data - is to split the database - you can distribute the frontend (contains only forms, reports, queries) to those users with a link to one backend database (which will only contain the database tables).

[samson]

cdishawaii,

I really appreciate the solution you suggested.

Thank you very much, it has got me out of the problem.

There is a point i dont know if i implemented well.

Here is the scenario:
I did as you suggested, but i had to link the table with - Link Table command in Get External Data menu that is under File Menu.

It is working but, the network administrator said my application is causing a congestion on the network.

Let me say once again, i really appreciate the solution but i dont mind if you can still help further on the network issue. Or is it something else that is congesting the network?

Thanks a lot.

Samson Ojo

[cdishawaii]

Yes, the steps you have performed are the correct ones. The only other suggestion, is to have your users use the front-end database file on their respective local harddrive; this should alleviate strain on the network by putting the processing back onto the user's computer.

Aloha
Dawn
cdishawaii

[samson]

Hi cdishawaii,

Thank you very much once again.

I have done exactly as you suggested.

If i have further issues i will let you know.

By the way, how is your name pronounced?

Have a wonderful time.

Regards,

Samson

[cdishawaii]

Excellent! My name is Dawn, like the time of day before sunrise.

Take care
Dawn Sanders
CDIS Hawaii

[KLMCats]

How do you have the values set on FORM_OPEN?
This code:
Private Sub Reconcile_AfterUpdate()

If Me!Reconcile = 0 Then
Me!commit2invoice.enable=true
Else
Me!commit2invoice.enable=false
End If

End Sub
---
only executes when the value of RECONCILE is changed. You need the same sort of coding to execute on FORM_OPEN

[Allan Murphy]

The main problem is that you can not change the record source of the form as it is a 1 to many query.

From my understanding the Account Officer(s) will make the final adjustment to the passenger breakdown e.g number of females, males, children, infants, staff on duty and free tickets etc. When the value of the reconcile field is zero then the commit2invoice will be enabled for the user to click.

Using this scenario I have added the following code to the relevant form.


Private Sub Children_AfterUpdate()
check_reconcile
End Sub

Private Sub Female_AfterUpdate()
check_reconcile
End Sub

Private Sub FOC_AfterUpdate()
check_reconcile
End Sub

Private Sub Infant_AfterUpdate()
check_reconcile
End Sub

Private Sub Male_AfterUpdate()
check_reconcile
End Sub

Private Sub SOD_AfterUpdate()
check_reconcile
End Sub

Sub check_reconcile()
If Me!Reconcile = 0 Then
Me!commit2invoice.Enabled = True
Else
Me!commit2invoice.Enabled = False
End If
End Sub

Samson maybe able to add more information regarding the requirements etc.