Merging 2 versions of Access applications.

[Aldred@office]

Hi,
I have an up an running Access application (2007) in the office. However, I
was asked to add new features and bug fix some of the issues on the current
version.

For the Access, how could I have the applications running while I can
continue to modify the codes, forms, reports... etc?

Not sure which forum should I place this question, so I just choose this
very general one. If it is a better place to ask this questions, please let
me know which one so I could put my question to the correct place.

Thanks all.

 

[Allen Browne]

Split the application, as explained here:
http://allenbrowne.com/ser-01.html

You can then modify your copy, and deliver the update to others after you
have tested it fully.

 

[Tony Toews [MVP]]

I have an up an running Access application (2007) in the office. However, I
was asked to add new features and bug fix some of the issues on the current
version.

For the Access, how could I have the applications running while I can
continue to modify the codes, forms, reports... etc?

Not sure which forum should I place this question, so I just choose this
very general one. If it is a better place to ask this questions, please let
me know which one so I could put my question to the correct place.

This forum works quite well.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/