By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,302 Members | 3,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,302 IT Pros & Developers. It's quick & easy.

What's the best (better) way to connect to a MySQL database via ODBC in Access?

P: 1
Hi all,

Although I've got quite a lot of experience with php and (M/My)SQL, I
only used both within an online php script. These last few months I
bought an option with my webhost to access the remote database via ODBC
via my homePC. I use MS Access (linked tables) on my PC, just because
it's very easy to make new reports / forms / querys / ... And, in
principle, it should work, shouldn't it? And it does... most of the
time, however there very, very often errors. Most of the time I can
solve these just by closing and re-openinging Access, but there have to
be better solutions for this.


Following error messages are extremely frequent:


- Most of the time, Access is complaining 'ODBC Connection Fault
(Connection Lost)'. Ok, so maybe, there's a little network problem
(stop complaining and try again ;) ). The annoying thing is that Access
also asks to re-enter the password, although I did mark (when the
initial connection was made) to remember the password. Funny thing, if
I just enter the password myself in the little popup window, everything
works perfectly, but why can't Access do that for itself?


- In some cases this method doesn't work and I just have to close and
re-open Access to get it working again. But why? What does opening and
closing Access change ? Is it resetting the connection? But why can't
Access do that without having to close itself?


- Also very often and very annyoing : I justed added a record in
Access and just after that I try to change the newly added record. But
Access refuses because 'data has been change by another user'. What
other user? I'm the only one using this DB. If I wait 5 minutes, I can
change whatever i want.


I guess these problems are pretty common for everyone working with ODBC
/ MySQL (I guess). But, there has to be stable, better solutions?
Should I not use Access (if not: what should I use), or can you connect
to a MySQL database in another (better) way.


I'm really hoping for answers, it's driving me nuts! :)


Thanks!
Sep 30 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi man,

I've the same pb with MySQL! I've nto worked enought but some of these things can be set using the ODBC connection settings and other properties in Access about ODBC connections

See

in Access VB

ODBCConnectStr
ODBCTimeout
ConnectionTimeout Property

For the moment it's all! I'll work also on this field!

Nice chance!

:)
Sep 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.