Backend path instead of frontend path?

[pat_nospam]

Is there a way to resolve the backend path via code instead of the frontend path?

I'm trying to put something together to check who's logged into the backend, but cannot resolve the path. When I use Current.db, it always gives me the frontend path.

Thanks in advance,

Pat

 

[pat_nospam]

Pat --

Perfect, I've been able to see the Backend path and filename in a query:

SELECT MSysObjects.Database FROM MSysObjects GROUP BY MSysObjects.Database HAVING (((First(MSysObjects.Type))=6));

However, is there a way to hardcode this into the form code and assign to a string so I don't have to call from a query?

Thanks in advance

 

[pat_nospam]

Perfect - Thanks again Pat!