Repost ? Restructuring Databases

[Heather]

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!

 

[Kevin3NF]

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.

 

[Craig Hornish]

Hi,
I have some thoughts on this.

How are the people linked to each others Access
database? If there are tables in these MDB files they
should be put in the SQL Server Database. If other people
are accessing the Front end on someone elses machine or if
the front end is stored on the server then each of the
different Front ends they use should be put on their local
machine.
You then should have a copies on your local machine
that you can work with without any problems.
However if you need to make changes to the Table
structure then you will need them out of the tables.

My suggestion - If you have normal work days (Mon-Fri),
come in Sat & Sun. Do you get an extra day for July 4th
(July 5th is a Monday) take a 3 day weekend "Work" holiday


Craig Hornish
(e-mail address removed)
Put "Access" in Subject line)