If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Help
I am creating a table using access and already have a data
table. I want to create a new one with new data and a different name for the table. How can that be done? Thanks, Cindy |
#2
|
|||
|
|||
On Tue, 17 Aug 2004 16:08:28 -0700,
wrote: I am creating a table using access and already have a data table. I want to create a new one with new data and a different name for the table. How can that be done? Short answer: with a MakeTable query based on the original data table. Longer answer: Ordinarily this should NOT be a routine operation! In a properly normalized database, you would usually have a set of defined tables containing all your data; you would use Queries to select, sort, filter and manage the data; Forms to display the data from the queries; and Reports to print that data. Only once in a blue moon is it appropriate to have two tables with data of the same "shape"; storing data in tablenames is ALWAYS a bad idea. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000 DB in Access 2002 | Tony_VBACoder | General Discussion | 2 | July 28th, 2004 01:23 AM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Recommendations needed for installation order of Access XP, Access XP runtime, ... | Mark Plantenberg | Setup, Installing & Configuration | 0 | June 11th, 2004 11:22 PM |
Does not switch from VBE to Access Main Window | Tony_VBACoder | General Discussion | 1 | June 4th, 2004 04:20 PM |