Hi,
I currently have a mySQL database running on a database server and am
creating a front end for the forms e.t.c
Im currently connecting the two via ODBC, however i have noticed its a
bit slower than I would of wanted.
Can anyone suggest a faster method of retrieving the data?
Being portable isnt a big issue, I just used ODBC as I thought it was
the only way of accessing a mySQL database from Access.
If this is the best way, can anyone point me in the right direction of
some optimization tips i can use, either on the Access front-end or the
ODBC driver itself.
Thanks 4 1384
Hi Olly,
The other option that you have if you want to stay with an access front
end is to create an access project. This should not be emarked opon
lightly because all your queries/sprocs will need rewriting in sql
server. Maybe you should look at your indexing etc before going down
that road.
Good luck
Nick ol*************@gmail.com wrote:
Hi,
I currently have a mySQL database running on a database server and am
creating a front end for the forms e.t.c
Im currently connecting the two via ODBC, however i have noticed its a
bit slower than I would of wanted.
Can anyone suggest a faster method of retrieving the data?
Being portable isnt a big issue, I just used ODBC as I thought it was
the only way of accessing a mySQL database from Access.
If this is the best way, can anyone point me in the right direction of
some optimization tips i can use, either on the Access front-end or the
ODBC driver itself.
Thanks
Which is a bit silly as he is using mySQL and ADPs are deprecated.
--
Slainte
Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
Small Business Solutions Provider
"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi Olly,
The other option that you have if you want to stay with an access front
end is to create an access project. This should not be emarked opon
lightly because all your queries/sprocs will need rewriting in sql
server. Maybe you should look at your indexing etc before going down
that road.
Good luck
Nick
ol*************@gmail.com wrote:
>Hi,
I currently have a mySQL database running on a database server and am creating a front end for the forms e.t.c
Im currently connecting the two via ODBC, however i have noticed its a bit slower than I would of wanted. Can anyone suggest a faster method of retrieving the data? Being portable isnt a big issue, I just used ODBC as I thought it was the only way of accessing a mySQL database from Access.
If this is the best way, can anyone point me in the right direction of some optimization tips i can use, either on the Access front-end or the ODBC driver itself.
Thanks
Sorry did not realise that he was using MySQL, thought that he was
using SQL Server.
Oops,
Nick
Craig Alexander Morrison wrote:
Which is a bit silly as he is using mySQL and ADPs are deprecated.
--
Slainte
Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
Small Business Solutions Provider
"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi Olly,
The other option that you have if you want to stay with an access front
end is to create an access project. This should not be emarked opon
lightly because all your queries/sprocs will need rewriting in sql
server. Maybe you should look at your indexing etc before going down
that road.
Good luck
Nick ol*************@gmail.com wrote:
Hi,
I currently have a mySQL database running on a database server and am
creating a front end for the forms e.t.c
Im currently connecting the two via ODBC, however i have noticed its a
bit slower than I would of wanted.
Can anyone suggest a faster method of retrieving the data?
Being portable isnt a big issue, I just used ODBC as I thought it was
the only way of accessing a mySQL database from Access.
If this is the best way, can anyone point me in the right direction of
some optimization tips i can use, either on the Access front-end or the
ODBC driver itself.
Thanks
Thanks for your suggestions, ive had a play around with the ODBC driver
and changed the navigation through the forms and its quicker.
Thanks
Nick 'The database Guy' wrote:
Sorry did not realise that he was using MySQL, thought that he was
using SQL Server.
Oops,
Nick
Craig Alexander Morrison wrote:
Which is a bit silly as he is using mySQL and ADPs are deprecated.
--
Slainte
Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
Small Business Solutions Provider
"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi Olly,
>
The other option that you have if you want to stay with an access front
end is to create an access project. This should not be emarked opon
lightly because all your queries/sprocs will need rewriting in sql
server. Maybe you should look at your indexing etc before going down
that road.
>
Good luck
>
Nick
> ol*************@gmail.com wrote:
>Hi,
>>
>I currently have a mySQL database running on a database server and am
>creating a front end for the forms e.t.c
>>
>Im currently connecting the two via ODBC, however i have noticed its a
>bit slower than I would of wanted.
>Can anyone suggest a faster method of retrieving the data?
>Being portable isnt a big issue, I just used ODBC as I thought it was
>the only way of accessing a mySQL database from Access.
>>
>If this is the best way, can anyone point me in the right direction of
>some optimization tips i can use, either on the Access front-end or the
>ODBC driver itself.
>>
>Thanks
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wescotte |
last post by:
Here is a small sample program I wrote in PHP (running off Apache
1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data
base is using DB2 V5R3M0. The client is WinXP machine using...
|
by: godwin |
last post by:
Hi all,
I wanna thank Martin for helping out with my ignorance concerning
execution of stored procedure with python. Now i have decided to write
a web app that googles into my companies...
|
by: Florian |
last post by:
I need to set multiple values for some SQL statements, for example
SET NUMERIC_ROUNDABORT OFF
GO
SET
ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIF
IER,ANSI_NULLS...
|
by: Steve Foster |
last post by:
I have tried many variations (after reviewing other posts) and can not
resolve the following issue:
RUNNING SQL MAINTENANCE
----------------------------
SET ARITHABORT ON
SET...
|
by: peteh |
last post by:
Hello All;
We are soon implementing Websphere II to "federate" multiple Oracle DBs
to our data warehouse hub (DB2 PE v8.1.5 on AIX). I wonder if IBMers or
experienced II/Oracle users could comment...
|
by: Bibi |
last post by:
Hi,
i have a SqlWindows Program which made a connection to a MS Access
Database about ODBC. I can get all datas with a select about one table. But when
i made a select with more than one table,...
|
by: paulwilliamsonremove |
last post by:
Hi,
I made the move to Access 2003 from Access 97. So far, so great.
I am reading a discussion in one of my A2003 developer books. The
other has a nice explanation of both but mentions that...
|
by: Eric Hirst |
last post by:
I have a Visual Studio Solution .sln which contains multiple projects,
including an ODBC driver .dll and a client .exe.
The client .exe is a simple MFC query tool. Nothing I can find in the...
|
by: Simon Windsor |
last post by:
Hi
I am used to using Oracle (15 years) and MySQL(5 years), but I am planning
to move an existing application from MySQL to Postgres. The reasons are very
simple,
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |