Moving Forms etc 1

[andy61]

I'm a bit green on Access, but is it possible to move forms/reports/modules etc between databases ? ie release a new version of a form to replace an existing one in a database.

 

[PHV]

Have a look at the DoCmd.TransferDatabase method.

A common way is to split the DB into one shared BE and one local FE for each user, and then simply replace each FE with the latest version.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[andy61]

That looks like just the thing I need. A decade ago I was an Oracle forms designer and it was a lot easier as forms were held as an executable outside the database, but looking on the internet it doesn't seem that simple for Access. I think I'll build myself a release database to manage versions.