[AccessD] mysql BE for Access?

Arthur, just out of curiosity, have you used mySQL on a Linux server
with Access linked to it?  I just wondered about the performance vs. a
windows OS based server/mySQL install.

Rusty 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, September 15, 2011 7:48 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] mysql BE for Access?

Arthur,

I purchased your e-book.

Since you seem to be the resident expert...

How doable is this?

The database is currently Access MDB based, split into about 5 different
BEs because of data size and speed issues.  ~ 180 tables, ~ 10 major
tables, ~1.2 million records in the largest major table. 
  The data itself is not extraordinarily large as databases go, probably
about 5 gigs today and up to 10 gigs in the next few years.

   ~25 users in the database all day every day.

The server is currently a 4 physical core Intel based Dell server circa
early 2K, running Windows 2000 x32, with 4 gigs of RAM.  Replacing the
server is in the plan but not in the immediate future - not in 2011.

1) What are realistic server hardware requirements?
2) Is MySQL highly threaded?  Will a modern high core count processor
help?  Lots of memory?
3) Can I migrate existing mdbs / tables to mysql easily, quickly and
safely?
4) Are there tools to assist with this?  Can it be scripted?
5) Can I link back to these tables using odbc in a manner similar to
what I do in SQL Server?
6) What is performance like?
7) Can mysql enforce relational integrity and all that?
8) Are there gui tools for table and index creation?
9) Any tricks or things I need to understand going in?

Arthur, as mentioned I have purchased your book and will read it but I
thought I'd get a discussion started about the reality of actually using
mysql long term for a real production database with an Access front end,
specifically the pain of setting up MySQL and doing the conversion.

Anything anyone can tell me is most appreciated.

John W. Colby
www.ColbyConsulting.com

On 9/14/2011 11:59 PM, Arthur Fuller wrote:
> See my website for how to do exactly this, JC. www.artfulsoftware.com.

> There are chapters concerning this and also, should you require it, 
> how to hook .NET to MySQL as well.
>
> HTH,
> Arthur
>
> On Wed, Sep 14, 2011 at 11:08 PM,
jwcolby<jwcolby at colbyconsulting.com>wrote:
>
>> Is this doable?  I am using SQL Server as the data store for Access 
>> and positively love it but it is expensive.
>>
>> Is anyone using MySQL or some other cheap / free but powerful data 
>> store with Access?
>>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************