Re: MSAccess
Re: MSAccess
- Subject: Re: MSAccess
- From: Romeo Mariani <email@hidden>
- Date: Sat, 10 May 2003 00:01:27 +0200
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: "Kieran Kelleher" <email@hidden>) |