Group:  Microsoft Access ยป microsoft.public.access.forms
Thread: copy a database

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

copy a database
"Chely" <celia.vidal[ at ]rogers.com> 26.09.2006 00:54:11
Hello:
I want to make a copy of the structure of an existing database. This
database have linked tables and when i want to import the database
without the data, always copy the data too. I don't know how i can
acomplish to copy the database. Could somebody help me!!!. Please.
Thanks

Re: copy a database
John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 26.09.2006 01:33:57
On 25 Sep 2006 17:54:11 -0700, "Chely" <celia.vidal[ at ]rogers.com> wrote:

[Quoted Text]
>Hello:
>I want to make a copy of the structure of an existing database. This
>database have linked tables and when i want to import the database
>without the data, always copy the data too. I don't know how i can
>acomplish to copy the database. Could somebody help me!!!. Please.
>Thanks

If it is a split database, you will need to make a copy of the backend
(which contains all the data). You can create a new, empty database
and use File... Get External Data... Import to import the tables;
choose the "Design Only" option to import just the structure of the
tables, not the data.

Then use Tools... Database Utilities... Linked Table Manager in a copy
of the frontend to relink the tables to the new backend.

John W. Vinson[MVP]

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net