lookup database name on MYsql backend

[russ0670]

I have a MSACCESS frontend that can link to two possible backends both are hosted on the same MYSQL server but differend DB names. One containing live data and one with testing data.

I want to display which database is connected on the login form to ensure that someone using the testing system does not accidentially use live data.

when originally using an access backend i used the below code.

Dim dbpath As String
dbpath = CurrentDb.TableDefs("users").Connect

I have now migrated the database to a online hosted MYSQL backend to enable multiple user access from multiple of-site locations and obviously this above code is not working in the MSACCESS frontend.

does anyone know a similar code to display the name of the mysql database the system is linked to (via ODBC and linked tables).

thanks.

[Stingaway]

So you access the test data and the live data through the same front end? I would suggest a separate front end for each (just a copy of the other with a different name...)

[russ0670]

Thanks for the reply. Sorry should have specified more.

We use the testing data to test changes to the database frontend before impelenting it.

We do use a second copy of the live Front End and change the linked tables to point to the backend testing data.

The problem is that the people who do the coding also use the live database on a day to day basis and when they are open they are identical. So i would like to use the path to show on the switchboard which DB is is linked to and stop the wrong copy being used.

The code above worked perfectly when the BE was MSACCESS but now its on a MySQL server i need to change this accordingly but dont have a clue how to query what the linked data path or what the connected MySQL DB name is.

[Stingaway]

How about just a nice little message on the live copy of the front end form saying "HEY YOU ARE IN LIVE DATA" and a message on the other copy (the test data form) saying "HEY YOU ARE IN TEST DATA")...

or something static, since you have two copies anyway and it doesn't really matter what the link is as it is always going to be the same for the front end you are using?

Just a thought... (random one at that..)