Recent content by Vaslo

I think I found a workaround by having two tables that is a sort of like your suggestion Doc (without the SQL)- one that isn't linked anywhere but has the data uploaded to it each week and the then the one directly linked to my analysis. I run a delete query to clear out the analysis to no...

Thanks Doc but this way is way too complicated - I'm sure it works, but to do this daily would be challenging. I can't believe that I am one of the few human beings that gets a new table every week with a weeks worth of new data, and that there isn't some way in Access to just quickly drop it...

Ok let me try this - what if I have a combo unique key?

Ok so I think I've been thinking about this all wrong. Because of the dates this is one I can easily append. But for my "Weekly Data" - How do I append only the new records very simply? Each week I will have 300-1000 new transactions and they won't necessarily be in order in a way I can just...

I take back my excitement. It was loading because I had the wrong name. When I try to overwrite the table it says "Can't overwrite table or query 'Date_Table." Why would I get this error now-I thought this wouldn't be affected by referential integrity?

So essentially I've been looking at this stupidly. I thought both tables had to match exactly to keep integrity. That isn't the case after all. Thank you.

Oh wow I just tried to update the table in your suggestion and it didn't give me an error. So I should update all the other tables BEFORE I update my weekly data because the weekly data is all the foreign keys?

Ok, I attached data to illustrate. For referential integrity. If I have a few years of Dates in my "Date Table" but in my "Weekly Table" I only have about 8 weeks of data. I KNOW that I'll need the rest of the year, so I'd rather just load the rest of the "Date Table" data to avoid this step...

I attached a copy of my relationship. I think I can be clear about this without loading specific data but I'm sure you will let me know. "Weekly Data" is the data I pull each week from our Oracle Database. The only "Date" data in that table is a record called Fiscal week. That is joined to...

All, I'm fairly new to Access as a long time Excel power user. It was time to move a very data intensive process to Access to do the initial work before putting into Excel for use by sales associates. I learned all about referential integrity and built a simple data base that links about 8 or...