Programming help need..

[shiroii_neko]

Hie : i need programming help here to solve this error code

Im building a web based application using ASP.Net 2003 and its connects to Ms.Acces 2000 Db.. When i de-bug i receive tis error msg

"The Microsoft Jet database engine cannot open the file 'C:\DB\db2.mdb'. It is already opened exclusively by another user, or you need permission to view its data. "


Is this a complicated error ??
Thx in advance

 

[BlackSamurai]

perhaps you shall close your previous DB connection. do a a try catch error and close the db connection if you hit error.

switch to MSDA , better performance and no 1 using MDB in industry

 

[shiroii_neko]

err what is MSDA ??

managed to correct the error.. i get the data source (.mdb file) from my thumb drive instead from my laptop.. so weird

 

[BlackSamurai]

sorry, it shall be MSDE, but now replace with SQL 2005 Express edition
http://www.microsoft.com/sql/editions/express/default.mspx

 

[sakuraguy]

Make sure your permissions are set in IIS - user permissions as well as execute...

 

[shiroii_neko]

IS SQL Server 2005 Express Edition difficlut to learn ??

 

[nashlovebrown]

IS SQL Server 2005 Express Edition difficlut to learn ??

if u got experience in SQL 2000 then wont be prob...if not then abit difficult...but what to do, must always adopt the new technologies..

 

[BlackSamurai]

IS SQL Server 2005 Express Edition difficlut to learn ??

easier than Access learning is what you suppose to do, no matter difficult or easy.

You shall ask question like, "Will it be useful for my future job carrier if I know this?" guess you got the answer.

tones of guide available internet.

 

[shiroii_neko]

from job vacancy adevetised, they prefer skills in SQL Server and Oracle.. u guys self taught SQL Server 2005 ?? i dun ecen know how to use SQL Server 2000..

 

[BlackSamurai]

i learn it by myself with some reading. Get yourself a book.

 

[shiroii_neko]

Thx for da advice... if only private colleges inclue both Oracle and SQL Server as part of the curiculum... hhhehe.. Back to square one no short cut in life to suceed.. Black Samurai you must a senior in IT field ??

 

[BlackSamurai]

me? left technical and programming for quite some time. Haha