Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to duplicate an access database without the old data??

 
   Database Help (Home) -> MS Access RSS
Next:  CheckQueryProcessorAlive  
Author Message
TINA BEARD

External


Since: Feb 08, 2005
Posts: 1



(Msg. 1) Posted: Tue Feb 08, 2005 12:51 pm
Post subject: Re: How to duplicate an access database without the old data [Login to view extended thread Info.]
Archived from groups: microsoft>public>access (more info?)

I ALSO FOUND THIS TO BE A GREAT HELP, BUT HIS YEAR I NEED TO ADD ANOTHER ITEM
(BOX) FOR LABOR CHARGES I PUT ONE IN BUT IT DOES NOT LET ME TYPE IN THIS BOX
I GET AN ERROR LIKE IT IS BOUNDED TO LABOR AND IN THE BOX WHERE I WOULD PUT
MY TOTALS IT READS "NAME#?" NAD IT WONT LET ME TYPE ANYTHING IN THERE. I
BELEIVE THAT IT HAS SOMTHING TO DO WITH THE CONTROL SOURCE IN THE PROPERTIES.
BECAUSE THE LABOR OPTION IS NOT IN THERE. I ALSO TRIED COPYING ANOTHER BOX
AND JUST CHAGING THE NAME IN DESIGN VIEW BUT THAT COPIES THE SAME BOX AS THE
ONE I COPIED. PLEASE HELP.

"fredg" wrote:

 > On Thu, 6 Jan 2005 07:41:01 -0800, Tommy Boy wrote:
 >
  > > I have an access database I am using. I want to duplicate the queries,
  > > forms, reports, tables ...etc. I do not want the old data and I want the new
  > > database to have a new name. I'm sure there is an easy way to do this???
 >
 > Create a brand new blank database.
 > Click on File + Get External Data + Import
 > Navigate to the existing database that has the forms, tables, etc. you
 > wish to use.
 > Select all the tables, forms, etc, you wish to import.
 > Click on the Options button.
 > Select Definitions Only as the Import Tables option
 > Set the other options as needed.
 > Click OK.
 > Name the new database whatever you want.
 > --
 > Fred
 > Please only reply to this newsgroup.
 > I do not reply to personal email.
 >

 >> Stay informed about: How to duplicate an access database without the old data?? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Is it any way to programmatically store and hide data insi.. - Hi, I'm reverse ingeneering an Access database based application program for integrating it into our enterprises database. I should synchronize the access database data with our SqlServer 2000 databases in order to allow the "alien" applica...

Duplicate data - I'm trying to finish up with a database but I keep getting duplicate fields on my report. I know the reason why, but I can't figure out how to develop the database any other way. I have a form with a subform that has tabs, on certain tabs, there are..

making data duplicate - I am creating a database to track all of our company's no good parts. I have the database complete, but I want to make it so that the user can press a command button and duplicate all of the information execpt for two fields. Is this possible without....

new database with duplicate structure - Sorry for reposting but has been a couple of weeks!! Thanks to Stockwell43 and Fredq for their suggestions from that post. I used the import data from external source and did indeed get a database with all empty tables. Unfortuantely this also..

Duplicate data based on multiple fields - I have one table that has the below three fields: Email 1 Email 2 Email 3 How do I prevent the same email address being entered into ANY of all the three fields? For example, when I enter test@test.com into email 1 and email 2 and email 3, the..
   Database Help (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]