Restructuring Databases

[Heather]

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? All of our tables are linked via SQL server and we
query off them. Should I created a database that only has
those tables in it along with anything we as a department
link to and then adhocs will be done with another Database?

Any suggestions would be great! THANKS!

 

[Charlie]

I am trying to understand your situation here. Your database is hosted by SQL Server and there are other data sources stored in Access/Jet databases? By SQL Server I am referring to the Microsoft SQL Server software product. People within your office are using Access as the frontend to the SQL Server database? They are also linking to Access/Jet tables that exist on other peoples workstations

I'll try to help out with some suggestions if you can clear up some of these questions for me

----- Heather wrote: ----

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? All of our tables are linked via SQL server and we
query off them. Should I created a database that only has
those tables in it along with anything we as a department
link to and then adhocs will be done with another Database

Any suggestions would be great! THANKS

 

[Heather]

Yes,

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 makeing 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.

Thanks

-----Original Message-----
I am trying to understand your situation here. Your

database is hosted by SQL Server and there are other data
sources stored in Access/Jet databases? By SQL Server I
am referring to the Microsoft SQL Server software
product. People within your office are using Access as
the frontend to the SQL Server database? They are also
linking to Access/Jet tables that exist on other peoples
workstations?

I'll try to help out with some suggestions if you can

clear up some of these questions for me.