We help IT Professionals succeed at work.
Get Started

Best way to accomplish this task?

261 Views
Last Modified: 2016-09-08
We have an access database, which is being used by multiple police departments.  The database is split front-end/back-end.  The backend sits on the department's servers.  The front-end sits on the client machine with a .txt file that shows the path to the backend.  The front-ends are not installed in the same directory on each client.

I am creating a vb.net application which will do some importing into the access database.  Since each department has different locations where the front end and back end sit, what would the easiest way to get the location of the backend so I can connect to it through the vb.net and accomplish what I need to do?

Do I do a search for the .txt file that shows the location of the back-end?  I believe that would take a long time to accomplish.  Do I create an application for each department individually?  I would rather stay away from that due to update on future code.
Comment
Watch Question
Enterprise Business Process Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE