RE: [MS_AccessPros] table design

 

Elizabeth-

Need more info. What are these "dates" related to? Why aren't they in their
related table(s)? One-one joins are a pain the patootie.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Monday, April 30, 2012 5:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] table design

 
Hi there-

I have many, many attributes and a factless fact table (dates of events). My
first thought is that I'd like to put the attributes in separate tables by
subject matter and have one to one joins. But then I thought I better ask you
all if you thought Access would run faster if the attributes were in one wide
table.

Thanks,
Elizabeth

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 1
• New Links 1
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___