Windows 7 users unable to access backend MySQL

[jetatu]

Hi everyone,

I have a =n odd scenario here:

Been running a MS Access 2010 from XP for two years with MySQl 5.5 backend server. I have 25 end users connect through ODBC.

All was fine until recently. I rolled out a new version of MS Access 2010 that had only 2 text boxes added to one form. The database version number went form 1.1 to 1.2.

To my knowledge, nothing else changed. The end users connected to 1.1 are able to access the backend server with no problem. New users added and anyone trying to access database 1.2 through ODBC get error using password, or when they try to connect not using password.

I was recenlty upgraded to Windows 7 and have admin access to the backend server. I am the only one who can access the 1.2 database, however I have made no change to any end user accounts in MySQl backend.

Any help is greatly appreciated!

jetatu:banghead:

 

[GinaWhipp]

Three things come to mind...

1. Refresh the connection, if that doesn't work...
2. Refresh the connection via Control Panel, not thru Access
3. Did you add a BIT field? Did you Default it False (or True depending on what you want.)

 

[jetatu]

Three things come to mind...

1. Refresh the connection, if that doesn't work...
2. Refresh the connection via Control Panel, not thru Access
3. Did you add a BIT field? Did you Default it False (or True depending on what you want.)
__________________
Gina Whipp
Microsoft MVP (Access)

Hi Gina,

Thank you so much for responding. The database is regulalrly refreshed through the External Data > Linked Table Manager.

2) Not sure what you mean by Refresh via Control Panel. Can you elaborate how that is done?
3) Not sure about adding BIT field and setting True or False.

This database has been operational for 2 years. As administrator, I am having no problem connecting, but since changing the database name from 1.XX to 1.yy and sending to my end users via zipped file in email (as I have been doing for some time) for some reason the end users no longer able to connect to the backend.

If you can elaborate on the 2 suggestions you offered so I can see if those are the issue, I would greatly appreciate it.

Thank you and have an awesome day

 

[GinaWhipp]

Refreshing it that way is sometimes not enough.

2. If you go to Control Panel and *refresh* the connection via Data Sources (OBDC). This has been known to work better then doing it via Access.
3. I was asking ... Did you add a Yes/No field to any of the table(s). Until a Default is set it will not allow data entry, so while people can view the data they cannot change or add anything.

You say the End Users cannot connect. Are they getting a message? If so, what is it? What happens when they try to connect?

Another thought... you changed the name on the Front end or the Back end? If the backend then I'm going to suggest breaking those links (removing the links for the Front end) and recreating them.

 

[jetatu]

Hi again Gina,

I had responded earlier today to your last post. I don't see my response, but will wait to see if it shows up before rewriting everything.

Also, here is the error message the end-users get:

Connection failed [HY000] [MySQL][ODBC5.2(w) Driver]Access denied fofr user 'ipaddress' (using password: YES)

and when using password NO

Thank you again

 

[GinaWhipp]

Hmm, before I respond I would like to see the answers to the other questions which have yet to show up! I'll guess you'll be typing... sorry.