Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

DVW86

macrumors member
Jan 1, 2004
97
0
Washington State
Access isn't much more than a spreadsheet on steroids. It's files can only be used by one user at a time, and it's data is highly susceptible to corruption. If someone is trying to transition away from it or if they really like it's user interface, I would recommend using a true SQL database like MySQL and just conecting Access to it with an ODBC. That way you can still use whatever forms or reports you have in Access but your data is much more secure.
 

gekko513

macrumors 603
Oct 16, 2003
6,301
1
Access is not a database you want to use for anything important. Like DVW86 says it doesn't have the ability to scale if your needs grow and it is not a safe place for your data to be.
 

MisterMe

macrumors G4
Jul 17, 2002
10,709
69
USA
bousozoku said:
....

Having used Access and Paradox for Windows when they were both new, Paradox for Windows was far the better application and database structure. I'm still surprised that Access caught on at all with its poor SQL variant.

....
Access didn't "catch-on" in the true sense of the word. This POS was added to the Office bundle, which insured its "success." IIRC, somewhere in the neighborhood of half of the early adopters of the shipping version of Access lost their data. If it had not been part of Office, Access would be only a distant memory like Bob.
 

bousozoku

Moderator emeritus
Jun 25, 2002
15,689
1,856
Lard
MisterMe said:
Access didn't "catch-on" in the true sense of the word. This POS was added to the Office bundle, which insured its "success." IIRC, somewhere in the neighborhood of half of the early adopters of the shipping version of Access lost their data. If it had not been part of Office, Access would be only a distant memory like Bob.

They initially offered it for $99 on Windows 3.x and Paradox for Windows arrived a couple of months later for $129 but with an Object-Oriented programming environment and and a big iron-compatible SQL. Of course, knowing that WordPerfect took hold of Paradox at some point in time ensured its failure in the market place. Who else could take a Word Processor with huge sales and end up being marginalised so easily?

Sad that Paradox never made it to Macintosh but then, we had Reflex, right? That was another product Borland bought.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.