create Access .mdb template, save and reuse under different name

[Arcee]

I want to create 1 template, save it and later reuse it under a different
file name. Is this possible, and if so, how do I do it? Your help is
appreciated.

 

[Jeanette Cunningham]

Hi Arcee,
access 2007 allows you to save a database as a template database.
Access 2003 does not do this.
Your question was about A2003 - you can save a database, in windows explorer
copy the database and give the copy whatever name you wish. That is a bit
like having a template database, you find the template database and copy it
to create your new database.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Arcee]

Jeanette,
Thanx for your reply re: saving Access templates...truly appreciated.

Would it be too forward of me to ask on another Access issue?

Kindest regards,
Arcee
Ron Christopher
Talbott, TN USA

 

[Jeanette Cunningham]

No, ask as often as you need.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Arcee]

You are kind AND understanding...thanx!

A large Access DB...say 20K rows...now I want to extract 3K from the 20K and
enter into a NEW DB. Up to this moment I'd highlight, copy then do a new DB
using
Design View.

Here's my issue: In the NEW DB I'd dn arrow, ENTER for all 3K rows then
paste the data. Insane? Yes! Plz help. In anticipation of your reply, I
send my appreciation. Kindest regards, Ron Christopher.

 

[Jeanette Cunningham]

You can do it in a query:
SELECT
*
INTO
theOtherTable IN 'c:\temp\other.mdb'
FROM
yourQuery

or run that statement in code with

CurrentDb.Execute "SELECT * INTO theOtherTable IN 'c:\temp\other.mdb'" & _
" FROM yourQuery"

For more help in this, search the queries newsgroup on Insert into.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Now I see where the question is going, you may be interested in how to use
code to create your new database before you copy the data into it. Here are
a couple of links

The code to create a new database in Access is like this:
http://allenbrowne.com/func-DAO.html#CreateDatabaseDAO

Once you have the new database, you can use a DDL query to CREATE TABLE:
http://allenbrowne.com/func-DDL.html#CreateTableDDL


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia