RE: MSAccess
RE: MSAccess
- Subject: RE: MSAccess
- From: "Kieran Kelleher" <email@hidden>
- Date: Sat, 10 May 2003 11:55:39 -0400
Romeo,
Of course if the 'win' customer wants to stick with Microsoft that badly
and they still want serious web application connectivity, then they may be
willing to look at Microsoft SQL Server 2000 which is qualified to work with
WebObjects and MS Access can 'link' to all the tables so it 'seems' like the
tables are in Access and it allows them to do their internal queries, etc in
Access. Biggest drawback is MS SQL Server costs a lot of money!!!
Seriously though the MyODBC connector works great with Ms Access. I am
planning a solution where WO is the app, MySQL is the enterprise DB and Ms
Access can link to all the tables using the MyODBC connector. If you use the
AUTO_INCREMENT feature of MySQL, you can link to the tables from Access and
treat the tables like MS Access tables. Even when you use MS Access APPEND
of multiple rows, it works because MySQL creates the auto_increment primary
keys on the fly. Your customer can use Access to do reports, etc.
Kieran
-----Original Message-----
From: Romeo Mariani [mailto:email@hidden]
Sent: Friday, May 09, 2003 6:01 PM
To: email@hidden
Cc: email@hidden
Subject: Re: MSAccess
Kieran, thank you so much.
Unfortunately I'm not free to use another db like MySql or FrontBase.
It's a "political" must. Normally I use WO on OsX with FrontBase for my
projects.
A win customer "need" to have MSAcces like db.
So you think there is no escape?
Romeo
> Romeo, I would strongly advise you not to use MS Access even if you
> get it
> working for the following reasons
>
> 1) "The version of SQL created by Microsoft is called Jet SQL and it
> is the
> database engine behind Microsoft's Access.
>
> Jet SQL has certain limitations compared to the other versions of SQL.
> In
> general, Jet SQL is not designed to manage a database, but rather, it
> is
> used to retrieve information from a database"
> --
> http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html
>
> 2) It is not a supported configuration for WebObjects:
> http://docs.info.apple.com/article.html?artnum=72598
>
> I recommend you try MySQL which is FREE (www.mysql.com), move your
> Access
> tables to MySQL and then use WebObjects for Web-based applications to
> the
> data and you can still link to the MySQL tables from directly within MS
> Access for internal legacy Access applications using the MyODBC
> connector,
> also FREE at www.mysql.com
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
| References: | |
| | >Re: MSAccess (From: Romeo Mariani <email@hidden>) |