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

  • Thread starter Thread starter Arcee
  • Start date Start date
A

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.
 
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
 
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
 
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,
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
 
No, ask as often as you need.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
No, ask as often as you need.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
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.
 
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.
 
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
 
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
 
Back
Top