0

Hey guys,

I've managed to successfully create a little basic installer for installing all of the files. HOWEVER. I have multiple Access database files which cant also be installed to the Program Files directory because then they become read-only. So, I was going to install them to the Application Data directory.

My question is, how do I set the path in the VB Source code to read the Access Database file from Application Data. Regardless of the Username of the person using the program etc.

Thanks!

ps. Furthermore, how do I get around the problem of those who do not have access installed on their PC. Obviously they couldnt use the software then.

Edited by Ariah17

3
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by TnTinMN
0

You could use C:\Documents and Settings\All Users\Application Data. Or you could find the user name with SystemInformation.UserName and replace All Users with it in that path.

0

ps. Furthermore, how do I get around the problem of those who do not have access installed on their PC. Obviously they couldnt use the software then.

You don't need Access just the engine installed so you can use the ACE provider or if you prefer the engine directly with record sets.

Microsoft Access Database Engine 2010 Redistributable

Edited by TnTinMN

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.