RE: MSAccess
RE: MSAccess
- Subject: RE: MSAccess
- From: Chuck Hill <email@hidden>
- Date: Sat, 10 May 2003 10:12:25 -0700
Is that going to work? I don't think that EOF uses the AUTO_INCREMENT
feature for PK generation. If EOF does not use it and MSAccess does then
you are going to somehow need to ensure that they generate PKs in different
parts of the possible range so as to avoid PK conflicts.
Chuck
At 11:55 AM 10/05/2003 -0400, Kieran Kelleher wrote:
> 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.
>
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
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.