I have created an application and am looking for the best way to 

distribute the program.  Each user has a desktop copy of Access and 

currently the program is on a network drive the everyone has access to via 

a short cut.  The challenge I run into is the users are in different 

geographic locations and load times can be very slow. I thought about 

splitting the ap into a front end and back end and distributing the front 

end to the users but I don't know how to push out updates.  Any ideas or 

thoughts are appreciated.



Thanks for your help



Chris

If your users all need to see a common set of data, then you probably want

to split your app.  See the archive for this list at



http://p2p.wrox.com/archive/access/2001-08/95.asp



for some discussion of how advisable it is to split your app.  My advice is

to split it & put as much of it as possible on your users' machines.



I don't have a ready method for doing pushes, but you can make it easy for

your users to pull your updates by putting a shortcut on their desktop that

does a simple filecopy of your front-end from its location on the network to

some standard location on the users' machines.  I'm using a VBScript with

pretty good results here.



HTH,



-Roy



-----Original Message-----

From: Christopher Oberheim [mailto:choberheim@l...]

Sent: Tuesday, September 04, 2001 6:06 AM

To: Access

Subject: [access] Network Distribution of Ap.





I have created an application and am looking for the best way to 

distribute the program.  Each user has a desktop copy of Access and 

currently the program is on a network drive the everyone has access to via 

a short cut.  The challenge I run into is the users are in different 

geographic locations and load times can be very slow. I thought about 

splitting the ap into a front end and back end and distributing the front 

end to the users but I don't know how to push out updates.  Any ideas or 

thoughts are appreciated.



Thanks for your help



Chris

For some reason my Securing AllowBypasskey is not working.











Public Sub setstartupproperty()

changeproperty "allowbypasskey", dboolean, False

End Sub



Function changeproperty()

Dim stpropname As String

Dim varproptype As Variant

Dim varpropvalue As Variant



Dim db As DAO.database

Dim prp As DAO.Property

Const conpropnotfounderror = 3270



Set db = CurrentDb

db.Properties.Delete stpropname 'Is where i'm receiving error

Set prp = db.CreateProperty(stpropname, proptype, vpropvalue, True)'error

db.Properties.Append prp'error





On Error GoTo change_err

dbs.Properties(strpropname) = varpropvalue

changeproperty = True

MsgBox "welcome to database"

change_bye:

Exit Function



change_err:

If Err = conpropnotfounderror Then ' property not found.



MsgBox "ok2"

Resume Next

Else

'unknown error.

MsgBox "ok3"

changeproperty = False

Resume change_bye

End If





End Function

******************************************************