By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,882 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

Data types when using Access with MySQL

P: n/a
I want to use MS Accesss as a front end for an existing MySQL database.
Since Acceess doesn't have the same data types, eg. ENUM, am I tied to the
smaller subset of types supported by Access? I'm assuming I have to
duplicate the MySQL schema within Access then link the resulting tables.

Garry
Aug 7 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
zaphod wrote:
I want to use MS Accesss as a front end for an existing MySQL database.
Since Acceess doesn't have the same data types, eg. ENUM, am I tied to the
smaller subset of types supported by Access? I'm assuming I have to
duplicate the MySQL schema within Access then link the resulting tables.

Garry


Further to my question, if I wish to execute SQL queries from within Access
am I constrained by the subset of SQL supported by Access?

Garry
Aug 7 '05 #2

P: n/a

"zaphod" <no**@none.com> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
zaphod wrote:
I want to use MS Accesss as a front end for an existing MySQL database.
Since Acceess doesn't have the same data types, eg. ENUM, am I tied to the smaller subset of types supported by Access? I'm assuming I have to
duplicate the MySQL schema within Access then link the resulting tables.

Garry

Since we ise MS Office heavily in front of a MySQL/Linux server, we tend to
shy away from incompatible data types that have no Microsoft equivalent.
E.G. you *might* be able to use something like BIGINT, but there will be
gotchas so we just practice avoidance. I *think* enums will come across (to
Office) as a simple text field.

Given the caveat about incompatible types (and why would you choose to use
them anyway?), you generally don't worry about duplicating MySQL schemas
within Access. Just use the MySQL ODBC driver and create linked tables. The
ODBC driver will do the translating. The only potential nuisance is when
you change the underlying (linked) table. In this case you *must* use the
Access linked table manager to update the link or subtle errors can creep in
without warning.

Further to my question, if I wish to execute SQL queries from within Access am I constrained by the subset of SQL supported by Access?


Not if you use a Pass Through query! You can elect to define an Access
query as a "Pass Through" query in which case the SQL statement you enter
will go directly to MySQL to be parsed by the server. This, of course, can
be anything MySQL understands. Very cool!

Thomas Bartkus
Aug 10 '05 #3

P: n/a

"zaphod" <no**@none.com> wrote in message
news:42***********************@ptn-nntp-reader04.plus.net...
zaphod wrote:
I want to use MS Accesss as a front end for an existing MySQL database.
Since Acceess doesn't have the same data types, eg. ENUM, am I tied to the smaller subset of types supported by Access? I'm assuming I have to
duplicate the MySQL schema within Access then link the resulting tables.

Garry

Since we ise MS Office heavily in front of a MySQL/Linux server, we tend to
shy away from incompatible data types that have no Microsoft equivalent.
E.G. you *might* be able to use something like BIGINT, but there will be
gotchas so we just practice avoidance. I *think* enums will come across (to
Office) as a simple text field.

Given the caveat about incompatible types (and why would you choose to use
them anyway?), you generally don't worry about duplicating MySQL schemas
within Access. Just use the MySQL ODBC driver and create linked tables. The
ODBC driver will do the translating. The only potential nuisance is when
you change the underlying (linked) table. In this case you *must* use the
Access linked table manager to update the link or subtle errors can creep in
without warning.

Further to my question, if I wish to execute SQL queries from within Access am I constrained by the subset of SQL supported by Access?


Not if you use a Pass Through query! You can elect to define an Access
query as a "Pass Through" query in which case the SQL statement you enter
will go directly to MySQL to be parsed by the server. This, of course, can
be anything MySQL understands. Very cool!

Thomas Bartkus
Aug 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.