Page 2 of 3 [ 35 posts ]  Go to page Previous  1, 2, 3  Next

Mummy_of_Peanut
Veteran
Veteran

User avatar

Joined: 20 Feb 2011
Age: 46
Gender: Female
Posts: 3,611
Location: Bonnie Scotland

30 Jul 2012, 12:46 pm

Several years ago, I became a bit of an expert on Lotus Approach. The databases in question were used by about 20 people max. Then our office changed to MS products and the databases had to be converted to Access. I'm sorry to say that the majority of the workload was handed out to a contractor and our IT team and I was just the liaison person. I could easily get hooked on Access, just as I was on Approach.


_________________
"We act as though comfort and luxury were the chief requirements of life, when all we need to make us really happy is something to be enthusiatic about." Charles Kingsley


AdmiralCrunch
Sea Gull
Sea Gull

User avatar

Joined: 18 Apr 2010
Age: 43
Gender: Male
Posts: 227
Location: CT, USA

30 Jul 2012, 1:11 pm

AdmiralCrunch wrote:
IT is dead...

If you want a job in IT, I wish you well.


Wow, do I sound caustic! :oops:

I don't mean to sound this angry, but it just comes out that way. What I really mean to say is that IT is not the panacea for aspies like it was 10+ years ago. However, it's still likely the best place for people like us, overall.
And I do hope that you can find something that will work out for you. Still the best strategy to have is to ensure that you are more than prepared for anything, so by all means, become a master of Access and use that for all it's worth.


_________________
Dum vita est, spes est.


Robdemanc
Veteran
Veteran

User avatar

Joined: 30 May 2010
Age: 49
Gender: Male
Posts: 2,922

30 Jul 2012, 1:46 pm

AdmiralCrunch wrote:
AdmiralCrunch wrote:
IT is dead...

If you want a job in IT, I wish you well.


Wow, do I sound caustic! :oops:

I don't mean to sound this angry, but it just comes out that way. What I really mean to say is that IT is not the panacea for aspies like it was 10+ years ago. However, it's still likely the best place for people like us, overall.
And I do hope that you can find something that will work out for you. Still the best strategy to have is to ensure that you are more than prepared for anything, so by all means, become a master of Access and use that for all it's worth.


I know what you mean, when they interview now they try to weed out candidates who are too technical (which is a joke seeing as its a technical job). Its because business managers are too insecure with proper tech heads.

My career has suffered since all this happened. I worked as a business analyst for a couple of years but it was unsatisfying.



Meistersinger
Veteran
Veteran

User avatar

Joined: 10 May 2012
Gender: Male
Posts: 3,713
Location: Beautiful(?) West Manchester Township PA

06 Aug 2012, 6:12 pm

AdmiralCrunch wrote:
Robdemanc wrote:
I used to work on Siebel

So did I. :)
I worked on the CRM extensions, which were new at the time.

Quote:
But I will probably have to buy Access to do what you suggest.

See if you can get the student version, since it has most of the features but still works well enough.

Quote:
Can I ask does Access get used a lot in industry for main systems? My experience with it in the past has been as a simple one of DB that is used by a department or as part of a project etc. Does access have enterprise wide capability? to be used like oracle or sql server?

Access is used for all of the small ad-hoc databases, but never for the main source. It's too limited to be used enterprise-wide--the main limitation being that the entire DB has to be sent over the network wire to have multiple read/write.

If you want to get real DBA skills, you have to choose one of the big DBs like Oracle or SQL Server. Note that mySQL is a nice in-between DB that can do all that you need, big or small. Plus it's completely free.

I was under the assumption that MS-Access (which i hate. i'm not a visual person) could be migrated to MSSQL Server for enterprise use. Of course, the last time I was forced to use Access was back in 1994, when my COTR (US government-speak for Contracting Office Technical Representative), assigned a project to me (a non-programmer) to covert a database that resided on a VAX 6000 series mini to MS-Access. I'm a librarian, not a programmer. I ended up learning MS-Access by the seat of my pants. It took until the naval base i was working at closed own to get the strcture defined in Access and to dump the data from the VAX into a useable format. Any wonder i don't like Access?


_________________
I'm back, for the time being. Any one who even attempts to rip me a new rear end because of my opinions will find themselves reported to administration. Anyone on my Foes list that replies to my posts will automatically be reported for harassment. You have been warned.


WillMcC
Veteran
Veteran

User avatar

Joined: 16 Mar 2007
Age: 36
Gender: Male
Posts: 601
Location: Florida

07 Aug 2012, 6:23 pm

As a database administrator and developer, we use SQL Server for most of our database needs, though there are a few Access databases around. Some just use Access as the front-end and store all the tables, etc. on the SQL Server for the increased security and reliability, while others simply live on a network drive and everyone connects to the single mdb file.
Unfortunately, many of them have been designed by people who should not be designing databases, and there are even a few Access databases used to drive web pages (guess what happens when the mdb gets corrupted by a user)

Access is good to putting together something simple and can be quite powerful if you know what you're doing, but once you get into complex multi-user environments, things can get ugly. MS does make a free version of SQL Server (SQL Server Express), and provides tools to upscale from Access while retaining the front-end.


_________________
"Tongue tied and twisted, just an earth-bound misfit, I" - Pink Floyd
(and then the tower cleared me for take off)


noname_ever
Veteran
Veteran

User avatar

Joined: 25 Dec 2011
Age: 44
Gender: Male
Posts: 500
Location: Indiana

07 Aug 2012, 10:58 pm

MS Access front end projects with a SQL Express back end database work rather well. It allows you to get over the severe limitations of MS Access itself. You can create views, stored procedures, user defined functions, user defined types, etc on the SQL server and MS Access can use them fine. In fact, you can use all of them to create some rather intricate views and still use MS Access's reporting feature as if they were plain tables in MS Access. The downside is that you're still using MS Access's reporting engine.



Robdemanc
Veteran
Veteran

User avatar

Joined: 30 May 2010
Age: 49
Gender: Male
Posts: 2,922

08 Aug 2012, 2:59 am

I have done myselft a nice set of forms for my DB now and have moved on to vb.net. I am linking to my access DB and trying to reproduce a front end for it. Doing VB means I have to add more code but I love coding.

Anyone do vb.net?



MyFutureSelfnMe
Veteran
Veteran

User avatar

Joined: 26 Feb 2010
Age: 40
Gender: Male
Posts: 1,444

08 Aug 2012, 8:10 am

Robdemanc wrote:
I have done myselft a nice set of forms for my DB now and have moved on to vb.net. I am linking to my access DB and trying to reproduce a front end for it. Doing VB means I have to add more code but I love coding.

Anyone do vb.net?


No, if you must use a .net language, that's probably the worst choice. The syntax comes from BASIC. :)



AdmiralCrunch
Sea Gull
Sea Gull

User avatar

Joined: 18 Apr 2010
Age: 43
Gender: Male
Posts: 227
Location: CT, USA

08 Aug 2012, 8:12 am

MyFutureSelfnMe wrote:
No, if you must use a .net language, that's probably the worst choice. The syntax comes from BASIC. :)

TTM, my friend. TTM.


_________________
Dum vita est, spes est.


MyFutureSelfnMe
Veteran
Veteran

User avatar

Joined: 26 Feb 2010
Age: 40
Gender: Male
Posts: 1,444

08 Aug 2012, 8:12 am

Meistersinger wrote:
I was under the assumption that MS-Access (which i hate. i'm not a visual person) could be migrated to MSSQL Server for enterprise use. Of course, the last time I was forced to use Access was back in 1994, when my COTR (US government-speak for Contracting Office Technical Representative), assigned a project to me (a non-programmer) to covert a database that resided on a VAX 6000 series mini to MS-Access. I'm a librarian, not a programmer. I ended up learning MS-Access by the seat of my pants. It took until the naval base i was working at closed own to get the strcture defined in Access and to dump the data from the VAX into a useable format. Any wonder i don't like Access?


I'm not usually a "government can't do anything right" heckler, because government can do certain things right, but this wasn't one of them :) Assigning a non-programmer to a programming task. Wow.



MyFutureSelfnMe
Veteran
Veteran

User avatar

Joined: 26 Feb 2010
Age: 40
Gender: Male
Posts: 1,444

08 Aug 2012, 8:13 am

AdmiralCrunch wrote:
MyFutureSelfnMe wrote:
No, if you must use a .net language, that's probably the worst choice. The syntax comes from BASIC. :)

TTM, my friend. TTM.


Trailing twelve months?



AdmiralCrunch
Sea Gull
Sea Gull

User avatar

Joined: 18 Apr 2010
Age: 43
Gender: Male
Posts: 227
Location: CT, USA

08 Aug 2012, 8:15 am

MyFutureSelfnMe wrote:
AdmiralCrunch wrote:
TTM, my friend. TTM.


Trailing twelve months?

Time-to-market. Often, you just need something, anything, to get the job done. Finesse can be an expensive taste.


_________________
Dum vita est, spes est.


MyFutureSelfnMe
Veteran
Veteran

User avatar

Joined: 26 Feb 2010
Age: 40
Gender: Male
Posts: 1,444

08 Aug 2012, 8:26 am

AdmiralCrunch wrote:
MyFutureSelfnMe wrote:
AdmiralCrunch wrote:
TTM, my friend. TTM.


Trailing twelve months?

Time-to-market. Often, you just need something, anything, to get the job done. Finesse can be an expensive taste.


Sure, so if the only dude you have around is the one who can only do VB.net, go to town on it.

I'm able to provide TTM and quality at the same time, but maybe I have superpowers and just don't know it. There's a flipside to this coin, 90% of the effort in software is maintenance and if you produce s**t, you just increased that 90% by a factor of 8 or so.



Robdemanc
Veteran
Veteran

User avatar

Joined: 30 May 2010
Age: 49
Gender: Male
Posts: 2,922

08 Aug 2012, 12:42 pm

MyFutureSelfnMe wrote:
Robdemanc wrote:
I have done myselft a nice set of forms for my DB now and have moved on to vb.net. I am linking to my access DB and trying to reproduce a front end for it. Doing VB means I have to add more code but I love coding.

Anyone do vb.net?


No, if you must use a .net language, that's probably the worst choice. The syntax comes from BASIC. :)


What do you suggest?



MyFutureSelfnMe
Veteran
Veteran

User avatar

Joined: 26 Feb 2010
Age: 40
Gender: Male
Posts: 1,444

08 Aug 2012, 4:45 pm

Robdemanc wrote:
MyFutureSelfnMe wrote:
Robdemanc wrote:
I have done myselft a nice set of forms for my DB now and have moved on to vb.net. I am linking to my access DB and trying to reproduce a front end for it. Doing VB means I have to add more code but I love coding.

Anyone do vb.net?


No, if you must use a .net language, that's probably the worst choice. The syntax comes from BASIC. :)


What do you suggest?


Probably C#, which is incidentally also the most commonly used one. Relative to C++, there are things I think are ridiculous about C#, but it's better than VB.