Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Ms Access 2010 or MySQL


09 Apr 2010   #1

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 
Ms Access 2010 or MySQL

Hi all
I LIKE Ms office 2010 so far -- although in the beta I've found - and posted previously - a couple of errors in Outlook 2010 when using IMAP as the email option.

I've tried however the ACCESS DATABASE and it really seems week against the FREE MySQL - even when you don't want to use MySQL as a server.

The only thing Access 2010 has going for it is that it seemlessly can create tables from EXCEL spreadsheets directly from which you can then run some simple queries. Quite a handy feature for running in Stand Alone mode on a workstation.

So as a Database for a single application on a STAND ALONE workstation Access is fine but IMO it's not robust enough for a shared database on which you would actually want to do some serious updates and queries on even a SMALL office LAN.

Anybody else think that Access isn't really strong enough to use as a "Proper" productive small database on an office LAN even for a one off type of application.

I know that MS have SQL server but that's overkill for what I need -- however Access goes the other way - it's just not robust enough.

MySQL works just fine -- but it's a bit of a bother getting EXCEL data into it which is where ACCESS scores. The SQL language on both databases is similar so no probs there.

I'd love to see ACCESS beefed up a bit -- MS Office is all about the OFFICE SUITE operating seamlesslessly -- and where it works it works great -- but a weak DB application really lets it down.


Cheers
jimbo

My System SpecsSystem Spec
.

Reply

 Ms Access 2010 or MySQL




Thread Tools



Similar help and support threads for2: Ms Access 2010 or MySQL
Thread Forum
Access 2000 VS Access 2010 Database replication Microsoft Office
Solved Mysql install error Software
Win 7 , WAMP MySQL workbench - cannot access project on other computer Network & Sharing
How to find the cause of mysql's not responding BSOD Help and Support
Any problems using Access 2007 database with Access 2010? Microsoft Office
MS Access - MySQL export Microsoft Office
MYSQL Error after IE patch Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 12:24 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33