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
3  2185 
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
"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
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Philip D Heady |
last post by:
Ok, as some of you may know I'm an Oracle newbie w/ PHP. I'd rather use
MySQL but at the office here we use Oracle and boy do I have alot to learn.
I'm starting to hate it after using MySQL!!
...
|
by: Phil Powell |
last post by:
I've read some online resources that utilize various MySQL
command-line actions to migrate data from Access to MySQL.
The situation is this: a group of co-workers of mine will be using an
Access...
|
by: leon |
last post by:
I'm writing a perl script that will among other things collect data
types from a mysql database. I'm using mysql.pm 2.9002 to retrieved
types information from the statement handle. The problem is...
|
by: Donald Tyler |
last post by:
Then the only way you can do it that I can think of is to write a PHP script
to do basically what PHPMyAdmin is trying to do but without the LOCAL in
there.
However to do that you would need to...
|
by: Jerry Weinstein |
last post by:
Hi,
I know about stored procedures and that they can speed up data entry via the
SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires...
|
by: Arpan |
last post by:
The .NET Framework 2.0 documentation states that
An Object variable always holds a pointer to the data, never the data
itself.
Now w.r.t. the following ASP.NET code snippet, can someone please...
|
by: Dave |
last post by:
Hello all
Is there a yes/no boolean datatype with mySQL? I can't seem to find if there
is, and I have used an int type set to 1 or 0 but that breaks some of my
apps that used to use access which...
|
by: scott.alfon |
last post by:
Hello,
i need your help.
I want to implement a php-script where I can access to different
database types as PostSQL, MySQL etc.
Is that possible? Furthermore I want to include an access...
|
by: Chad |
last post by:
Hi
Is it possible to substitute an alternative data source (eg MySQL or
SQL Server) into an existing MS-Access application?
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
