424,294 Members | 1,898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

Am I using the Local BE or Server BE?

P: 9
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.
1 Week Ago #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,427
To start you off, have a look at in the immediate window in your FE Db.

Expand|Select|Wrap|Line Numbers
  1. ?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

1 Week Ago #2

Seth Schrock
Expert 2.5K+
P: 2,920
A simple method is to hover your mouse over the table name and then it shows you the connection string.
1 Week Ago #3

Expert Mod 2.5K+
P: 2,894

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!
1 Week Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.