|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 16th, 2009, 06:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
create Access .mdb template, save and reuse under different name
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. 
|
|
#2
May 17th, 2009, 02:09 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different name
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" wrote in message ... 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.
|
|
#3
May 17th, 2009, 07:42 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different na
Jeanette,
Thanx for your reply 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" wrote: 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" wrote in message ... 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.
|
|
#4
May 17th, 2009, 08:50 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different na
No, ask as often as you need.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Arcee" wrote in message ... Jeanette, Thanx for your reply 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" wrote: 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" wrote in message ... 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.
|
|
#5
May 18th, 2009, 04:39 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different na
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" wrote: No, ask as often as you need. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Arcee" wrote in message ... Jeanette, Thanx for your reply 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" wrote: 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" wrote in message ... 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.
|
|
#6
May 18th, 2009, 07:10 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different na
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 "Arcee" wrote in message ... 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" wrote: No, ask as often as you need. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Arcee" wrote in message ... Jeanette, Thanx for your reply 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" wrote: 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" wrote in message ... 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.
|
|
#7
May 18th, 2009, 12:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
create Access .mdb template, save and reuse under different na
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 "Jeanette Cunningham" wrote in message ... 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 "Arcee" wrote in message ... 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" wrote: No, ask as often as you need. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Arcee" wrote in message ... Jeanette, Thanx for your reply 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" wrote: 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
