vejlin Posted May 30, 2005 Share Posted May 30, 2005 ARGHHHHHH..... Must resist urge to toss monitor out of window. Short version: MS Access sucks by forcing me down the dark path of Windows programming and Hungarian notation. Long version: You can't handle the long version Quote Link to comment Share on other sites More sharing options...
billr Posted May 30, 2005 Share Posted May 30, 2005 Access... *shudders* Quote from the past, "It works o.k, the problem is that it doesn't scale well above two concurrent users." Quote Link to comment Share on other sites More sharing options...
Errex Posted May 30, 2005 Share Posted May 30, 2005 Man, welcome to my life!. I'm stuck here giving support to a rather cumbersome system done entirely in Access, and it really sucks the joy out of everything. Luckily, the new systems should be up and running in a couple of months... Quote Link to comment Share on other sites More sharing options...
Star Drifter Posted May 30, 2005 Share Posted May 30, 2005 I know too well the joys of working with Access based applications. Billr's quote from the past is one heard often in my present. Except his is actually polite enough to end up on the boards. Quote Link to comment Share on other sites More sharing options...
vejlin Posted May 30, 2005 Author Share Posted May 30, 2005 Well, the workday is over but I never solved the problem. Got smarter though, so I feel I'm a lot closer to the solution now. Guess 6 hours of ripping hair out in frustration wasn't a complete waste. Now I just need to figure out where the inventor of Hungarian notation lives so I can go egg his house (Bill Gates' house is probably too well guarded) Quote Link to comment Share on other sites More sharing options...
Vil-hatarn Posted May 30, 2005 Share Posted May 30, 2005 I'm using access for my eagle scout project. It's been working all right for me. While I'm here, does anyone know how to print labels out of it? Quote Link to comment Share on other sites More sharing options...
Errex Posted May 30, 2005 Share Posted May 30, 2005 You have to make a Report sporting the layout and fields you want from your database. Frankly, I'd rather recommend to export the data to Excel and make a distribution list out of that to be printed from Word or soemthing less infuriating. Quote Link to comment Share on other sites More sharing options...
Enchantra Posted May 30, 2005 Share Posted May 30, 2005 I guess I shall count myself lucky in that I've never used Access. MSWord can be bad enough with its numerous flukes. Maybe that's why I use Corel products instead. Quote Link to comment Share on other sites More sharing options...
Crusoe the Painter Posted May 30, 2005 Share Posted May 30, 2005 www.openoffice.org 2.0 will include it's own 'access' like functionality, including a report/form editting system, and besides the provided database system, it can use a variety of other DBs as a backend, from MySQL, to Postgres, to Oracle. http://www.openoffice.org/product2/base.html Plus it runs on Linux, and Windows... :) OpenOffice.org Version 2 is currently BETA though. Quote Link to comment Share on other sites More sharing options...
Unglef Posted May 31, 2005 Share Posted May 31, 2005 Reading things like this actually makes me glad that I work outside, and that I can make words on a computer and nothing else. Quote Link to comment Share on other sites More sharing options...
Star Drifter Posted May 31, 2005 Share Posted May 31, 2005 Ooo. Although OpenOffice always comes short of having the really cool features, I can't complain about the thought of using it to manipulate a MySQL Database. Vil, Access is fine for one person using it at a time. Add a second and it gets buggy. Go past two two users accessing it at a time and it can get almost unusable. At least that's my experience, and apparently a common one. Quote Link to comment Share on other sites More sharing options...
prophet118 Posted May 31, 2005 Share Posted May 31, 2005 access has its uses... having said that, when my wife does database work, she refuses to use access..lol Quote Link to comment Share on other sites More sharing options...
vejlin Posted May 31, 2005 Author Share Posted May 31, 2005 Access wasn't a choice for us (me and my wife), we inherited the system from others, and have no idea why they chose it in the first place. If I could chose I'd make the system (classroom booking system) using PostgreSQL and Java, that way it would work on any system, plus I'd actually be able to program without having a 5 ton brick tied to my arms (Access). It feels like Access is fighting me rather than being an aid. The problem yesterday (and today for that matter, I never solved it completely) has to do with something as simple as controling the scroll bars of a sub form. This should be easy one would think, and something that Access supports, but noooooo, I have to get really friendly with user32.dll and fool Access into thinking that the user is scrolling the bar. . I mean really, I'd much rather control it myself rather than relying on windows to forward messages for me. Quote Link to comment Share on other sites More sharing options...
Rastl Posted May 31, 2005 Share Posted May 31, 2005 Access is fine, if you're making a holiday card list. If you want to do anything resembling a real database application however... I say this with all the joy of being a SQL programmer. One thing I will give Access is the ease of making queries and reports in the general population. I've had a few times when I've built the hard stuff in SQL and then just gave an ODBC link to the end users so they could make their own queries and reports by themselves. And back to the SQL programming for the day. Quote Link to comment Share on other sites More sharing options...
Nanite Posted May 31, 2005 Share Posted May 31, 2005 Maybe that's why I use Corel products instead. They're cheaper, true, but come with a whole new glut of bugs. Our office uses both Corel and MS as well as Novell, and somedays my brain boils to the point where it shoots out by ears. I feel for you vejlin. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.