|
|
Posted by Anns via SQLMonster.com on 06/23/06 16:59
OOPS
MY COMPANY!!!!!!!!!!!!!!!!!!!!!!
Anns wrote:
>I need any one's advice/imput on this...PLEASE!
>
>My computer will now begin the process of taking all the MS Access (Native
>Jet Engines - x30 total departmetns) and put the tbles/BE on SQL Server 2005
>and the Ms Access FE on MS Sharepoint.
>
>This is the kicker, say 20 out of the 30 (ball park) was created by one
>person and that is their whole job function was to create/maintain a QA
>tracking system and more.
>
>The person who created the 20 out 30 only knows intermediate ms access and
>some vba, but NOT sql or net conversions (visual studio - all the different
>languages), so the IT director asks me (I develop in MS Access and
>intermediate in VBA and can create web sites using publisher, front page and
>HTML) he asks me and this other person if we want to take on the challenge of
>helping him and the other IT guy in the conversion process of all of these
>db's.
>
>What does this do the developers who developed and still maintain these
>current 30 ms access db's, well you guessed it, it now takes all that hard
>work that those developers did and still do (they still add more forms,
>updates) and it NOW takes the databases owners away from them and grant it
>now to the person (s) who will maintain SQL Server 2005 ( I hope will be a
>DBA)???
>
>Is this true, once all the databases are converted, the owners will no longer
>be able to go behind the scenes in tables, queries,etc.... It will now be in
>the hands of a DBA?
>
>You know the funny thing is the IT Director wasn't even sure if he was going
>to hire a DBA, who in the heck will maintain all of those db's on the server?
>There is only one other guy and he certainly does not have the training or
>skills or TIME.
>
>MY POINT QUESTION IS:
>when these conversion take place like this at a company, most of the time the
>ms access dbs that have now be put into sql will now take the ownership away
>from the owner (they cannot develop no more, unless they are sql friendly/dba)
>and put all of that into one persons hand (DBA) to maintain and development???
>???
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200606/1
Navigation:
[Reply to this message]
|