Hii ...

Need anyone help in solving this problem.

I have a program running in VB ... but I'm creating a new idea where my user can update the related information via browser. Since I'm using vb and windows ... so I decide to use asp.

When I try to update, everything work just fine. Until I relize a problem when I open my VB application at the same time (because I use vb to perform action by checking value from database), The ASP won't be able to connect to database with error message

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf34 Thread 0xec8 DBC 0x13e3fac Jet'.
/daily/Default.asp, line 27"

I know well it's not the asp program I write wrongly .. because If the dabase is not opening .. the asp program will just fine and work perfectly. I try also to open the database using access ... but the same problem. So I can justify that the asp can't connect to database when any application is opening the database.

Anyone have any solution to this?

You cant have 2 "people" updating the same thing at the same time. It not only applies to db's it applies to any shared application. Consider this.

I have 1 document with "hello world" we both open the same document. You change it to read "HELLO world" & I change it to read "World". How does the application know which version to save? You cant have 2 people editing identical content at the same time.

When you open the db it doesnt know if your going to add delete tables/rows so it locks the db. I may be misunderstanding the question but my experience is once you open the db, especially access, in access the db is locked from the web until you save and exit the db.

Earl
www.jhdesigninc.com

so anyone have any solution? because my project using vb to perform some function by taking value from database. At the same time I provide for my client to access via asp by using the advantage to update database value. so basically asp is not performing any function, just updating database where vb getting information to perform some function. So I need both ...

I don't see any reason that you can't have 2 apps using an Access MDB at the same time. I have many implementations doing this.
I suspect that you do not have your security set up to allow the right access to the LDB file which controls the locking of an mdb file, or for the registry as stated in the error message you are getting.



Woody Z http://www.learntoprogramnow.com