Prev: Printing copies of report without opening it
Next: duck
From: Romal Naseri - AFG Romal Naseri - on 26 Apr 2010 04:13
Dear Dr.Alok,
I realized what u mean,
CreatingMS Access Database templates just like Microsoft predesigned
templates!
Basically this option should be availible and this is not a case of car and
plane(If it was microsoft wouldnt have access database templates)

This option is not availible with Ms Access 2003, but fortunately it has
been availible with MS ACCESS 2007.

NOW ENJOY USING THIS FEATURE IN ACCESS 2007!!!!

Tnx nd regards,
Romal Naseri - AFG


"Dr Alok Modi MD" wrote:

> I have created a database which I like and I would like to preserve it as a
> template. Like you can save a word document as a template in the path,
> C:/Documents & settings/(Name of user)/application data/Microsoft/Templates
> in Win XP for word and microsft excel, how do you save it as a template in
> access? There is no feature in access which allows you to "save as a
> template" when you select in the dialog box in the save command from the file
> menu unlike in word and excel.
> Thanks for your time
>
> Dr Alok Modi MD
From: Larry Linson on 27 Apr 2010 19:57
"Romal Naseri - AFG" <Romal Naseri - AFG(a)discussions.microsoft.com> wrote

> Dear Dr.Alok,
> I realized what u mean,
> CreatingMS Access Database templates just like Microsoft predesigned
> templates!
> Basically this option should be availible and this is not a case of car
and
> plane(If it was microsoft wouldnt have access database templates)
>
> This option is not availible with Ms Access 2003, but fortunately it has
> been availible with MS ACCESS 2007.
>
> NOW ENJOY USING THIS FEATURE IN ACCESS 2007!!!!

The capability to create templates has been available in every version of
Access. It is just done differently in Access 2007. The reason you don't
see a plethora of templates available is that there is no viable business
model for providing them, except for Microsoft to promote use of Access.

If you want to give your work away, as many do, or save to modify and reuse
a database application you've created it is a great deal more trouble to
create a template that allows the user to modify the logic of the database
than it is to simply save the database and document areas that may need to
be modified.

In other Office products, templates provide formatting and style. Access
"templates" are quite different from the other office templates in that they
are not for formatting and style, but for generating database applications,
and allowing the user to make business-logic choices to be applied (but
regardless of the Access version, each of those business-logic options must
be thought through and designed in advance).

Larry Linson
Microsoft Office Access MVP


 | 
Pages: 1
Prev: Printing copies of report without opening it
Next: duck