TheSwamp

Code Red => .NET => Topic started by: MexicanCustard on March 02, 2012, 09:03:36 AM

Title: VS 2010 OleDb and Jet question
Post by: MexicanCustard on March 02, 2012, 09:03:36 AM

I've got a .NET program thats getting data from an existing Paradox database via OleDb and Microsoft.Jet 4.0.  Which BTW is a horrible way to store data compared to today's relational databases and makes no sense why anyone would continue to use in todays software. Anyway, when I run the program in VS2010 debugger mode the application performs as expected but when I run the application (.exe) outside of VS2010 I get a database access exception.  Any thoughts as to whats going on here?

The database is located on a network drive so I moved it to my local drive and still the same problem.

Title: Re: VS 2010 OleDb and Jet question
Post by: vegbruiser on March 02, 2012, 09:15:28 AM

Perhaps VS is using different credentials to access the database that the .exe file isn't setup for?

Title: Re: VS 2010 OleDb and Jet question
Post by: MexicanCustard on March 02, 2012, 09:28:03 AM

Alex thanks for replying.  All I had to do was run my app as Administrator and everything worked. Don't know why I didn't think of that yesterday.