Hello all,
I am a regular visitor of this blog and all the replies help me a lot many times in doing my work...

I am trying to make an Inventory mangent s/w in Access and using its forms option to design all forms and use lil bit VB(tht cms integrated with Access itself) to handle customize query.

I had write below coding for a button click named Update ….and the error says drivers nt specified…
So I tried to install frm accees given controls bt did nt find it there…
I search it on the net and found out tht it automatically installed whn u install ms-office and if its not thn u hav to install it frm registry….tell me if it is so?

Private Sub Command29_Click()
Dim con As New ADODB.Connection
con.Open "d:\excel\db2.mdb"
con.Execute "update [Inventory Transactions] set quantity=" & Quantity.Text - sold.Text & "where [SKU Code]=" & [SKU Code].Text
con.Close
End Sub

Another way i thought to make a connection using DSN(whch I mke it frm administrative tools) bt in that case it gives persistent run time error that an unknown user blocks u to open or change dabase…

plz guys let me knw the way out....its very very urgent...my all project gets struked due to this...
Thanks in advance....Another way i thought to make a connection using DSN(whch I mke it frm administrative tools) bt in that case it gives persistent run time error that an unknown user blocks u to open or change dabase…given below…

plz guys let me knw the way out....its very very urgent...my all project struke due to this...
Thanks in advance....

Configuration: Windows XP Internet Explorer 6.0