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!