Windows 7 Forums


Windows 7: Ms Access 2010 or MySQL

09 Apr 2010   #1

W7 X-64 RTM,SUSE 11.1, XP PRO SP3 as a VM, VMware ESXi
Hafnarfjörður IS
 
 
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 problems?



Thread Tools



Similar help and support threads for: Ms Access 2010 or MySQL
Thread Forum
Access 2000 VS Access 2010 Database replication Microsoft Office
Win 7 , WAMP MySQL workbench - cannot access project on other computer Network & Sharing
Any problems using Access 2007 database with Access 2010? Microsoft Office
MS Access - MySQL export Microsoft Office
phpBB + MySQL + IIS7?? Network & Sharing


All times are GMT -5. The time now is 02:21 AM.



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