I have an Access database I am programming. The backend is going to be placed on a server inside of a password protected folder that only people who use the program will be able to get to. The folder and server are NOT accessible to anyone outside of the physical building so I do not need to worry about any outside accessing of the folder.
The question is, how can I hard code the id and password into the access program so that when I put the front end on a person's machine it automatically provides the id and password to the server so that the user can get to the backend?
There are people in the company that are not allowed to get to this server and folder. The only requirement to get to the folder on the server is that you are accessing the data through this access program (so everyone who has this program will use the same id and password combo).
I am learning more about vba every day but I am still an intermediate to any help is really appreciated!