MYSQL Connection string

[Dave_cha]

Hi folks,

I've recently begun to move all my db tables to MySql and have created ODBC linked tables to access the data.

I have a number of tables however which contain confidential info such as passwords etc. As things stand, I can put an input mask on the table link in access but it's still possible for someone to view the data using the odbc connection.

I know I need to setup a connection to MYSQL from the form's vba script instead of using linked tables however I have no experience in doing this. I don't know it I should be using DAO or ADODB (not that I've used either before) so I was hoping that someone out there has gone through this already and may have some sample scripts that would help me get started.

Any help would be appreciated.

Thanks,

Dave

 

[sfreeman@co.mer]

MySQL functions

MySQL has two functions to help; Password and md5.

md3 creates a 128-bit hash of a password string. [recommended method]

Password calculates a password for your password string. [not recommended]

HTH

 

[Dave_cha]

Thanks for that Sam....will prove v. handy.

Also, if there is anyone with sample 'Access to MySql' connection scripts could they send them this way? I reckon I need to start using connection strings going forward instead of linked tables to provide a more secure environment. I just need to see a few scripts to point me in the right direction.

Thanks, Dave

 

[Dave_cha]

Just tried the MD5 option and received the attached MS VB error saying that MD5 is an undefined function....any ideas?

Thanks,

Dave

 

[sfreeman@co.mer]

Sorry, Dave, but I have now uninstalled MySQL in favor of the new MS SQL Server Express (new free program from MS).

Wish I could be more help.