>
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
to view the tables?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/4/04, 2:47:51 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding Re:
MS Access and MySql:
> Th
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
lt;<<<<<<
On 3/4/04, 2:28:31 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding Re:
MS Access and MySql:
> I am using ODBC links to move the data. There were multiple
> tables in the database and this is the only one effected.
> Steve
> - Original Messag
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?
>>>>>>>>>>>>>>>>>>
;<<<<<<<<<<<
On 3/4/04, 1:57:15 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding 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% functional
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/conv
Mary,
Wednesday, August 28, 2002, 7:49:22 PM, you wrote:
MS> see my message re--- index problem
MS> ok when I do explain in this , it is not using an index for the
MS> AdminCoverage_writingagents table...
MS> SELECT admincoverage_writingagents.WritingAgentID,
MS> admincoverage_writingagents.Wr
Aye Arthur this is a different experince then what I had with Access and
MySQL. I guess my main reason for not using is because I personally dont
really need to. Nothing against you or anyone using it but to me it always
seemed to be a bit cumbersum, just my feelings.
I wish I had some e-mails
o the database.
Arthur
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Arthur Fuller" <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 1:57 PM
Subject: [Fwd: RE: MS Access and mySQL]
> wodya think?
>
>
> Original Message
>
re also abandoning Access.
If you have any specific questions, feel free to ask.
Arthur
> Original Message
> From: "Nicholas Stuart" <[EMAIL PROTECTED]>
> Subject: Re: MS Access and mySQL
> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
&g
August 28, 2002 7:32 PM
Subject: RE: MS Access and mySQL
> Or you could just use the libmySQL.dll and handle everything yourself
> through VB.
>
>
> >>You will however need to download the MyODBC driv
True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$ Universa
gentid (WritingAgentId),
KEY writingagentslot (WritingAgentSlot)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: MS Access and myS
Or you could just use the libmySQL.dll and handle everything yourself
through VB.
>>You will however need to download the MyODBC driver if you wish to access
>>MySQL through VB.
>>
>>-Nick
-
Before posting, please check:
h
Mary Stickney wrote:
> the join syntax is what is differnt between Access and MYSQL.
>
> in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
> and they will not in MYSQL
This is not true. MySQL uses indexes in joins, if you've put them in the
right colum
ck and the majority of your fields set to their proper type.
>
> HTH,
> Bryant Hester
> Juxtapose, inc.
>
> - -Original Message-
> From: Jonathan Coleman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 28, 2002 12:40 AM
> To: [EMAIL PROTECTED]
> Subject: MS
1
All it means is you may have rewrite your queries. For the most part there
are no queries in Access that you can't do in MySQL. It will just take
some time to convert the queries is all.
-Nick
Mary Stickney wrote:
the join syntax is what is differnt between Access and MYSQL.
in M
the join syntax is what is differnt between Access and MYSQL.
in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL
ogram called dbtools. You can find it at:
http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great
import wizard.
If you have an specific questions let me know and I'll try my best to
answer them.
-Nick
MySQL Newsgroup (@Basebeans.com) wrote:
>Subject: MS Access and mySQL
>
PROTECTED]
Subject: MS Access and mySQL
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are
(woohoo) upgrading to a QUBE (linux box) for a server which has mySQL
installed (and I can upgrade it etc..)
My job
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (off
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are (woohoo)
upgrading to a QUBE (linux box) for a server whi
Hi.
I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT. They are (woohoo)
upgrading to a QUBE (linux box) for a server which has mySQL installed
(and I can upgrade it etc..)
My job therefore is to
a) port MS Access data and
I have just started playing with MySQL about a week ago. I have read as
much as I can about optimizing the performance of MySQL and believe I
have everything setup according to the documenation i've read and am
very skilled at Linux.
When we attempt to link a table from MySQL, using the MyODBC d
Yes it is perfectly possible. I did that some months ago and it worked perfectly. I,
however, had to install MyODBC on the windows box. There is a good tutorial I used at
http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html
Its a good tutorial By W.J. Gilmore.
Please take note of the deci
Is it possible to export a database from mysql so MS Access can read
it as its own? I am not able to install MyODBC on the windows box
(not admin)
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
-
Stephen Johnson wrote:
> I have a client that uses an Access dB in house and wants that database to
> automatically update a MySQL database that I am creating for their website.
> Is this possible and if so where can I find some reading material on how to
> accomplish it?
>
> Thanks for the info
/
- Original Message -
From: "Stephen Johnson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 4:29 PM
Subject: Access and MySQL
> I have a client that uses an Access dB in house and wants that database to
> automa
I have a client that uses an Access dB in house and wants that database to
automatically update a MySQL database that I am creating for their website.
Is this possible and if so where can I find some reading material on how to
accomplish it?
Thanks for the information
--
Stephen Johnson
there is no command line.. you go to the mysql.com site, download
the access converter on the contributed programs page, copy the code
into an access module (macro), edit the code to tell it where to
save the result and run it.
It will produce a text file, then you can do
mysql mydatabase < myt
Can you give me a sample command line please
CHRIS
In message <[EMAIL PROTECTED]>, Steve Ruby
<[EMAIL PROTECTED]> writes
>Chris Wilkinson wrote:
>>
>> I am attempting to upload an Access db to a remote mysql server - at
>> dsvr in the UK.
>>
>> I get connected (I think) but receive the follow
On the mysql.com website under downloads: contributed there
is a chunk of VBA code you can put in an access database to make
it export to a SQL text file, use that, you are better off,
otherwise export from Access to text (comma separated for example)
and use LOAD DATA in mysql to load the file.
Steve
Thanks for replying. I have an Access 2000 database called webugnet and
I am attempting to Export it. I have installed MyODBC and configured a
mysql connection to the sql server on DSVR.
So, in the table window right click on the database and select "Export"
This brings up an "Export ta
Chris Wilkinson wrote:
>
> I am attempting to upload an Access db to a remote mysql server - at
> dsvr in the UK.
>
> I get connected (I think) but receive the following error message:
> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
>
> Can you point me in the right di
I am attempting to upload an Access db to a remote mysql server - at
dsvr in the UK.
I get connected (I think) but receive the following error message:
Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
Can you point me in the right direction for this or offer some help.
T
This join works perfectly in Access but if I use the same query in MySQL it
shits it's pants.
SELECT tbl_medien.titel, tbl_medien.ausgabe, tbl_medien.URL,
tbl_medien.medientypID, tbl_autor.name, tbl_autor.vorname
FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN
tbl_zuordnung_autoren_medien ON
tbl
40 matches
Mail list logo
