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

T

Tommy Boy

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???
 
F

fredg

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???
Click to expand...

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.
 
J

Judanda

Very easy! Highlight the entire database (icon with name), right click and
copy. Give it a new name. In the tables delete the current data, except
leave at least 1 record in order for the queries, forms & reports to work.
Replace the old data with the new and there you have it! Let me know how
this works for you.
 
T

Tommy Boy

Thank you for the solution.

Tommy Boy

fredg said:
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.
Click to expand...
 
T

TINA BEARD

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.
 
K

Kelly Lopez

In regards to this process.... I am attempting to redreate a database
myself, the original database has been encrypted with passwords and has been
made almost unaccessbile.
Would this process still allow me to gain access to the old database or am
I going to have to just create a new database?
 
J

John W. Vinson

In regards to this process.... I am attempting to redreate a database
myself, the original database has been encrypted with passwords and has been
made almost unaccessbile.
Would this process still allow me to gain access to the old database or am
I going to have to just create a new database?
Click to expand...

If the security is correctly implemented, it should make it mildly
inconvenient for users authorized to get at the data, and all but impossible
for anyone else to get at the data - or for that matter to copy the structure
of the database. Who administers these passwords? How does THAT person feel
about your copying the structure?

You can certainly try the suggestion - File... Get External Data... Import to
import forms and reports; likewise for tables and queries, choosing the option
"structure only". My guess is that you'll need the right passwords to do this,
though, and that if you don't have the right passwords, maybe somebody
considers that a Good Thing; in that case you'll need to have a personal
discussion to find out why.
 
K

Kelly Lopez

Thank you, I have had that conversatio with the correct person regarding
attampting to access this database . So I am clear there. I am doing soe
research in attempt to possibly find away to acces the database, because the
original disc's and passwords have been long lost.
Thank you you have been very helpful
 
J

John W. Vinson

Thank you, I have had that conversatio with the correct person regarding
attampting to access this database . So I am clear there. I am doing soe
research in attempt to possibly find away to acces the database, because the
original disc's and passwords have been long lost.
Thank you you have been very helpful
Click to expand...

I'm a bit confused: are you trying to get access to the *data in the tables*
or just the structure of the tables?

Access workgroup security can in fact be cracked; a Google search will find
many sites offering to do so. Use caution; not all these sites are legitimate.
Cases such as those you present are legitimate reasons to want to crack
security, but there are lots of other less savory reasons one would want to do
so. Hire a locksmith, rather than a burgler!
 
K

Kelly Lopez

We are attempting to access the entire database.
It was created almost 10 years ago.
The owner has lost the original discs and passwords.
He is a gyneologist.
We are attempting to find a way to access all if the information that is in
the original
database, without having to rewrite or recreate it in it's entirety.
This database that I am speaking about is on a secure server.It's only
accessible(as far as I know) through the computers in his office.
 
J

John W. Vinson

We are attempting to access the entire database.
It was created almost 10 years ago.
The owner has lost the original discs and passwords.
He is a gyneologist.
We are attempting to find a way to access all if the information that is in
the original
database, without having to rewrite or recreate it in it's entirety.
This database that I am speaking about is on a secure server.It's only
accessible(as far as I know) through the computers in his office.
Click to expand...

Hrm. If it's medical practice data with information about patients' medical
conditions, then it would be covered under the very stringent HIPAA
regulations. Some would argue that Access databases simply are not
sufficiently secure to legally store such data! If you are able to extract the
data, read up on HIPAA and be sure you're in compliance with whatever new
system you construct: $50,000 fines are not a fun way to start the day.

That said, I suspect you'll need to download a password recovery utility.
Since it's an older version of Access, you may be able to do so without a lot
of effort. Check out

http://www.mvps.org/access/general/gen0037.htm
 
K

Kelly Lopez

Gynaecology is what your thinking about, refers to the surgical specialty
dealing with health of the female reproductive system (uterus, vagina and
ovaries). Literally, outside medicine, it means "the science of women".
Almost all modern gynaecologists are also obstetricians; see Obstetrics and
gynaecology.

genealogy
Inflected Form(s): plural ge·ne·al·o·gies
Etymology: Middle English genealogie, from Anglo-French, from Late Latin
genealogia, from Greek, from genea race, family + -logia -logy; akin to Greek
genos race
Date: 14th century
1 : an account of the descent of a person, family, or group from an ancestor
or from older forms
2 : regular descent of a person, family, or group of organisms from a
progenitor or older form : pedigree
3 : the study of family pedigrees
4 : an account of the origin and historical development of something
— ge·ne·a·log·i·cal \ˌjē-nē-ə-ˈlä-ji-kəl, ˌje-nē-\ adjective
— ge·ne·a·log·i·cal·ly \-k(ə-)lē\ adverb

There's nothing illegal about what I am trying to do or fines invloved as it
is not a medical data base.
It is hundreds of years of family trees.With 35 million images and at least
that much data as well.
Thank you for the link.
 
J

John W. Vinson

Gynaecology is what your thinking about, refers to the surgical specialty
dealing with health of the female reproductive system (uterus, vagina and
ovaries). Literally, outside medicine, it means "the science of women".
Almost all modern gynaecologists are also obstetricians; see Obstetrics and
gynaecology.
Click to expand...

I'm aware of that. I am not illiterate and though I'm ignorant on many
subjects, this isn't one of them.

I was responding to what you posted: to quote,
The owner has lost the original discs and passwords.
He is a gyneologist.
Click to expand...

I misread your typograpical error - assumed you missed a "c" rather than
adding a "y". There of course is no word "gyneologist", though it's a good
neologism! <g>

If the database contains
hundreds of years of family trees.With 35 million images and at least
that much data as well.
Click to expand...

it certainly would never have fit into an Access database; I presume that the
images are stored externally and that you have just the filenames of the
images stored in your database. How big is this database in MBytes, when
viewed with Windows Explorer?
 
K

Kelly Lopez

14.5 gigs

John W. Vinson said:
I'm aware of that. I am not illiterate and though I'm ignorant on many
subjects, this isn't one of them.

I was responding to what you posted: to quote,


I misread your typograpical error - assumed you missed a "c" rather than
adding a "y". There of course is no word "gyneologist", though it's a good
neologism! <g>

If the database contains


it certainly would never have fit into an Access database; I presume that the
images are stored externally and that you have just the filenames of the
images stored in your database. How big is this database in MBytes, when
viewed with Windows Explorer?
Click to expand...
 
J

John W. Vinson

14.5 gigs

"John W. Vinson" wrote:
Click to expand...

The maximum size for an Access 1.0 through 97 database was 1 GByte. 2000
through 2007 are limited to 2 GByte.

If this is an Access .mdb file it's either corrupt past all recovery, or
you've done something very interesting.

Are you QUITE CERTAIN that this is in fact an Access database? What's the
filename (with extension)? Or is it a folder with multiple files?
 
Top