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  2197 
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.co m> wrote in message
news:42******** *************** @ptn-nntp-reader04.plus.n et... 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.co m> wrote in message
news:42******** *************** @ptn-nntp-reader04.plus.n et... 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!!
--------------------------------------------------------------------------
1) Is there a similar statement using PHP/Oracle functions as below for
MySQL?
--------------------------------------------------------------------------
while (list...
|
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 db in a shared source (for now, a directory.. ???) to be able
to generate reports on the fly. What they want to do is to be able to
migrate that data to a MySQL db instance that currently exists on a
different server.
What would be the best...
|
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 that all
blob and text fields return the value 252 when using the
$handle->types function and I need to differentiate between them.
Has anyone else dealt with this issue?
Any help would be appreciated.
|
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 be able to place the PHP file on the
server, and I guess you probably can't do that either. Talk about catch
22...
The only other way I can think of is to install MySQL on a machine you
control, then import the data there using the method I...
|
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 one to manually and individually enter each and every record
to be inserted to the database before the procedure is executed.
I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be...
| | |
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
explain me what does the above statement mean?
<script runat="server">
Class Clock
|
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 does have a yes/no field.
Many thanks
Dave
|
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
authorization which defines the write- or read-access of each user.
I hope this group could help me....I am looking for good ideas.
|
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: 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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
