Page 2 of 2 FirstFirst 12
Results 17 to 21 of 21

Thread: Access Grrrrrr!

  1. #17
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    I've used MySQL at uni, hence the reason this appears to be such a steep learning curve!! I'm doing a military project where they don't trust free stuff at the moment

    They'd rather spend the taxpayers money on inferior stuff

  2. #18
    Member
    Join Date
    Aug 2003
    Location
    Near Glasgow
    Posts
    164
    Thanks
    0
    Thanked
    0 times in 0 posts
    Do I detect a certain amount of snobbery here? Horses for courses. Not everyone requires an all singing all dancing SQL database for enterprise use with thousands of users, warehousing and data mining.

    Access is a rapid development tool and it is pretty good at it. Remember, Access isn't the database, it's the front end - Jet is the database.

  3. #19
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    Thats the point I was trying to make - Access is fantastic in it's own space, and has very - just don't try and run anything too complicated off of it. I personally hate the fact you can't even do simple stuff like subqueries, but thats cause I've got used to better things Hopefully they'll ditch Jet in newer versions and use MSDE instead.

    jaow83 - have you thought about using the MSDE instead, if the military won't stretch to MS-SQL proper?
    Now go away before I taunt you a second time.

  4. #20
    Member
    Join Date
    Aug 2003
    Location
    Near Glasgow
    Posts
    164
    Thanks
    0
    Thanked
    0 times in 0 posts
    What do you define as too complicated? If something is technically complicated, you probably have a point but a lot of things in life are not that complicated when you break it down.

    I had an Access Document Control system and Commercial Management system for a £200m construction job - a semi conductor plant. Bits of it were complex and it had up to 16 simultaneous users (two front end programs each linked to three database back ends - didn't even realise that I couldn't do sub-queries (what are they anyway?). I take it that it's not a query based on a query based on another one?

  5. #21
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    It's when you're trying to do something like:

    select customer,(select sum(total) from orders where order.custumerFK=customers.customerID) AS totalspent FROM customers

    OK - it's not the way I'd do this in real life - it's just an example (you could do this particular example much easier and quicker). I've just realised I haven't used Access since '97 so maybe they've added that now. It's something they've added recently in MySQL (they had promised it for the last three versions, IIRC).

    I also hate the way you can't define a foreign key of the tables own primary key (grrr).

    I have seen an huge amount of systems based on access, and nothing turns out interfaces so quick.

    The current project I'm working in is a content management system, interface is web based, for ~50 simultaneous editors, distributed worldwide, and ~1500 simultaneous content readers 24/7/365. I wouldn't like to even attempt that on Access!
    Now go away before I taunt you a second time.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •