Providing a password and id via Access vba for a password protected file on a server

Hello All,

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!

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
You can't do this.
Users will have to be granted read/write/create/delete rights to the folder with the backend mdb or accdb files and read/write rights to the frontend file.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alevin16Author Commented:
SIgh, I was hoping I could :D

Oh well, I will have to do it more manually then.  THanks for the quick response!

Have a great day
alevin16Author Commented:
QUick and to the point!
Gustav BrockCIOCommented:

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.