Does it matter where to place the front end?

[samehkh]

Hi,
When I used to develop multi-user networked access applications, I used to give every user his own copy of the frontend. I was also the network admin at that time so I could easily create shares on users' machines to hold the application, and reach it from my desktop to update the file.
In my current job, machines are set with many restrictions and i dont have any priviliges even on my own machine, so I expect it to be a hassle doing the same setup as before, so I am thinking of putting one copy of the frontend on the server and let my users access it from there.
I know it is easier in terms of having to update only one copy, but I am wondering if this will result in any performance issues.
Can anybody help?

 

[Crilen007]

Hmm, check this out...

This is the code for a little VB program I made that updates databases when the user clicks a button. ( I may have borrowed some of the code from somewhere. It was a long time ago so I can't remember)

Here is the button to update a database

Private Sub cmdCopier_Click()
Dim fso As New FileSystemObject, txtfile, fil1, fil2
    Set fil1 = fso.GetFile("\\server1\Database\SA\Copier\CopierSA.mdb")
    'frmWait.Show
    Reponse = MsgBox("PRESS OK THEN PLEASE WAIT FOR CONFIRMATION", vbExclamation, "WAIT")
    fil1.Copy ("c:\Databases\CopierSA.mdb")
    Reponse = MsgBox("Update Complete", vbOKOnly, "Database Updater")
    'Unload frmWait
End Sub

 

[samehkh]

That was a good idea, but in my case I am using an MDB file as the fron end, so it wont be able to copy itself when it is open.
I also need to know if my idea of every user having his own copy of the .mdb front end makes sense, or is it better to have one file that everybody opens from the server.

Thanks.

 

[Crilen007]

Better to have each user with their own copy.

Also, my program tells users to close down their database when it is opened.

 

[Mile-O]

Put the backend on the server, and distribute a copy of the front end to everyone's computer (and not on the server).

 

[samehkh]

Thank you!