473,849 Members | 1,797 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access and MYSQL

Hi there

I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto MySQL, as we get the
odd #DELETED# (that old chestnut) so that it is more stable, I have
installed mysql and myodbc and configured it in data sources (ODBC) and
it works fine (done the TEST).
But when I try to export a table from the mdb

I get the following prompt
"[MySQL][ODBC 3.51 Driver] Could not determine the driver name"
In advanced part of the ODBC config it says
DRIVER={MySQL ODBC 3.51 Driver} (I don't know if this is a description
or a path)

I am using a dev serv, not sure if I need to configure it or if it is
as simple as to change the driver name to the DLL or if is is
descriptive

I'm confused

May 31 '06 #1
4 2918

"Vanessa" <va**********@y ahoo.com> wrote in message
news:11******** *************@c 74g2000cwc.goog legroups.com...
Hi there

I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto MySQL, as we get the
odd #DELETED# (that old chestnut) so that it is more stable, ...
You shouldn't be seeing #DELETED# errors.
It makes me concerned that you may have deeper problems that won't be solved
by merely porting to MySQL.

You may want to explain this a bit more.

Hopefully, you are using Access version 2000 or higher. Access 97 at this
point is positively prehistoric. With prehistoricly oversized bugs, it is
beyond redemption.
I have
installed mysql and myodbc and configured it in data sources (ODBC) and
it works fine (done the TEST).
That's good and useful, but it does little more than prove you can
communicate with the MySQL server. A good starting point, however.
But when I try to export a table from the mdb
I get the following prompt
"[MySQL][ODBC 3.51 Driver] Could not determine the driver name"
In advanced part of the ODBC config it says
DRIVER={MySQL ODBC 3.51 Driver} (I don't know if this is a description
or a path)
It sounds like you are trying to use the Access table export utility to port
your Access tables to MySQL. I'm sure you can muddle through that but I
don't recommend it.

If you have Access expertise but are MySQL green, then I would suggest -

1) That you construct your tables in MySQL to match your Access tables.
Best to use a GUI utility. I use MySQL Control Center, but there are many
others that will work. Use fields that are direct analogues of field types
available in Access.

2) Create linked tables (in Access) to your new (empty!) MySQL tables.
Create these linked tables right alongside your Access data tables.

3) Use the Access query builder to create "append" queries that will
populate your empty MySQL (linked) tables with data from your Access tables.

Errors you get when you do these data appends will be indictive that your
MySQL table structure does not match your Access table structure precisely.
This method gives you the opportunity to work these differences out. The
data appends should work smoothly and error free.

Once this is accomplished, you can work with the linked tables just as you
would any other Access tables, even though the data actually resides inside
MySQL.
Or
You can put Access asside and communicate.
DAO or ADO <-> MySQL ODBC <-> MySQL

Don't erase Access though! It does come in handy.
I am using a dev serv, not sure if I need to configure it or if it is
as simple as to change the driver name to the DLL or if is is
descriptive
"using a dev serv" ???
I don't know what you are talking about here.
I'm confused


That will pass ;-)
Thomas Bartkus
May 31 '06 #2
Had similar problem, even thouth you may have an auto incremant field in
mysql, still use a dmax in access to incremant it and it goes into mysql
just fine and the #deleted# goes away. To gain access to a remote mysql
database, link the tables in access (need access 2000) and use ado if needed
to manipulate tables. No different than ms access 2000 as front end for sql
server. If you know access you know what I'm referring to. By the way
access 97 is still as good as a b-52 bomber, which is slated to still be
around til the year 2043. In fact, I have said all along, that microsoft
has too many employees now and are going way way too fast. Modern plastic
is good, but grainite is still better for a counter top.
They are wipping out too much too fast. Leave something that works well
alone. I truley believe that some of these young, wet behind the ears,
fresh out of college programmers are the type that would jump off of a cliff
if they heard it was the end thing to do. For now, I will keep using access
97 and 2000 for ado, and I will not get anywhere near the edge of a cliff.
"Vanessa" <va**********@y ahoo.com> wrote in message
news:11******** *************@c 74g2000cwc.goog legroups.com...
Hi there

I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto MySQL, as we get the
odd #DELETED# (that old chestnut) so that it is more stable, I have
installed mysql and myodbc and configured it in data sources (ODBC) and
it works fine (done the TEST).
But when I try to export a table from the mdb

I get the following prompt
"[MySQL][ODBC 3.51 Driver] Could not determine the driver name"
In advanced part of the ODBC config it says
DRIVER={MySQL ODBC 3.51 Driver} (I don't know if this is a description
or a path)

I am using a dev serv, not sure if I need to configure it or if it is
as simple as to change the driver name to the DLL or if is is
descriptive

I'm confused

Jun 4 '06 #3
Had similar problem, even thouth you may have an auto incremant field in
mysql, still use a dmax in access to incremant it and it goes into mysql
just fine and the #deleted# goes away. To gain access to a remote mysql
database, link the tables in access (need access 2000) and use ado if needed
to manipulate tables. No different than ms access 2000 as front end for sql
server. If you know access you know what I'm referring to. By the way
access 97 is still as good as a b-52 bomber, which is slated to still be
around til the year 2043. In fact, I have said all along, that microsoft
has too many employees now and are going way way too fast. Modern plastic
is good, but grainite is still better for a counter top.
They are wipping out too much too fast. Leave something that works well
alone. I truley believe that some of these young, wet behind the ears,
fresh out of college programmers are the type that would jump off of a cliff
if they heard it was the end thing to do. For now, I will keep using access
97 and 2000 for ado, and I will not get anywhere near the edge of a cliff.

"Thomas Bartkus" <th***********@ comcast.net> wrote in message
news:LI******** ************@te lcove.net...

"Vanessa" <va**********@y ahoo.com> wrote in message
news:11******** *************@c 74g2000cwc.goog legroups.com...
Hi there

I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto MySQL, as we get the
odd #DELETED# (that old chestnut) so that it is more stable, ...


You shouldn't be seeing #DELETED# errors.
It makes me concerned that you may have deeper problems that won't be
solved
by merely porting to MySQL.

You may want to explain this a bit more.

Hopefully, you are using Access version 2000 or higher. Access 97 at this
point is positively prehistoric. With prehistoricly oversized bugs, it is
beyond redemption.
I have
installed mysql and myodbc and configured it in data sources (ODBC) and
it works fine (done the TEST).


That's good and useful, but it does little more than prove you can
communicate with the MySQL server. A good starting point, however.
But when I try to export a table from the mdb
I get the following prompt
"[MySQL][ODBC 3.51 Driver] Could not determine the driver name"
In advanced part of the ODBC config it says
DRIVER={MySQL ODBC 3.51 Driver} (I don't know if this is a description
or a path)


It sounds like you are trying to use the Access table export utility to
port
your Access tables to MySQL. I'm sure you can muddle through that but I
don't recommend it.

If you have Access expertise but are MySQL green, then I would suggest -

1) That you construct your tables in MySQL to match your Access tables.
Best to use a GUI utility. I use MySQL Control Center, but there are many
others that will work. Use fields that are direct analogues of field
types
available in Access.

2) Create linked tables (in Access) to your new (empty!) MySQL tables.
Create these linked tables right alongside your Access data tables.

3) Use the Access query builder to create "append" queries that will
populate your empty MySQL (linked) tables with data from your Access
tables.

Errors you get when you do these data appends will be indictive that your
MySQL table structure does not match your Access table structure
precisely.
This method gives you the opportunity to work these differences out. The
data appends should work smoothly and error free.

Once this is accomplished, you can work with the linked tables just as you
would any other Access tables, even though the data actually resides
inside
MySQL.
Or
You can put Access asside and communicate.
DAO or ADO <-> MySQL ODBC <-> MySQL

Don't erase Access though! It does come in handy.
I am using a dev serv, not sure if I need to configure it or if it is
as simple as to change the driver name to the DLL or if is is
descriptive


"using a dev serv" ???
I don't know what you are talking about here.
I'm confused


That will pass ;-)
Thomas Bartkus

Jun 4 '06 #4
"jim whitaker" <kp*****@sbcglo bal.net> wrote in message
news:j%******** **********@news svr11.news.prod igy.com...

By the way
access 97 is still as good as a b-52 bomber, which is slated to still be
around til the year 2043. In fact, I have said all along, that microsoft
has too many employees now and are going way way too fast. Modern plastic
is good, but grainite is still better for a counter top.
Sorry to disagree, but Office 97 was nowhere near as robust as a B-52.
Office 2000 was a major (and essential!) bug fix to 97. And even the
venerable B-52 has no useful place in aviation other than as an artifact ;-)
They are wipping out too much too fast. Leave something that works well
alone. I truley believe that some of these young, wet behind the ears,
fresh out of college programmers are the type that would jump off of a cliff if they heard it was the end thing to do. For now, I will keep using access 97 and 2000 for ado, and I will not get anywhere near the edge of a cliff.
You are in no danger whatsover of falling off the cliff edge.
From Access 97, the cliff edge is way, *way* over the horizon ;-)
Thomas Bartkus

"Thomas Bartkus" <th***********@ comcast.net> wrote in message
news:LI******** ************@te lcove.net...

"Vanessa" <va**********@y ahoo.com> wrote in message
news:11******** *************@c 74g2000cwc.goog legroups.com...
Hi there

I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto MySQL, as we get the
odd #DELETED# (that old chestnut) so that it is more stable, ...


You shouldn't be seeing #DELETED# errors.
It makes me concerned that you may have deeper problems that won't be
solved
by merely porting to MySQL.

You may want to explain this a bit more.

Hopefully, you are using Access version 2000 or higher. Access 97 at this point is positively prehistoric. With prehistoricly oversized bugs, it is beyond redemption.
I have
installed mysql and myodbc and configured it in data sources (ODBC) and
it works fine (done the TEST).


That's good and useful, but it does little more than prove you can
communicate with the MySQL server. A good starting point, however.
But when I try to export a table from the mdb
I get the following prompt
"[MySQL][ODBC 3.51 Driver] Could not determine the driver name"
In advanced part of the ODBC config it says
DRIVER={MySQL ODBC 3.51 Driver} (I don't know if this is a description
or a path)


It sounds like you are trying to use the Access table export utility to
port
your Access tables to MySQL. I'm sure you can muddle through that but I
don't recommend it.

If you have Access expertise but are MySQL green, then I would suggest -

1) That you construct your tables in MySQL to match your Access tables.
Best to use a GUI utility. I use MySQL Control Center, but there are many others that will work. Use fields that are direct analogues of field
types
available in Access.

2) Create linked tables (in Access) to your new (empty!) MySQL tables.
Create these linked tables right alongside your Access data tables.

3) Use the Access query builder to create "append" queries that will
populate your empty MySQL (linked) tables with data from your Access
tables.

Errors you get when you do these data appends will be indictive that your MySQL table structure does not match your Access table structure
precisely.
This method gives you the opportunity to work these differences out. The
data appends should work smoothly and error free.

Once this is accomplished, you can work with the linked tables just as you would any other Access tables, even though the data actually resides
inside
MySQL.
Or
You can put Access asside and communicate.
DAO or ADO <-> MySQL ODBC <-> MySQL

Don't erase Access though! It does come in handy.
I am using a dev serv, not sure if I need to configure it or if it is
as simple as to change the driver name to the DLL or if is is
descriptive


"using a dev serv" ???
I don't know what you are talking about here.
I'm confused


That will pass ;-)
Thomas Bartkus


Jun 5 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
5575
by: John | last post by:
Hello. I am currently working through a book on Dreamweaver and using PHP. I am having a little trouble with setting up the database though. I have php 4.2.3 and MySQL 4.0.20a. I am running locally with Apache 1.3.27 on Windows XP Pro. I seem to have finally got MySQL running after a lot of difficulty. In the book it says to type source C:\mysql\newland_tours.sql at the mysql> prompt, to generate the newland_tours database in my...
11
4207
by: Mike MacSween | last post by:
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared PHP/MySql site. From one command button (or similar) in the Access application.
0
3400
by: Ryan Schefke | last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit ..I just sent this out to the win32 distribution list but no one has replied.can someone on this list please help? The issue should be trivial for experienced MySQL users, I'm just a novice, thanks!
0
2205
by: Maciej Wiznerowicz | last post by:
Dear Sirs, I can not start MySQL server. More specifically, MySQL was running fine all the time since installation. It stopped working after I used FmPro Migrator to convert some File Maker databases to MySQL It looks like mysqld has no access permissions to InnoDB and I do not know how to fix it.
0
4594
by: Morten Gulbrandsen | last post by:
Hi programmers, Good morning ;-) I think something is wrong, Running windows I believe first I have to set some password, Which creates some user, Then I can grant the required privileges, for some databases. However granting privileges after setting password seems to reset some Other access,
17
2916
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
2
4938
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection to mysql. But now, i want MS Access to operate offline (e.g. on notebook in the
15
4660
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
5
2926
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...
0
11005
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10665
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10349
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7894
isladogs
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...
0
7070
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();...
0
5735
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5921
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4139
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3177
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.