AM
> To: Jerry Schwartz
> Subject: RE: Ms access front end and mysql back end
>
> My database is in MySQL on the server and I have 5 machines
> connected to the
>
> server. The front end is MS access. This is where I have
> forms, queries,
> reports and macros. The front e
TED]
> Sent: Friday, January 19, 2007 4:44 AM
> To: Jerry Schwartz
> Subject: RE: Ms access front end and mysql back end
>
>
> My database is in MySQL on the server and I have 5 machines
> connected to the
> server. The front end is MS access. This is where I have
> forms, querie
You didn't give us much information. If you open the Data Sources
configuration, what happens when you test the connection?
Did this ever work?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Mes
Do the following in 'mysql' client:
select * from mysql.user\G
Does you user have all necessary privileges maked as Y ?
You may need to update your user's host field to '%'
to allow you to connect from any host other than localhost.
Don't forget run 'flush privileges;' afterwards.
Give it a try
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
C K wrote:
> Thanks for your sugesstions. I tried to search this issue on
> microsoft's website. and found that this problem is related with
> timestamp fields. I have tried to connect from access 2k and 2003 to
> mysql database. It works well for all the things. but gives above
> error only when
On 7/4/06, C K <[EMAIL PROTECTED]> wrote:
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives above
error only when control jumps to subf
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 recordsource. Can any one plea
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 with the con
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
execu
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
this probl
I have found my problem...the problem was with access
asking for unique identifiers in each table. I might have had the
same identifier for two tables. Now it seems to be working.
Thanks for all who helped
STeve
- Original Message -
From: "Steve Siesel" <[EMAIL PROTECTED]>
To: <[EMAIL
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
e -
> From: <[EMAIL PROTECTED]>
> To: "Steve Siesel" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, March 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
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 <<
On 3/4/04, 1:57:15 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regardi
Μιχαλίδης Κώστας 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 Access)
Regards to all
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
simply
be
> high praise for MyODBC, but my Access app has no difficulty at all
talking
> to the database.
>
> Arthur
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Arthur Fuller" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 28, 2002 1:57
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
: [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Roger Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday,
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 columns, just as in MS-SQL
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when eve
S-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 PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MS Access and mySQL
I have been there
PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MS Access and mySQL
I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be
I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathan,
If you are going to be completely converting the Access db to MySQL,
and just using Access as the frontend, you will need to download
MyODBC:
http://www.mysql.com/downloads/api-myodbc.html
You can download either the stable or developme
mailto:[EMAIL PROTECTED]]
> Sent: 18 June 2002 00:45
> To: Alexander Shaw
> Cc: [EMAIL PROTECTED]
> Subject: Re: MS Access forms and auto numbers
>
>
> Try using this in a code builder window:
> DoCmd.RunCommand acCmdSaveRecord
>
> Make sure that your table has a Time
Hi !!
uhh, this sounds really stupid to be honest :-)
My first thought is, If they are so deep in MS junk
why should they port to PHP/MySQL in the first place ??
I think it's definitely easier to give then a quick-course
in PHP than writing these kind of workarounds...
You could maybe write ano
e S
Cc: '[EMAIL PROTECTED]'
Sent: 5/31/2002 3:20 PM
Subject: Re: MS Access Queries
Hi.
On Fri, May 31, 2002 at 01:26:34PM -0400, [EMAIL PROTECTED] wrote:
> Hey guys,
> i'm still doing this web ODBC thing, and i was wondering since, all
the
> wqueries i'm going to use ar
Hi.
On Fri, May 31, 2002 at 01:26:34PM -0400, [EMAIL PROTECTED] wrote:
> Hey guys,
> i'm still doing this web ODBC thing, and i was wondering since, all the
> wqueries i'm going to use are in a database, is there a way (using
> php/mysql/odbc) to access and call on those queries without typing t
Hi,
This error make reference to a variable which is not correctly defined.I
suppose that you have in routine which make "import" a variable like :
Dim myvar as lon
insted
Dim myvar as long
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e
No help, just a "me too". If you respond with something helpful to this,
please either post it to the list or copy me on it because I'm fed up with
MS Access / myODBC / MySQL combo as well (not necessarily the individual
components, just the combination).
--
Have a look at MyAccess available from http://www.accessmysql.com it has
worked for me
Alex
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 09:14
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion
We have a Unix server which in addition to
Steve, Doug & Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Billy Reed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re:
Instead of TOP 5 DistKm FROM SCLeague
you can probably use
DistKm SORTED BY DistKm DESCENDING LIMIT 5
The rest about temp files is probably best to read
Goran Bobic's mail.
Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
> WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
>
> Can anyone suggest how this is done in MySQL. It doesnt see
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
Hi
> -Original Message-
> From: Matt Sellers [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 26, 2001 7:37 AM
> To: [EMAIL PROTECTED]
> Subject: MS Access Front end with MySQL Back-end
>
>
> Hi there,
>
> I am new to MySQL, but not to databases. I have several MS Access
> databas
I used MyAccess2000, it connects through ODBC inside Access. You can create
tables, import Access to MySQL or MySQL to Access and it will display table
SQL and indexes, its $30usd http://www.accessmysql.com/
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Mond
The Jonathan Tutorial
Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com
2. Download and install MyODBC
3. Set up a new ODBC connection for the new mySQL server
4. Open up the database in access
5. Go to the File menu and choose to Export (Tables?)
6. At the bottom of
try this:
http://www.mysql.com/downloads/contrib.html#SEC653
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I
Look in the contrib section of the website. There are scripts for
exporting Access databases to mysql.
Curtis
On Mon, 1 Oct 2001 [EMAIL PROTECTED] wrote:
> On Mon, 1 Oct 2001, Andreas Schmidt wrote:
>
> > Hi List
> >
> > I want to migrate from a NT-Server to a Linux Server. Therefore I'm
> >
ata > Link Tables to get access to
the data residing on the MySQL server.
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 01 October, 2001 10:17
To: Andreas Schmidt
Cc: [EMAIL PROTECTED]
Subject: Re: MS-Access
On Mon,
On Mon, 1 Oct 2001, Andreas Schmidt wrote:
> Hi List
>
> I want to migrate from a NT-Server to a Linux Server. Therefore I'm
> looking
> for a solution to run my existing MS-Access-Databases under MySQL. Is
> there a chance to point from a MySQL-DB to a MS-Access-DB in order that
> my data can st
On Wed, Aug 29, 2001 at 10:01:23PM -0600, s. keeling wrote:
> On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote:
> >
> > Some people say translate INNER JOINS from Access to WHERE clauses, some say
>
> Personally, I'd say drop Access and all references to it, and begin
> redesign us
On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote:
>
> Some people say translate INNER JOINS from Access to WHERE clauses, some say
Personally, I'd say drop Access and all references to it, and begin
redesign using a sensible alternative which doesn't encourage the
production of suc
Even on a small scale. The measure I use is, if there are going to be more than 3
concurrent users on the database at anyone time and the database does more than keep
recipes, its time to move to SQL. I've had nasty times with MS Access when 4 or 5
people hit a database at the same time. It ten
MySQL doesn't support certain features such as foreign keys and sub-selects
but may do so in the future. This is documented in the mysql manual.
MS Access is not very suitable for networks especially on a large scale.
- Original Message -
From: "Wavyx" <[EMAIL PROTECTED]>
To: <[EMAIL PR
I get two info boxes.
The first says "ODBC-call failed"
The second says "[TCX][MyODBC]Access denied for
user: '@dhcp85.lannet.com.au' to database 'Treasury' (#1044)"
In the TDX mysql Driver default configuration dialog box from Control
Panel->ODBC Data Source (32bit) the user name is set as LAN
You say it's not sending the user name. What connect string are you using?
Does it include the user name? Can you post the exact connect string you are
using when you connect to the database?
As I have it set up on my windows side of things: the DSN in the ODBC setup
has no username or pass
At 8:37 AM +0700 5/4/01, Taing Nguon wrote:
>Dear Sir/Madam
>
> I just know that there is a tool to convert database from MS Access
>to Mysql, But I do not know the URL of this tool. Could you tell me this
>URL? Thanks
Check this page and look in the "converters" section. Might be what you
w
At 10:34 12/02/2001 -0700, John Halladay wrote:
Hi!
Generally your problem happened when you did the linking of the
MySQL table, Access didn't find a primary key column and you
didn't select any.
If the above is right, add a primary key column and link the
table again.
Regards,
Miguel
>I've scan
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
> If I am using MS Access and link
Take your pic - personally, I usually use a tinyint, and assign a 0 or 1
- I suspect the options you describe would work just as well.
regards,
P
On Tue, 6 Feb
2001, John Halladay wrote:
> If I am using MS Access and linking to tables in MySQL through MyODBC, what
> is the equivalent format of
63 matches
Mail list logo
