How distinguish Test/Prod copies of DB for user?

[Tom_F]

To comp.databases.ms-access --

I'm running Microsoft Access 2003 on Windows XP Professional. I have
a "Test" version and a "Production" version of our database, with the
same dataset name, but located in different paths (folders). I'd like
to find a way to always display on the screen, when the database is in
use, whether it is the "Test" version or the "Production" version.
Any ideas? Note that I do not want to do anything which would make
the 2 database versions different from each other (including giving
them different dataset names), since I frequently copy them, back and
forth, between Test and Production.

I'm thinking along the lines of an "Autoexec" macro, that would run
some VBA code, to check what the path is, when the database starts
up ... but I'm not sure how to display this information to the user,
so that it would be clearly visible at all times. Thanks for any
help! Best,

--Tom
frethoa AT aol DOT com

[OldPro]

On Oct 8, 4:08 pm, Tom_F <[e-mail]:

To comp.databases.ms-access --

I'm running Microsoft Access 2003 on Windows XP Professional. I have
a "Test" version and a "Production" version of our database, with the
same dataset name, but located in different paths (folders). I'd like
to find a way to always display on the screen, when the database is in
use, whether it is the "Test" version or the "Production" version.
Any ideas? Note that I do not want to do anything which would make
the 2 database versions different from each other (including giving
them different dataset names), since I frequently copy them, back and
forth, between Test and Production.

I'm thinking along the lines of an "Autoexec" macro, that would run
some VBA code, to check what the path is, when the database starts
up ... but I'm not sure how to display this information to the user,
so that it would be clearly visible at all times. Thanks for any
help! Best,

--Tom
frethoa AT aol DOT com

Put this in the form_load event:
me.caption = application.CurrentDb.Name

or put this in the ToolTip property of a label:
Label1.ToolTip = application.CurrentDb.Name

or create a label...
Label1.Caption = application.CurrentDb.Name

[Stuart McCall]

"Tom_F" <fr*****@aol.comwrote in message
news:11**********************@o3g2000hsb.googlegro ups.com...

To comp.databases.ms-access --

I'm running Microsoft Access 2003 on Windows XP Professional. I have
a "Test" version and a "Production" version of our database, with the
same dataset name, but located in different paths (folders). I'd like
to find a way to always display on the screen, when the database is in
use, whether it is the "Test" version or the "Production" version.
Any ideas? Note that I do not want to do anything which would make
the 2 database versions different from each other (including giving
them different dataset names), since I frequently copy them, back and
forth, between Test and Production.

I'm thinking along the lines of an "Autoexec" macro, that would run
some VBA code, to check what the path is, when the database starts
up ... but I'm not sure how to display this information to the user,
so that it would be clearly visible at all times. Thanks for any
help! Best,

--Tom
frethoa AT aol DOT com

In your test folder create a text file called test.txt (doesn't matter what
it contains).

On your main form create a label with the caption "This is the test
database" and set its visible property to False. Call the label
"lblTestNotice".

In the form's OnLoad event, put the following code:

Dim strPath As String, strName As String

strName = CurrentDb.Name
strPath = Left(strName, InstrRev(strName, "\"))
Me.lblTestNotice.Visible = (Dir(strPath & "test.txt") <"")

The label will only be visible when the database has been launched from the
test folder.