E
Eman
I create my DB in access and This time insted of use form to enter my data I
use the DAP option on access 2003. Now my problem is in this page I load my
DB to my remote hosting server and I load the DAP too. I try to open the DAP
and its came up BUT I got this message that it still linking to my C: drive
on my computer and it can not find the path to the server. I went and try to
edit this path thought Access but it will not let me to connect to my server.
here is some Examples -(//htdocs/folder/mydb.mdb) ,
(http://www.mydomainname.com/folder/mydb.mdb)
when I used the above it gave me the following err "Data Provider could not
be initialized" then " file is not found". I talk with my hosting company and
they told me to add the following to my DAP
Set Conn = Server.CreateObject("ADODB.Connection")
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=/folder/mydb.mdb"
Conn.Open ConnString
Where do I add something like that in Access ? and what is wrong with my DAP ?
use the DAP option on access 2003. Now my problem is in this page I load my
DB to my remote hosting server and I load the DAP too. I try to open the DAP
and its came up BUT I got this message that it still linking to my C: drive
on my computer and it can not find the path to the server. I went and try to
edit this path thought Access but it will not let me to connect to my server.
here is some Examples -(//htdocs/folder/mydb.mdb) ,
(http://www.mydomainname.com/folder/mydb.mdb)
when I used the above it gave me the following err "Data Provider could not
be initialized" then " file is not found". I talk with my hosting company and
they told me to add the following to my DAP
Set Conn = Server.CreateObject("ADODB.Connection")
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=/folder/mydb.mdb"
Conn.Open ConnString
Where do I add something like that in Access ? and what is wrong with my DAP ?