DMSoft Technologies is glad to announce the release of DBForms from MS
Access to PHP + MySQL v3.0.0.
DBForms from MS Access to PHP + MySQL allows you to convert MS Access
forms to PHP driven WEB pages and Microsoft Access tables to MySQL database.
This converter combines the strengths of
ypes
>
> The MS Access fields are:
>
> Currency (formatted to £ with two decimal places e.g. £10.00)
DECIMAL(nnn,2)
You'll have to add your own signage ($,£, etc.) upon extraction.
>
> Currency (formatted to £#,##0.00;(£#,##0.00)
>
> Date/Time (with a Now() default)
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS
DBConvert.com announces DBForms from MS Access to PHP + MySQL v.2.1.1
release.
Our application allows you to convert mdb (Microsoft Access databases) and
MS Access forms to AJAX based WEB page using PHP and MySQL. DBForms for MS
Access to PHP + MySQL supports elements in MS Access forms such
, July 18, 2007 10:08 AM
> To: 'Jim Winstead'
> Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: MySQL Connector/ODBC 3.51.17 fails to work with MS
> Access 2002
>
> I was unable to get 3.51.17 to work with MS Access 2002. I
> installed it from
> the msi bundle
I was unable to get 3.51.17 to work with MS Access 2002. I installed it from
the msi bundle. The connector passes a test when creating or configuring a
System DSN, but when I try to link tables from MS Access I get an error
message:
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]Access denied
If the connection itself passes a test, but MS Access hangs, I don't know
what to suggest. I'm not an expert, it just worked when I tried it.
You use File... Get external data... Link tables, right? Is that where it
hangs? Does it list the tables in your MySQL data base, or doesn
Does the ODBC connector itself pass its test (on the connector configuration
page)? That would determine whether or not this is an MS Access problem, at
least.
Unfortunately, I don't know what to suggest in either case, other than
making sure you have the latest connector software. I presum
Original Message-
> From: Langson B.-Computer Specialist [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 15, 2007 3:56 AM
> To: mysql@lists.mysql.com
> Subject: Ms access front end and mysql back end
>
> I am failing to connect to my server. I am using ms access as
> fron
privileges;' afterwards.
Give it a try !!!
- Original Message -
From: Langson B.-Computer Specialist <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Monday, January 15, 2007 3:56:12 AM GMT-0500 US/Eastern
Subject: Ms access front end and mysql back end
I am failing to conne
I am failing to connect to my server. I am using ms access as front end and
mysql as back end.
What is the solution
Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
--
MySQL
?
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 12, 2006 2:06 PM
To: C K; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: Views accessed as table in MS Access
C K wrote:
> Hello,
> I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2
C K wrote:
Hello,
I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with
Jet
4.0. Currently it is not giving the normal problem of Access while
inserting
new records (#deleted), but when a View created in database is linked
with
MS Access it is not giviing correct results
Hello,
I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet
4.0. Currently it is not giving the normal problem of Access while inserting
new records (#deleted), but when a View created in database is linked with
MS Access it is not giviing correct results.
e.g. There are two
EMAIL PROTECTED]
> > Sent: Tuesday, July 04, 2006 5:45 PM
> > To: C K; mysql@lists.mysql.com
> > Subject: Re: MS Access gives error no. -7776.
> >
> > C K wrote:
> >
> > > Thanks for your sugesstions. I tried to search this issue on
> > > microsof
:
> -Original Message-
> From: Daniel Kasak [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 04, 2006 5:45 PM
> To: C K; mysql@lists.mysql.com
> Subject: Re: MS Access gives error no. -7776.
>
> C K wrote:
>
> > Thanks for your sugesstions. I tried to search t
> -Original Message-
> From: Daniel Kasak [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 04, 2006 5:45 PM
> To: C K; mysql@lists.mysql.com
> Subject: Re: MS Access gives error no. -7776.
>
> C K wrote:
>
> > Thanks for your sugesstions. I tried to search
> server 2005 express edition
> I am tring to use seperate forms for dataentry. Thanks again
> CPK
> On 7/3/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
Contrary to the advice given on working with MS Access, I've found that
I can *only* get things to work with Access 2
ver 2005 express edition
I am tring to use seperate forms for dataentry. Thanks again
CPK
On 7/3/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
>
> d
> > -Original Message-
> > From: C K [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, July 02, 2006 8:29 AM
> &
rate forms for dataentry. Thanks again
CPK
On 7/3/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
d
> -Original Message-
> From: C K [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 02, 2006 8:29 AM
> To: mysql@lists.mysql.com
> Subject: MS Access gives error no. -7
C K wrote:
> Dear Friends,
> I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS
> Jet SP 8. It is giving error -7776 (There is no message for this
> error) while jumping from a form to a subform having two different
> tables for these tow forms as recordsour
Hi CPK,
I suppose you've looked at the manual in:
http://dev.mysql.com/doc/refman/5.0/en/myodbc-examples.html
It you still have problems, try just the linked table, without forms.
If you can view the linked MySQL tables in MS Access,
then the problem has to do with the forms, and not wit
Dear Friends,
I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS
Jet SP 8. It is giving error -7776 (There is no message for this
error) while jumping from a form to a subform having two different
tables for these tow forms as recordsource. Can any one please help
me. It&#
Thank you very much for the tips and for the links. I think I have it
working now with a subquery.
cheers,
Andrew Zahn
Peter Brawley wrote:
Andrew Zahn wrote:
I am using MS Access to read from a MySQL database. The query
generated through access listed below returns incorrect data when
Andrew Zahn wrote:
I am using MS Access to read from a MySQL database. The query
generated through access listed below returns incorrect data when
executed in Access and doesn't work at all in MySQL. I believe it has
to Last() and with the # symbols around the date. Any insight into
I am using MS Access to read from a MySQL database. The query generated
through access listed below returns incorrect data when executed in
Access and doesn't work at all in MySQL. I believe it has to Last() and
with the # symbols around the date. Any insight into this problem would
be gr
> The only way to link tables in MySQL (to use the term from Access) is to
> use the Federated database engine. A Federated table physically exists on
> one server but virtually exists on another. This is exactly like creating
> a linked table.
>
> However, AFAIK, the Federated database engine only
"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone,
>
> Please correct me if my understanding is wrong. Does the implementation
> of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
> Database Tables to Access?"
> (http://dev.mysql.com/doc/refman/4.1
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
Database Tables to Access?"
(http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
data is actually stored in MySQL and tab
In MS Access, linked tables (not imported tables) are live with the
backend. If you change something in a linked table, that change
automatically propogates to the origin of the link and changes the source
of the data. Try setting up your tables as linked tables and see if it
helps.
Shawn
Yes! That's so cool, took me a little while to have it working but
it works.
I can retrieve a MySQL table in MS Access and even upload a new table
from MS Access to MySQL but I cannot update it from MS Access, when I
try to upload an updated table, I get an error "Table alre
Dan Nelson wrote:
In the last episode (Nov 03), Marc Pidoux said:
Eh, eh, sorry, stupid question for some of you, I'm sure...
I'm wondering if there is a way to edit a MySQL DB through MS Access
like you can for an MSSQL DB? I want to edit a lot of data, tables
etc... and doing
In the last episode (Nov 03), Marc Pidoux said:
> Eh, eh, sorry, stupid question for some of you, I'm sure...
>
> I'm wondering if there is a way to edit a MySQL DB through MS Access
> like you can for an MSSQL DB? I want to edit a lot of data, tables
> etc... and doing i
Eh, eh, sorry, stupid question for some of you, I'm sure...
I'm wondering if there is a way to edit a MySQL DB through MS Access
like you can for an MSSQL DB? I want to edit a lot of data, tables
etc... and doing it through phpMyAdmin just isn't very efficient.
Thanks,
005 5:25 PM
Subject: Re: How to call C API functions from MS Access ?
"C.R. Vegelin" <[EMAIL PROTECTED]> wrote on 10/01/2005 03:51:41 AM:
Hi List,
I want to call the C API functions from Visual Basic in MS Access 2003.
I assume that I have to use: "c:\Program Files\MySQL\My
"C.R. Vegelin" <[EMAIL PROTECTED]> wrote on 10/01/2005 03:51:41 AM:
> Hi List,
>
> I want to call the C API functions from Visual Basic in MS Access 2003.
> I assume that I have to use: "c:\Program Files\MySQL\MySQL Server 4.
> 1\Bin\LibMySQL.dll".
>
Hi List,
I want to call the C API functions from Visual Basic in MS Access 2003.
I assume that I have to use: "c:\Program Files\MySQL\MySQL Server
4.1\Bin\LibMySQL.dll".
In my code at module level I have included various code lines to declare
entry-points, such as:
Declare Function
Kent Roberts wrote:
Has anyone had experience with this yet? My attempts so far render "ODBC--call
failed". My connection is good and I can use select statements successfully, but no
luck with calling an SP yet. I really want to call an SP with parameters, but I'm trying
a simple one first. A
the ODBC driver. Refer to the appropriate library documentation to
figure out
how to get a recordset from a command.
If you are using ADO, I would look closely at these objects.methods:
Connection.Execute
Command.Execute (along with the Parameter object)
Recordset.Open
But you say you ar
ommunicate
with the ODBC driver. Refer to the appropriate library documentation to
figure out how to get a recordset from a command.
If you are using ADO, I would look closely at these objects.methods:
Connection.Execute
Command.Execute (along with the Parameter object)
Recordset.Open
But you
It might help if I mention my syntax is:
call spTestingStuff();
From: Kent RobertsDate: August 9 2005 6:24pm
Subject: Calling Stored Procedures with MS Access Pass-Through Queries
Has anyone had experience with this yet? My attempts so far render =
"ODBC--call failed". My connecti
Has anyone had experience with this yet? My attempts so far render "ODBC--call
failed". My connection is good and I can use select statements successfully,
but no luck with calling an SP yet. I really want to call an SP with
parameters, but I'm trying a simple one first. Also, anyone know of a f
Hi:
I have this data:
ventas_encabezado_historico_sat Query
VEH_EMPRESA
VEH_TIENDA
VEH_FECHA
VEH_STATUS
VEH_TOTAL
VEH_HORA
DLC
T01
6/1/2003
V
30
8:31:05 AM
DLC
T01
6/1/2003
V
114.28
8:38:44 AM
DLC
T01
6/1/2003
V
63.2
8:41:13 AM
DLC
T01
6/1/2003
V
8.75
8:42:47 AM
dlc
T01
6/1/2003
V
12.35
Osvaldo Sommer wrote:
This is the code:
Public Sub Graba_Recibido(texto As String)
277On Error GoTo Manejo_Error
278Dim db As Database
279Dim rec As DAO.Recordset
281texto = Mid(texto, 2, 2) & Mid(texto, 7, Len(texto) - 7)
282texto = Mid(texto, 1, Len(texto) - 1)
284Set db =
ginal Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 8:26 PM
To: Osvaldo Sommer; mysql@lists.mysql.com
Subject: Re: Problem with a repeated select from MS Access
Osvaldo Sommer wrote:
>Daniel:
>
> The program is an interfase for a weigth syste
Osvaldo Sommer wrote:
Daniel:
The program is an interfase for a weigth system in a Retail
environment.
The program query the weigth system for new data every 200 miliseconds,
if new data is received it has to be stored in the database. The table
has automatic correlative, the data in ascii, the d
info?
Osvaldo Sommer
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 6:29 PM
To: Osvaldo Sommer; mysql@lists.mysql.com
Subject: Re: Problem with a repeated select from MS Access
Osvaldo Sommer wrote:
>I have a msaccess program reading the ser
Osvaldo Sommer wrote:
I have a msaccess program reading the serial port every 200 mili sec.
Each time it has to record the data from the port to a linked mysql
table.
I run the program and run fine but after a while ( not the same elapsed
time) I start getting that the odbc fail to connect to the s
I have a msaccess program reading the serial port every 200 mili sec.
Each time it has to record the data from the port to a linked mysql
table.
I run the program and run fine but after a while ( not the same elapsed
time) I start getting that the odbc fail to connect to the server error
3151.
Wh
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Using a data modelling tool (like Dezign from
> Datanamic) or a scripting
> tool (like DbScripter), all you need do, I think, is
> load the Acces
Using a data modelling tool (like Dezign from Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is load the Access
database into the tool, configure the tool to create an export script
for MySQL (say, using InnoDB to enable FKs), touch up as desired, and
generate the s
: mysql@lists.mysql.com
Subject: Importing data from MS Access
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import "foreign keys" from MSAccess.
Question: If I read properly documentation in MYSql i
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import "foreign keys" from MSAccess.
Question: If I read properly documentation in MYSql is possible to use only
one "foreing key" per table, and fields with foreign
I have searched the whole wide world (www) for months and have not found a
converter that properly convert a MS Access image (gif, jpeg etc) to MySQL blob.
How do I solve the problem, please? I am now frustrated.
I am using Java with MySQL.
Ant
hi their,
i have a problem working with access mysql and myodbc.
i ported a access database to mysql. now i had to integrate the mysql db
in the old access frontend. i realized this with linked tables.
now i have a problem, because myodbc seems to return the wrong
results.
the relation between
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President & Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn: magi
I am new to MYSQL and I want to set-up a database with two or more tables that
need to be "linked". I come from a basic MS Access background, and in Access
linking two tables is done by creating a relationship. Is it done the same
way in MYSQL? If so, could someone please shed som
Are you looking for an interface to read MS Access other than the default
application and MS Query?
-Original Message-
From: Nik Belajcic
To: [EMAIL PROTECTED]
Sent: 5/3/04 9:52 PM
Subject: Reading MS Access tables from MySQL or Perl
Hello,
This is partially off-topic as I am looking at
Thanks for that tip. It helped me find a page which explains it properly.
In case anyone else might be interested, here is the link.
http://www.awilcox.com/geek_stuff/perl/proxy.html
--
Nik Belajcic <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Nik Belajcic wrote:
Hello,
This is partially off-topic as I am looking at reading Access tables
from either Perl (preferred) or MySQL, but if anyone has any suggestions,
I will be most grateful.
My first thoughts were to write a Perl script which will read 2 columns
from an MS Access table and
Hello,
This is partially off-topic as I am looking at reading Access tables
from either Perl (preferred) or MySQL, but if anyone has any suggestions,
I will be most grateful.
My first thoughts were to write a Perl script which will read 2 columns
from an MS Access table and load them into MySQL
Hi,
This post does in fact more belong to a windows-emulator group, but I've had
no success there. Maybe someone on this list knows what's wrong.
I want to make a database with an ms-access frontend (using codewavers wine
implementation) and a mysql backend.
I've installed m
Daniel Kasak wrote:
Patrick Kirk wrote:
[...]
CREATE TABLE `tblContacts` (
`p_ID` bigint(11) NOT NULL auto_increment,
That's your problem there. You can't have a bigint() column as a primary
key when Access is being used. In fact you probably shouldn't have any
bigints at all if you're usi
Patrick Kirk wrote:
Hi all,
I've installed the latest MDAC and Jet service packs on Windows 2000.
On Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to
check "Don't Optimize columns width", "Return Matching Rows", "Allow
BIG Resu
Hi all,
I've installed the latest MDAC and Jet service packs on Windows 2000. On
Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to
check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG
Results", "Use Compressed
>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 2:57 PM
Subject: MS Access and MySql
Greeting to the list.
I am running MS Access as a front end to data stored on MySql in
a Redhat 7.3 box.
I have about 95% functionality so far!
(The Database is of a Youth Soccer league).
I
How did you originally populate the MySQL database with this table in
question? Did you export the table via MS Access and load the data with
either LOAD DATA or mysqlimport?
...
Out of curiosity why did you use Access to create and populate the
tables, export them to MySQL and are using Access
The Database was originally made in Access
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Steve Siesel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 3:35 PM
Subject: Re: MS Access and MySql
What is `special` about thi
What is `special` about this one? If you are using ODBC links why are you
needing to convert the table? MS Access is merely your GUI to the
underlying data.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<&
04, 2004 3:03 PM
Subject: Re: MS Access and MySql
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
>>>>>>>>>>>>>>>>>>
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<
Greeting to the list.
I am running MS Access as a front end to data stored on MySql in
a Redhat 7.3 box.
I have about 95% functionality so far!
(The Database is of a Youth Soccer league).
I am having one problem though with one of my tables.
The table seems to double itself when I transfer
Μιχαλίδης Κώστας wrote:
Hi all,
now that MySQL 5 has support for Stored Procedures,
i was wondering if anyone managed to port (or migrate) the
Stored Procedures from MS Access to MySQL ??
(With Stored Procedures i'm referring to "queries" as they're
called in MS Acc
Hi all,
now that MySQL 5 has support for Stored Procedures,
i was wondering if anyone managed to port (or migrate) the
Stored Procedures from MS Access to MySQL ??
(With Stored Procedures i'm referring to "queries" as they're
called in MS Access)
Regards to all / Mih
everyone,
> I am new to MySQL. I am starting a database project for a medium-sized
> medical office. I chose MS-Access (on 10-terminal pre-existing Win2K
> intranet) for rapid front-end dev and familiarity to the existing users.
> I plan to use MySQL on Linux server for backend
used with MS-Access 2000 frontend
Hi everyone,
I am new to MySQL. I am starting a database project for a medium-sized
medical office. I chose MS-Access (on 10-terminal pre-existing Win2K
intranet) for rapid front-end dev and familiarity to the existing users.
I plan to use MySQL on Linux
Hi everyone,
I am new to MySQL. I am starting a database project for a medium-sized
medical office. I chose MS-Access (on 10-terminal pre-existing Win2K
intranet) for rapid front-end dev and familiarity to the existing users.
I plan to use MySQL on Linux server for backend for its speed, great
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select "Tools=>Data Management=>Import/Export Wizards," but the
command is greyed out and won't activate. I am using Of
> Hi,
>
> I am new to MySQL and old to MS Access (advanced skill level).
>
> When building Access DBs, I write VB code, SQL, develop DBs using 3rd
N.F.
> and build lovely forms for data entry, print outs, reports etc, etc.
>
> After examing MySQL's material, I don&
OTECTED]>
Sent: Sunday, December 28, 2003 16:07
Subject: Re: Forms & Reports like I use in MS Access
> On Dec 28, 2003, at 4:49 AM, Adam Jones wrote:
>
> > When building Access DBs, I write VB code, SQL, develop DBs using 3rd
> > N.F. and build lovely forms for data en
On Dec 28, 2003, at 4:49 AM, Adam Jones wrote:
When building Access DBs, I write VB code, SQL, develop DBs using 3rd
N.F. and build lovely forms for data entry, print outs, reports etc,
etc.
After examing MySQL's material, I don't see any forms like I use in
Access. So what GUI should I use a
Hi,
I am new to MySQL and old to MS Access (advanced skill level).
When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F.
and build lovely forms for data entry, print outs, reports etc, etc.
After examing MySQL's material, I don't see any forms like I use in A
Thanks everyone for great advice!
Tom's question below is also interesting.
Also, are there data compatibility/integrity issues moving from Windows/MS
Access to Linux/MySql? I know that Linux is case sensitive and MySql wants
dates to be stored as -mm-dd. Does anyone know of other i
://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
> -Ursprüngliche Nachricht-
> Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 21. Dezember 2003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS
003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS Access to MySql
>
> I need to convert an MS Access database to MySql. I would
> like to know the best way to do this. I was going to write an
> asp or php script that would read the MS Access db row by row
> and inser
: Sunday, December 21, 2003 11:00 AM
To: [EMAIL PROTECTED]
Subject: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would like to know
the best way to do this. I was going to write an asp or php script that
would read the MS Access db row by row and insert into the MySql db
Arthur
On converting data from MS Access. I've done this several times myself, and
found the easiest way is to:
1. Create your mySQL database tables
2. Define a DSN (ODBC Connection) from your workstation to the mySQL
database
3. Link the mySQL tables into your MS Access database
4. Cop
<[EMAIL PROTECTED]>
Sent: Sunday, December 21, 2003 2:30 PM
Subject: Convert MS Access to MySql
> I need to convert an MS Access database to MySql. I would like to know the
> best way to do this. I was going to write an asp or php script that would
> read the MS Access db row by row an
I need to convert an MS Access database to MySql. I would like to know the
best way to do this. I was going to write an asp or php script that would
read the MS Access db row by row and insert into the MySql db row by row. Is
that the only way to move the data from the one db to the other?
Many
Has anyone seen something like this before:
We have an Access database (about 9 megs in size) with linked tables in
it. The machine DSN shows that the information for the connection is
correct. But when you try to open the table in Access, a dialog pops up
to connect to the mysql server and t
On Fri, Sep 12, 2003 at 05:02:29PM +, [EMAIL PROTECTED] wrote:
> Hi I am trying to convert an existing access database to MYSQl and not having
> much luck I have tried dbtools but I end up with nothing transfering. Am I
> doing something wrong or is there a better conversion tool
You can ex
Hi I am trying to convert an existing access database to MYSQl and not having
much luck I have tried dbtools but I end up with nothing transfering. Am I
doing something wrong or is there a better conversion tool
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Martin Gainty wrote:
Daniel
Pass thru query executes on an ODBC Database.
Is your MySQL Server setup as an ODBC Database?
-Martin
Yes of course.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
Daniel
Pass thru query executes on an ODBC Database.
Is your MySQL Server setup as an ODBC Database?
-Martin
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 4:17 PM
Subject: Calling a stored pr
type:
call msp_BillingBySavingsNo(4211)
I get the expected result; a few records that match the query.
However if I create a pass-through query in MS Access, point it at
MySQL, and type the same exact same text as above, I get:
'SELECT in a stored procedure must have INTO (# 1282)'
A
:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 18:09
To:
Subject: Native MS Access 97 Searches from an Access Form
I'm running Access 97 as a front end to a MySQL ODBC linked table.
Everything is working fine with the exception of "long searches" from
within Access. In the past w
Sean Meegan wrote:
I'm running Access 97 as a front end to a MySQL ODBC linked table. Everything is working fine with the exception of "long searches" from within Access. In the past we would be able to go to any one of the fields from within the Form, and then do a Ctrl + F to find a record by
I'm running Access 97 as a front end to a MySQL ODBC linked table. Everything is
working fine with the exception of "long searches" from within Access. In the past we
would be able to go to any one of the fields from within the Form, and then do a Ctrl
+ F to find a record by whatever value we
Hi all,
It seems that MS Access can't find out how to "convert" the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),cur
1 - 100 of 310 matches
Mail list logo
