Creating a template

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

AFAIK there is no such thing as a 'template' DB. However, you can preserve
this original copy simply by backing it up, preferably to removeable media &
then keeping it somewhere secure...



--
Cheers,

James Goodman
"Dr Alok Modi MD" wrote in message
...
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

But James
We get tempates online and with access. So is it not meant for consumers to
make templates or is it meant only for microsoft to make templates , unlike
in word and excel where we can make our own template files.

Thanks
Dr Modi

The 'templates' you download from the microsoft site (the ones which I have
downloaded at least) are just standard mdb files (the same as you or I
create).



--
Cheers,

James Goodman
"Dr Alok Modi MD" wrote in message
...

But James
We get tempates online and with access. So is it not meant for consumers
to
make templates or is it meant only for microsoft to make templates ,
unlike
in word and excel where we can make our own template files.

Thanks
Dr Modi

Hi James!
Thanks!
But what I want to understand is how do I store tham in the folder in my PC
as a template. Like in word and excel you have to store them in the path as I
mentioned in the above thread and when you click on the dialog box for save
as from the "file" menu you are given the option of "Save as "Template" .
Here in access there is no such option designed by microsoft . Why? And the
icon of a template is different (like a book) Most of all it will stay in the
templates folder like in excel and word and then easier to use. How do I
achieve that?

Thanks
Dr Alok Modi MD

As I said previously, AFAIK there is no such thing as a template in Access.

You have MDB, MDE (Compiled MDB files), ADP & ADE (Compiled ADP files). The
icons are different for for each type (MD*, AD*).



--
Cheers,

James Goodman
"Dr Alok Modi MD" wrote in message
...
Hi James!
Thanks!
But what I want to understand is how do I store tham in the folder in my
PC
as a template. Like in word and excel you have to store them in the path
as I
mentioned in the above thread and when you click on the dialog box for
save
as from the "file" menu you are given the option of "Save as "Template" .
Here in access there is no such option designed by microsoft . Why? And
the
icon of a template is different (like a book) Most of all it will stay in
the
templates folder like in excel and word and then easier to use. How do I
achieve that?

Thanks
Dr Alok Modi MD

There is no real template feature as such.

On the other hand, there is a defense between a car, and a Plane.

While you been using cars (Excel, and Word), ms-access is more of a plane.
Thus, you are kind of asking how can you put a steering wheel in a plane.
Or, the reverse being how come a car does not have wings?

But what I want to understand is how do I store tham in the folder in my
PC
as a template.

If you are able to use windows, then you can create a folder, and in side
that folder simply place your databases that you want to use. When you need
a new database, the you can simply go to that folder and copy it.

The other thing you have to remember is that ms-access is not a document
system at all. While word, and excel are applications that let you create
documents, ms-access is in fact a tool to CREATE software. ms-access is NOT
a document based system. Typically, in word, for each customer letter, you
would create a new document, and often that document will be based on a
template. In ms-access, you build, design, write code, and develop a
application. The idea that you "copy" the application over and over as a
template does not make sense. This would be akin to copying word (the
software) every time you needed to add a new customer. In other words, with
ms-access, you are not creating documents, but in fact are now a developer
of
software. Typically, for each new customer, you would add a new record, and
the "concept" or "idea" of template would be the form that you design. So,
you can most certainly think of a ms-access form as template that you fill
in, and each new record you add to that form could be considered a document,
but we are stretching things here.

Applying document concepts such as a document template to programming
systems like VB, vb.net, or ms-access simply does not fly. You need to
complete change your approach here, and realize that ms-access is a
development system, and not a document system like word, or excel.

If you don't change your conceptual approach here, you will have
great difficulty in understanding ms-access. It is a VERY
different tool then word, or Excel.

You can most certainly copy the structure of a EXISTING mdb application, and
leave the DATA behind. This is accomplished by using the import option, and
there is a check box to leave the data behind.

file-get external data-Import

You then can browse to the database of your choice, and import parts of that
application (forms, reports, tables...etc). And, there is the ability to
import the table structures..and NOT the data. So, you can (and will)
certainly raid other mdb files to grab code, forms, and tables. So, you can
certainly shuffle around parts, and pieces of applications. However, it
again
needs pointing out that we are talking about a application development
system..and not simply a bunch of documents like Excel, or word has.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

Great Analogy

I am guessing this isnt helped by Microsoft offering Access 'templates' for
download on their website...

--
Cheers,

James Goodman


"Albert D.Kallal" wrote in message
...
There is no real template feature as such.

On the other hand, there is a defense between a car, and a Plane.

While you been using cars (Excel, and Word), ms-access is more of a plane.
Thus, you are kind of asking how can you put a steering wheel in a plane.
Or, the reverse being how come a car does not have wings?

But what I want to understand is how do I store tham in the folder in my
PC
as a template.

If you are able to use windows, then you can create a folder, and in side
that folder simply place your databases that you want to use. When you
need
a new database, the you can simply go to that folder and copy it.

The other thing you have to remember is that ms-access is not a document
system at all. While word, and excel are applications that let you create
documents, ms-access is in fact a tool to CREATE software. ms-access is
NOT
a document based system. Typically, in word, for each customer letter, you
would create a new document, and often that document will be based on a
template. In ms-access, you build, design, write code, and develop a
application. The idea that you "copy" the application over and over as a
template does not make sense. This would be akin to copying word (the
software) every time you needed to add a new customer. In other words,
with
ms-access, you are not creating documents, but in fact are now a developer
of
software. Typically, for each new customer, you would add a new record,
and
the "concept" or "idea" of template would be the form that you design. So,
you can most certainly think of a ms-access form as template that you
fill
in, and each new record you add to that form could be considered a
document,
but we are stretching things here.

Applying document concepts such as a document template to programming
systems like VB, vb.net, or ms-access simply does not fly. You need to
complete change your approach here, and realize that ms-access is a
development system, and not a document system like word, or excel.

If you don't change your conceptual approach here, you will have
great difficulty in understanding ms-access. It is a VERY
different tool then word, or Excel.

You can most certainly copy the structure of a EXISTING mdb application,
and
leave the DATA behind. This is accomplished by using the import option,
and
there is a check box to leave the data behind.

file-get external data-Import

You then can browse to the database of your choice, and import parts of
that
application (forms, reports, tables...etc). And, there is the ability to
import the table structures..and NOT the data. So, you can (and will)
certainly raid other mdb files to grab code, forms, and tables. So, you
can
certainly shuffle around parts, and pieces of applications. However, it
again
needs pointing out that we are talking about a application development
system..and not simply a bunch of documents like Excel, or word has.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

Dear James & Albert
Thnaks for all your input (plane & Car). I am getting to enjoy access.
Primarily I am an intensivist (ICU Specialist) and I have been lkearning
access from books like "Microsoft access inside out " from John Viescas,
"Acess bible " by Cary, "Access 2003 step by step" "Mastering access 2003"
by Alison Balter. At present I can only make a database with let's say around
2 - 3 tables, link them , design and beautify the form, make the basic report
and move the report to excel or word. I have yet to learn a lot, I am getting
some hang of VB, but to think of the steps on my own and logically
crystallise the required steps is yet a long time away.

Thanks

Dr Alok Modi MD

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