By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,314 Members | 2,155 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,314 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.
Feb 8 '19 #1
Share this Question
Share on Google+
3 Replies


PhilOfWalton
Expert 100+
P: 1,430
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

Phil
Feb 8 '19 #2

Seth Schrock
Expert 2.5K+
P: 2,941
A simple method is to hover your mouse over the table name and then it shows you the connection string.
Feb 8 '19 #3

twinnyfo
Expert Mod 2.5K+
P: 3,284
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!
Feb 10 '19 #4

Post your reply

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