74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.
With new material every week, we'll make sure that you stay ahead of the game.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Best way to accomplish this task?
Posted on 2016-09-07
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Here is what I would do:
First round of "update" application searches the drive for the TXT file then stores it in an appropriate location in either HKLM or HKCU in the registry - HKLM\Software\PDDatabase\D
Subsequent updaters can see if the registry key exists and, if not, search the drive and write the key. If it finds the key, it verifies the location of the file and tests to ensure it can connect to the backend server with the information from the text file.
I would say that keeping the information in the registry would, in the long term, be a better place than a TXT file or an INI file, but having the location of the text file stored in a known, programmatically-controlla
One thing about the search for the TXT file: Enumerate all instances of said file and validate which copy it might be - a TXT file that is kilobytes in size is likely not it. Is the TXT file going to be in a folder that is in the %PATH% of the user's environment? If so, you could dramatically limit your search scope by only searching for the file along the path.
First round of "update" application searches the drive for the TXT file then stores it in an appropriate location in either HKLM or HKCU in the registry - HKLM\Software\PDDatabase\D
Subsequent updaters can see if the registry key exists and, if not, search the drive and write the key. If it finds the key, it verifies the location of the file and tests to ensure it can connect to the backend server with the information from the text file.
I would say that keeping the information in the registry would, in the long term, be a better place than a TXT file or an INI file, but having the location of the text file stored in a known, programmatically-controlla
One thing about the search for the TXT file: Enumerate all instances of said file and validate which copy it might be - a TXT file that is kilobytes in size is likely not it. Is the TXT file going to be in a folder that is in the %PATH% of the user's environment? If so, you could dramatically limit your search scope by only searching for the file along the path.
I assume that each and every police department uses the same application to first open front-end txt file to get path to back-end access database file, then to open back-end database to work with. If that application used by police departments does have a logic to find the txt file no matter which client machine it is running on, then I think you might be able to use the same logic to find and read front-end txt file.
Another option could be possible if your front-end txt file is installed by an installer, and your front-end txt file path is relative to the installation folder, then you could try to lookup into Windows Installed Programs list and then find the installation folder.
Otherwise, if your front-end txt file is manually copied to client machine. I don't really see any option for you to accomplish and make a generic database updater application. The only option is that your new database updater application should ask for the path to front-end txt file when being executed on client-machine. And if your database updater application is going to be used a lot in the future, you can save the path to front-end txt file right away (to a fixed location or to registry) on the first time it is specified on each client machine and then just load it next time database updater application runs.
Another option could be possible if your front-end txt file is installed by an installer, and your front-end txt file path is relative to the installation folder, then you could try to lookup into Windows Installed Programs list and then find the installation folder.
Otherwise, if your front-end txt file is manually copied to client machine. I don't really see any option for you to accomplish and make a generic database updater application. The only option is that your new database updater application should ask for the path to front-end txt file when being executed on client-machine. And if your database updater application is going to be used a lot in the future, you can save the path to front-end txt file right away (to a fixed location or to registry) on the first time it is specified on each client machine and then just load it next time database updater application runs.
Hi.
In my opinion, you can locate all backend files on one serverand in the same folder (if possible), then you can access all backend files easily with your .net app.
To access the backend files from Access you can use the UNC path instead of using mapped drives. A UNC path is the form \\ServerName\ResourceName\
You can obtain the UNC path from the Mapped_Drive:\Folder by using the Scripting.FileSystemObject
If you need help for using the FileSystemObject, please, feel free to ask.
Best regards.
Antonio.
In my opinion, you can locate all backend files on one serverand in the same folder (if possible), then you can access all backend files easily with your .net app.
To access the backend files from Access you can use the UNC path instead of using mapped drives. A UNC path is the form \\ServerName\ResourceName\
You can obtain the UNC path from the Mapped_Drive:\Folder by using the Scripting.FileSystemObject
If you need help for using the FileSystemObject, please, feel free to ask.
Best regards.
Antonio.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 19 hours left to enroll
622 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.