Cant access database from debugger

[Android]

The program I have written uses an Access database for the data storage. When I first wrote it a few months ago everything worked perfectly. I have now come back to make some changes to it.

I made some small modifications to the code but nothing to the database code. I then try to run it in the debugger to test the changes and it complied with no errors but as soon as I try to use the database I keep getting errors.

These errors are all different, some cant find the table, and on other things it cant find the field. If I try to run the program outside of VS then it all works fine and there are no problems with it.

Is there some setting in Visual Studio that would cause this to happen as I have never seen it before.

Thanks.

 

[cjard]

Youre being very generic here.. Try being more specific about the errors thrown

 

[Android]

well the errors are all different database errors but they only occur when then program is running the debugger.

i cant remember the exact words but they are things like this table could not be found and this field doesnt exist

 

[giadich]

this sound more like a security permission issue for debugger user.

Make sure you assign proper permission so that debugger user(s) can read/write to the access db.

 

[Android]

ive just tried, im getting the same problem on my laptop. the laptop is running vista and the pc is on xp. im using an administrator account. How would i change the security permissions on both computers if that is the problem.

 

[giadich]

Right click on the file - Properties - Security - Add then on that screen, find the right user and add him then go back to the previous screen and highlight the newly added user and check read/write.... whatever you feel like needed.

You can also assign your account to the Debugger users group and add that group to the file permission.

One thing you might want to do is give the user/group permission to the whole folder as access db will create a lock file in the same folder and will probably need permission to do so.

 

[Android]

that didnt make any difference. I just got a new error though. Its now running the query fine but not getting any data from the database. There is no problem with the query as it runs fine outside the debugger.

The same is happening on both computers still.

This seems to be confined to just this project. Could it be a project setting or something?

 

[cjard]

if you want to get on msn, i'll remote control your machine and take a look; it sounds rather too confusing to solve without seeing it..