|
|
|
|
|
| |
 Answer |
|
| |
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.
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Thank you for the solution.
Tommy Boy
"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.
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
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.
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
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?
"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.
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
"John W. Vinson" wrote:
> On Mon, 26 May 2008 08:36:00 -0700, Kelly Lopez
> <KellyLopez@discussions.microsoft.com> wrote:
>
> > 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?
> >
>
> 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.
> --
>
> John W. Vinson [MVP]
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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.
"John W. Vinson" wrote:
> On Mon, 26 May 2008 12:24:01 -0700, Kelly Lopez
> <KellyLopez@discussions.microsoft.com> wrote:
>
> >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.
> >
>
> 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
>
> --
>
> John W. Vinson [MVP]
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
On Mon, 26 May 2008 15:45:01 -0700, Kelly Lopez
<KellyLopez@discussions.microsoft.com> wrote:
>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.
>
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.
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.
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?
--
John W. Vinson [MVP]
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
14.5 gigs
"John W. Vinson" wrote:
> On Mon, 26 May 2008 15:45:01 -0700, Kelly Lopez
> <KellyLopez@discussions.microsoft.com> wrote:
>
> >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.
> >
>
> 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.
>
> 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.
>
> 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?
> --
>
> John W. Vinson [MVP]
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
Question
Notify me of replies