Stupid Question

[Tcmarsh43]

Ah okay then I suppose Ill figure out a new way to build the database then. Need to figure out what variable is bet to set as the primary key. If only I could set 2 columns as 1 primary key ^.^

Ya no kidding, you should have seen what it was going to be. A few guys here wanted hourly totals in the database but that would have been just far to big. 1.4mil*24 hah. Not going to happen.

 

[GinaWhipp]

You can set two fields as a PK. While the Table is in Design Mode, highlight both rows and click the PK button and... 2 fields are now PK's!

 

[Tcmarsh43]

O.O... You are a saint and a scholar good sir.

*Went and tried it only to realize that the one column that would have helped differentiate the rest when combined with the others to form the composite key has blank values -_- hah back to the drawing board I suppose.

 

[GinaWhipp]

Oh well, at least you learned something new!

 

[Tcmarsh43]

Just thought I would give an update. Still working on the tool. Need to segment the table up a bit to decrease the delay. I'll post an update when something arises

 

[GinaWhipp]

Thanks for update and good luck!

 

[Tcmarsh43]

Alas, I am stuck again >.< I wanted to use something like ODBC to automate my database importing new data daily... But the source of the data comes from a customized URL which downloads a csv file. I dont believe ODBC will work here for that. Any clues on a work around which will still allow me to automate the system?

 

[GinaWhipp]

Okay, that is something I have not done before... I mean the get the download from a website,, automating the import is the easy site. So, I guess the answer no, I don't.

 

[Tcmarsh43]

Alright, maybe I'll try to script something up to automate the download portion in python or something. I think I am getting a bit ahead of myself. There is still much work to be done on access ^.^

 

[GinaWhipp]

And, truefullu... If you automate everything else including the importing itself, is going to the site to save to a folder such a big deal?

 

[Tcmarsh43]

Hmm, since I created these graphs (pivot graphs) as a form, is there anyway I can prevent user's changes from being a permanent change on the original form design. Like have a master version it will always revert to?

 

[GinaWhipp]

Hmm, off the top of my head... you could put hidden fields and On_Open your graph to be *linked* to those hidden fields but on press of the button it can go to the other fields.