A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Help



 
 
Thread Tools Display Modes
  #1  
Old August 18th, 2004, 12:08 AM
external usenet poster
 
Posts: n/a
Default 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  
Old August 18th, 2004, 02:36 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.