Any options other than ODBC?

[ollyculverhouse]

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

[Nick 'The database Guy']

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

[Craig Alexander Morrison]

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

[Nick 'The database Guy']

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

[ollyculverhouse]

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
>