I am so frustrated with Visual Studio 2008! There never seems to be a quick and "easy" way to do anything with this program!
I have been using Access for years and have some pretty complex databases. But it is now time for me to make them web based.
I would like to link a very very simple access database with Visual Studio 2008. I keep getting errors! I cannot create an AccessDataSource
I have read on EE that access needs to be 2003. So, I resaved the database from 2007 to 2003 (it's a simple database, so no issue on this) . . .This did not solve my problem
Then I read on EE that I need to make sure I have correct security rights ("Everyone" needs full access) which we do
Then I read on EE that I need to add the path/file name to JetOLEDB: System Database
I also read to install/change the IIS . . but I have no idea what to do. I have IIS on my web server but I think that's all . . .eek!
I keep getting the same error (actually when I add the path to JetOLEDB, I get different errors
Here is my error . . ."Cannot start your application. The workgroup information file is missing or opened exclusively by another user" which it isn't. . .
Please Please Please. . . help me! I really do not know Visual Studio at all and I am trying to learn it, but I can't even get past the first step!
Here is what I am doing . .
Connect to Database
DataSource: MICROSOFT ACCESS DATABASE FILE (OLE DB)
Log on to the database: I have tried my admin, SA and windows logon and passwords . . .