I have recently split a production database, and now have two (or more) versions of the back end in different locations. So that I can be quite sure which back end is linked, on the productiion system and the development system, can I recover the 'back end location' from anywhere? I would then display that on the main menu.

Robert

Try this in a query:


SELECT SplitDBConn(Nz([Connect],"")) AS ConnectedDb, MSysObjects.Database
FROM MSysObjects
GROUP BY SplitDBConn(Nz([Connect],"")), MSysObjects.Database, MSysObjects.Type
HAVING (((MSysObjects.Type) In (4,6)));

The Connect field is if you have any SQL Server, etc. linked tables. If not you can omit that column.

SOS: That worked great. Thanks so much!

Robert

Glad we could help. :)