I'm new using access.

[yatie]

Hi, i'm new using db Ms Access. I have refer all the forum and problem other person but the most of their problem related with Ms Access to server. My problem is , i used my own pc (local) to running my system but i can't run.

My database save in C:/. Database Name is DataAmbridge.
Table Name is INVENTORY. So please help me all ;).
TQ.

Is it correct if i do like this . Please refer the attachment:
:confused: :(

[jsawkang]

Hi...

what is the error u get?

by the way, there are some usefull article about database connection in this site. try it out.

http://www.programmersresource.com/forum/showthread.php?s=&threadid=68

[help]

Hi...

Sometimes little spelling errors could cause not to run. In your coding, you have misspelled "Recorset" for "Recordset". Try to fix that error and see. If you get any error numbers, you can cut and paste the error number and search in Microsoft's Knowledge base.

[tev]

Hi
my experience with an access db is that you should not use the acces driver to connect to it , i think it has some bugs

this code i just cut from another question "Connecting to Access Database using a Database Password ":)

Set conConnection = Server.CreateObject("ADODB.Connection")

conConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("\odford\db\odford.mdb") & ";" & _
"Persist Security Info=False")

I think you will have less trouble if you use this

are there any people that have seen the same trouble with the access driver?