HI there,



Any one could you tell me Iam facing this problem

:--1. In Access 2000, when I use a updateable Sql

query ("update [table name] set [field name]=new entry

where [field name]='asdf'") .

This new entry is a datetime datatype containing date

and time+AM/PM , the field is of

datetime..............

It gives an error for "Updateable query" whereas this

works perfectly for Access97  and also  in Sql

Server7.0 . 



2. it gives "file already in use or you don't have the

right permissions to view this file "   when----

I use the connection

string-"Provider=Microsoft.jet.OLEDB.4.0;"



3. What does this error mean ---??

	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 0x8fc Thread 0xa28 DBC 0x1fd614c Jet'.



4. Can Access be used for a website which is expected

to have many concurrent visitors ( more than 1 visitor

accessing the database at the same time)







BHANU







__________________________________________________

Do You Yahoo!?

Get email at your own domain with Yahoo! Mail. 

http://personal.mail.yahoo.com/