need to create new table identical to one I already have

L

L. T. Portella

many centuries ago when Dbase was king all one had to do was to type copy
structure to xxxx and then xxxx was a new table. I have Access 2000 and
nowhere can I find an easy way to create a new table identical to one I
already have. Can someone help me? Thank you
 
P

Pat Garard

Database Window > Tables Tab
Point to any Table, Right-Click > Copy
Right-Click Empty Space > Paste
Enter a Name, Select 'Structure Only', Click 'Ok'
--
Regards,
Pat Garard
Australia

Anne & Pat Garard.
apgarardATbigpondDOTnetDOTau
_______________________________________________
 
M

Mike Painter

L. T. Portella said:
many centuries ago when Dbase was king all one had to do was to type copy
structure to xxxx and then xxxx was a new table. I have Access 2000 and
nowhere can I find an easy way to create a new table identical to one I
already have. Can someone help me? Thank you

Same as almost anything else in Windows. Copy and paste.
There is an extra step that allows you to copy just the structure or the
structure and data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top