Hi All,
I need to do some further development on an Access Application that
I've been working on for some time. The users are working with part of
the App now. I need to write more functions into it. How do I make a
copy of the structures of all of the tables in the back-end database so
that I can put a copy on my laptop to do some development?

I'm using Access 2000.

Karen

Create a new blank database.
Import the tables from the other database.
In the Options of the import you can tell it to import only the table
structure without the data.


--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com



"Karen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
> I need to do some further development on an Access Application that
> I've been working on for some time. The users are working with part of
> the App now. I need to write more functions into it. How do I make a
> copy of the structures of all of the tables in the back-end database so
> that I can put a copy on my laptop to do some development?
>
> I'm using Access 2000.
>
> Karen
>

Create a new blank database, then fail menu>Get external data. Point to your
live app and select the option to copy the stable structure but not the
data.
--
hth,
SusanV

"Karen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
> I need to do some further development on an Access Application that
> I've been working on for some time. The users are working with part of
> the App now. I need to write more functions into it. How do I make a
> copy of the structures of all of the tables in the back-end database so
> that I can put a copy on my laptop to do some development?
>
> I'm using Access 2000.
>
> Karen
>

Oops - *file* menu. Silly spell check

<grin>

"SusanV" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Create a new blank database, then fail menu>Get external data. Point to
> your live app and select the option to copy the stable structure but not
> the data.
> --
> hth,
> SusanV
>
> "Karen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi All,
>> I need to do some further development on an Access Application that
>> I've been working on for some time. The users are working with part of
>> the App now. I need to write more functions into it. How do I make a
>> copy of the structures of all of the tables in the back-end database so
>> that I can put a copy on my laptop to do some development?
>>
>> I'm using Access 2000.
>>
>> Karen
>>
>
>

On 27 Jun 2006 11:48:35 -0700, Karen wrote:

> Hi All,
> I need to do some further development on an Access Application that
> I've been working on for some time. The users are working with part of
> the App now. I need to write more functions into it. How do I make a
> copy of the structures of all of the tables in the back-end database so
> that I can put a copy on my laptop to do some development?
>
> I'm using Access 2000.
>
> Karen

You want just the table structure without data?

File + Get External Data + Import Data
Select the database from dialog box.
Select the tables you wish to import.
Click on Options.
Select Import Relationships
Select Import Tables Definition only.
Click OK

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Na,na - Beat ya!

Hey, how have you been? Lost your email again - Doh!!!
--
SusanV


"Phillip Windell" <@.> wrote in message
news:O$(E-Mail Removed)...
> Create a new blank database.
> Import the tables from the other database.
> In the Options of the import you can tell it to import only the table
> structure without the data.
>
>
> --
> Phillip Windell [MCP, MVP, CCNA]
> www.wandtv.com
>
>
>
> "Karen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi All,
>> I need to do some further development on an Access Application that
>> I've been working on for some time. The users are working with part of
>> the App now. I need to write more functions into it. How do I make a
>> copy of the structures of all of the tables in the back-end database so
>> that I can put a copy on my laptop to do some development?
>>
>> I'm using Access 2000.
>>
>> Karen
>>
>
>

Hello Karen.

"Karen" wrote:
> Hi All,
> I need to do some further development on an Access Application
> that I've been working on for some time. The users are working
> with part of the App now. I need to write more functions into it.
> How do I make a copy of the structures of all of the tables in the
> back-end database so that I can put a copy on my laptop to do
> some development?

Is the backend also an Access database? If so, try the following:
Create a blank new database, click "file, external data, import...".
Select the backend database file and click "import". Click "Options"
to make the options appear at the bottom of the windows. There,
under "import tables", you can choose to only import the structure
of the tables. Select all tables and click "ok".

--
Regards,
Wolfgang

I'll send it to you along with the phone numbers :-)
All girls get the phone numbers free with any email request.
If they don't show up shortly, let me know.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com


"SusanV" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Na,na - Beat ya!
>
> Hey, how have you been? Lost your email again - Doh!!!
> --
> SusanV
>
>
> "Phillip Windell" <@.> wrote in message
> news:O$(E-Mail Removed)...
> > Create a new blank database.
> > Import the tables from the other database.
> > In the Options of the import you can tell it to import only the table
> > structure without the data.
> >
> >
> > --
> > Phillip Windell [MCP, MVP, CCNA]
> > www.wandtv.com
> >
> >
> >
> > "Karen" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> Hi All,
> >> I need to do some further development on an Access Application that
> >> I've been working on for some time. The users are working with part of
> >> the App now. I need to write more functions into it. How do I make a
> >> copy of the structures of all of the tables in the back-end database so
> >> that I can put a copy on my laptop to do some development?
> >>
> >> I'm using Access 2000.
> >>
> >> Karen
> >>
> >
> >
>
>

Woohoo!

;-D

"Phillip Windell" <@.> wrote in message
news:(E-Mail Removed)...
> I'll send it to you along with the phone numbers :-)
> All girls get the phone numbers free with any email request.
> If they don't show up shortly, let me know.
>
> --
> Phillip Windell [MCP, MVP, CCNA]
> www.wandtv.com
>
>
> "SusanV" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Na,na - Beat ya!
>>
>> Hey, how have you been? Lost your email again - Doh!!!
>> --
>> SusanV
>>
>>
>> "Phillip Windell" <@.> wrote in message
>> news:O$(E-Mail Removed)...
>> > Create a new blank database.
>> > Import the tables from the other database.
>> > In the Options of the import you can tell it to import only the table
>> > structure without the data.
>> >
>> >
>> > --
>> > Phillip Windell [MCP, MVP, CCNA]
>> > www.wandtv.com
>> >
>> >
>> >
>> > "Karen" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> Hi All,
>> >> I need to do some further development on an Access Application that
>> >> I've been working on for some time. The users are working with part
>> >> of
>> >> the App now. I need to write more functions into it. How do I make a
>> >> copy of the structures of all of the tables in the back-end database
>> >> so
>> >> that I can put a copy on my laptop to do some development?
>> >>
>> >> I'm using Access 2000.
>> >>
>> >> Karen
>> >>
>> >
>> >
>>
>>
>
>