Access to MySQL server not displaying tables (1 Viewer)

S

Slim Shamble

Registered User.

Local time

Today, 21:25

Joined

Jun 3, 2016

Messages

29

• Sep 10, 2017

• #1

Hi Guys,

i linked my access table to MySQL server ODBC 5.7. AFTER i did that, the ODBC is not displaying any tables in the column

Any idea on how to resolve this please?

i tried Compact and repair, still not good

 

Last edited: Sep 10, 2017

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Today, 15:25

Joined

Feb 28, 2001

Messages

27,146

• Sep 10, 2017

• #2

The question is whether the MySQL server is set to require passwords and you didn't give it one? Your question doesn't address this.

 

S

Slim Shamble

Registered User.

Local time

Today, 21:25

Joined

Jun 3, 2016

Messages

29

• Sep 10, 2017

• #3

Yes, i assigned a password to it and the connection was successful.

secondly,

i later remove password from the server yet my table still not dispaying in the column

 

Last edited: Sep 11, 2017