Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access reading MySQL lock up

Status
Not open for further replies.
jmpurser

jmpurser

Programmer
Nov 19, 2001
12
US
I've got MySQL running on a Windows 2000 box. I've dumped some data to MySQL for a project and wanted to use Access to report on this data. I connected to MySQL via the odbc driver and linked the tables with no problems. But when I try and query on the tables or even view them everything slows down and both Access and MySQL lock up. I have to kill them both and reboot! I figure I missed an installation option somewhere and they're trying to use the same port or something.

Can anyone help with this?

Thanks,

John urser
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
277
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
243
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
176
spamjim
spamjim
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
300
dylim
dylim
PeDa
  • Locked
  • Question
Opening MySQL table from Microsoft Access
Replies
1
Views
103
PeDa
PeDa

Part and Inventory Search

Sponsor

Back
Top