Problems loading data from Access Database only if using VS 2010 and Rights Issues

Juan Collado

I have an application that was running of SQl Server but I had to deploy to another company overseas.
I converted it to work off ms access instead of SQL.

One of the applications or process was built on VS 2003 and the main app is built in VS 2010.

The following Connections string works fine when application is installed on the C drive but will not work if the installation was done on the programs folders:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ATP_Data\My_Data.mdb;User Id=admin;Password=;"

Now that same connections string works perfect in the VS 2003 application.

Why does it work fine on both apps when installed on the C drive?

Second question:

My application works fine and saves data fine to access as long as I have admin rights to the local drive, how can I make my program bypass that and make it able to write to access even if not logged in as admin for that PC? Do I must have their IT department give writing rights tot eh installation folder?

Thanks fo ryour help

JCollado

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Carter15y ago
Accepted answer
Everyone has the ability to write to a database on the C: drive of each individual computer but those users will only have the ability to write to a public folder on a network. For security reasons you cannot update any files in the programs folder.

Decide where you are going to install the program and database on the network and then get the company IT people to share this folder on the network and also allow network users to change the database file.

Try looking at MS help - Search "How to take ownership of a file or folder in Windows 7" or "Windows 7 network sharing"

Also this might be useful: http://office.microsoft.com/en-us/access-help/ways-to-share-an-access-database-HA010279159.aspx

Hope this helps.
D
0
Juan Collado15y ago
Thanks David that gives me a good idea as to what is going on. I guess in my case the best way was to install to the personal folders. Maybe that is why programs like ACT install the database on the personal folders. Thanks
0