MySQL Forums
Forum List  »  Microsoft Access

Re: MIgrating MS access database to MySQL
Posted by: Sebastien Caisse
Date: December 08, 2005 07:12AM

First, indeed it is opensource.

- Make sure you have the proper rights on the relationship tables (rtfm) so the MT can read the information from it.
- Special attention needs to be paid for queries for conversion into views, though this should be pretty simple, all depends on the complexity of the query really... There might be headaches if the programmer was overzealous with the VBA support in queries which can be a plague...

There is no trigger support in Access.

If you're planning on keeping the interface, you should know that the ODBC driver sometimes has issues using the .update function, reporting that the record is locked when it's not. This is a known problem and several workarounds are proposed in the online docs.

[Edit] Oh yeah the the nullable state of a column is badly reported to ODBC/JDBC, so for the most part columns are ported as NOT NULL (except obviosuly when indexed PRIMARY KEY or UNIQUE). There is another instance where it's propagated properly but I haven't investigated it yet.

Edited 1 time(s). Last edit at 12/08/2005 07:29AM by Sebastien Caisse.

Options: ReplyQuote

Written By
Re: MIgrating MS access database to MySQL
December 08, 2005 07:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.