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
|
|||
|
|||
Workaround at continuous DB backend changes??
I have about 600 objects in my DB, of which about 120 are tables.
Because of the DB design beeing altered all the time to be up-to-date to the data reposition demands, DB structure is constantly beeing altered, thus having to shutdown the db every once in a while to do the changes. After trying for many days to work this around, I found a solution for which I would like your opinion: I am thinking of concenarating most of the tables into one. This is how: Let's say I have two tables 1,2 with the following fields: Table1: ID, DocDescription, Procedure, RespEmployee Table2: ID, ProductDesc, ProdCategory, ProductCode I thought of making a third table (table3) which has: Table3: FileCategory, FileParameter, FileValue Now, FileCategory takes two values: Documents or Products FileParameter takes values from another table which has as many records as the fields in the above tables were (without the ID), such as Procedure, RespEmployee, ProductDesc, ProdCategory, ProductCode. FileValue is a field that holds for each of the FileParameter its value. In the form, the FileParameter combo takes its values according to the value selected in the FileCategory combo. Thus I am creating sort of a one-to-many (FileParameter to FileCategory) relationship to withhold both tables. That way, whenever a change is needed, whereas in the first case I would have to shutdown the DB to make the changes, in the second case, all I have to do is to add a new record to the table holding the FileParameters. How would you think of it as a thought? Though here rises another issue. Many fields where related to other in other tables and they were also many lookup fields (though I know they are not recommended in tables). Any ideas on that??? Thank you in advance for your responses. |
#2
|
|||
|
|||
Jim
In looking at this post and your previous post (Allen responded to it), "red flags" are going up for me. It sounds as if you are working with data that is unknown-able and changes all the time, and your "DB design [is] being altered all the time". If you can't nail down a structure, I'm not sure how using a database will be of much value. Have you stepped back from what you now have and (?re-)considered the normalization of your data? How is it that the data you are working with changes in ways that cause you to modify your database? How have you currently modeled your data? (for example, have you created tables to handle each "month" of data -- embedding data in the table names works great ... for spreadsheets, but not for relational databases). Good luck! Jeff Boyce Access MVP "Jim Tanis" wrote in message ... I have about 600 objects in my DB, of which about 120 are tables. Because of the DB design beeing altered all the time to be up-to-date to the data reposition demands, DB structure is constantly beeing altered, thus having to shutdown the db every once in a while to do the changes. After trying for many days to work this around, I found a solution for which I would like your opinion: I am thinking of concenarating most of the tables into one. This is how: Let's say I have two tables 1,2 with the following fields: Table1: ID, DocDescription, Procedure, RespEmployee Table2: ID, ProductDesc, ProdCategory, ProductCode I thought of making a third table (table3) which has: Table3: FileCategory, FileParameter, FileValue Now, FileCategory takes two values: Documents or Products FileParameter takes values from another table which has as many records as the fields in the above tables were (without the ID), such as Procedure, RespEmployee, ProductDesc, ProdCategory, ProductCode. FileValue is a field that holds for each of the FileParameter its value. In the form, the FileParameter combo takes its values according to the value selected in the FileCategory combo. Thus I am creating sort of a one-to-many (FileParameter to FileCategory) relationship to withhold both tables. That way, whenever a change is needed, whereas in the first case I would have to shutdown the DB to make the changes, in the second case, all I have to do is to add a new record to the table holding the FileParameters. How would you think of it as a thought? Though here rises another issue. Many fields where related to other in other tables and they were also many lookup fields (though I know they are not recommended in tables). Any ideas on that??? Thank you in advance for your responses. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Relinking Backend using Common Dialog Permanently? | Klatuu | Using Forms | 3 | June 20th, 2005 05:48 PM |
2 Questions with Continuous Forms | Jason | Using Forms | 3 | March 18th, 2005 12:22 PM |
Subform on Continuous form workaround? | Phil Hellmuth | Using Forms | 7 | January 5th, 2005 03:03 PM |
Update backend with one more table? | Jen | General Discussion | 3 | October 7th, 2004 01:57 PM |
Need help with copying backend from frontend in code, without replication | Max Moor | General Discussion | 1 | September 3rd, 2004 02:40 PM |