Am I using the Local BE or Server BE?

[pcheng]

So, I have a silly question. I kept a version of a Backend Database on my local C drive for tweaking the FrontEnd before I am ready to publish it. However, after the publication, I will relink the BE on the server. Well, sometime I forgot, or I did not know which BE my frontend is currently linking to. Is there a way to have a simple code to tell me where is the FE currently linked to? Ty.

[PhilOfWalton]

To start you off, have a look at in the immediate window in your FE Db.

?currentdb.TableDefs("MyYable").Connect

where MyTable is any table in your BE (assuming that ALL the tables are either on the local disc or the server.

You should get something like
";DATABASE=C:\Users\User\Documents\Access\MDB 2010\Mike May 2018\Mike Db Data.accdb"

I am unable to access my server at the moment, but I think you get something like
"\\OFFICEMESH\Users\Phil\Documents\Access\MDB 2010\Calendar\Calendar 2011 Data.accdb"

The double backslash is the key to your problem

Phil

[Seth Schrock]

A simple method is to hover your mouse over the table name and then it shows you the connection string.

[twinnyfo]

Pcheng,

Both answers above will help you to answer your specific problem. It may also help for you to take a look at this thread on Using Front Ends and Back Ends. This has some good principles pertinent to how you are using your project.

Hope this hepps!