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
|
|||
|
|||
Repost ? Restructuring Databases
I posted this before and I am hoping someone can help or
lead me in the right direction.. I am about to redesign my departments Database structure. Basically we have to many and no one knows who is doing what. Also people link from each other and if you (ME) is trying to code new stuff I get locked out and corrupt my database's. I am hoping some one has suggestions on how I should do this? We pull tables in via ODBC. So Yes, People within my office are using Access as the front-end to the SQL Server database. I hope this makes sense but we also have tables that are manually updated like once a year or quarter and they are linking off of them as well. So If I am in a database and I am making changes to code and then want to run it and in the mean time they link to my tables and they are all ready running their stuff I get errors can't make changes right now do not have exclusive rights. I get locked out lose my stuff. You have to imagine a mess. About 35 Ms Access database that are all linked to one another in someway. I just want to make sure I set this up right. Any suggestions would be great! THANKS! |
#2
|
|||
|
|||
Repost ? Restructuring Databases
Good luck!
Not sure what else to tell you other than document everything before you even think about re-designing... -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs. "Heather" wrote in message ... I posted this before and I am hoping someone can help or lead me in the right direction.. I am about to redesign my departments Database structure. Basically we have to many and no one knows who is doing what. Also people link from each other and if you (ME) is trying to code new stuff I get locked out and corrupt my database's. I am hoping some one has suggestions on how I should do this? We pull tables in via ODBC. So Yes, People within my office are using Access as the front-end to the SQL Server database. I hope this makes sense but we also have tables that are manually updated like once a year or quarter and they are linking off of them as well. So If I am in a database and I am making changes to code and then want to run it and in the mean time they link to my tables and they are all ready running their stuff I get errors can't make changes right now do not have exclusive rights. I get locked out lose my stuff. You have to imagine a mess. About 35 Ms Access database that are all linked to one another in someway. I just want to make sure I set this up right. Any suggestions would be great! THANKS! |
Thread Tools | |
Display Modes | |
|
|