I have a working Vb app, that uses a msaccess(accdb) database. It is just a data entry program. It works fine on my laptop, where I have developed it. I want to move the MSAccess DB to a server share and install the program on another PC(Terminal Server). My users will connect to the Terminal Server and run the program. My questions are;
1. Does the server of the Ms Access DB need to have MS access loaded on it and/or the machine that the program is running from?
2. Is there a way to include the Ms Access DB in the program so when I publish it, the database will go with it?(if yes, I understand my first question is irrelevant.)
2b. If not, is there a way that I can put a relative path in the program, so that it will always look locally for it or does the path have to be static.
Thanks for any help!
Brian
1. Does the server of the Ms Access DB need to have MS access loaded on it and/or the machine that the program is running from?
2. Is there a way to include the Ms Access DB in the program so when I publish it, the database will go with it?(if yes, I understand my first question is irrelevant.)
2b. If not, is there a way that I can put a relative path in the program, so that it will always look locally for it or does the path have to be static.
Thanks for any help!
Brian
