Deploy New Front End Over Network

[DougAtAvalon]

What is the easiest and fastest way to deploy a front end (with data on server) and continually update the workstations.

Is it copy file
Is it automate through VBA import changes only
I also saw a executable file solution but I don't understand it

My level is DB development with much code and coding across apps

-Doug

 

[llkhoutx]

Your mdb should be stored on a Server(file or folder) that Users are only generally aware of and only have read access (no pun intended) to.

That mdb is then copied to each Users harddrive from which it's ececuted, alternatively, each user has a batch file with does the copying at StartUp and at Users clicking an icon on his desk top. That way users will always have a current version of the mdb or can get one on demand.

 

[DougAtAvalon]

OK, so I have the Database all Networked . . .

Now I'm making updates to the database forms, etc.

How do i make this batchfile.

Let's say on each workstation there is:
c:\Directory\FrontEndFile.mdb

The Updated version is :
\\Computer\Directory\UpdatedFrontEndFile.mdb