×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Thank you for your response for my last post. Now I can retrieve data from the remote Access, but I can't write data into the Access.

I modified the data path in the control pannel of the server. it wasted our time because there is no instruction on the rule of the data path. As I said, I still can't write data into the remote Access. Is that my code problem or server side problem? To retrieve data from database, I didn't use any code about userid and password. My code is as following:

Set Con=Server.CreateObject("ADODB.Connection")
dbpath=Server.MapPath("/xxx/cuxxx.mdb")
con.open "provider=microsoft.jet.oledb.4.0; data source="&dbpath&""

In terms of writing data into database, whether I need add some code about userid and password? Thank you all.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / Thank you for your response for my last post. Now I can retrieve data from the remote Access, but I can't write data into the Access.
    I modified the data path in the control pannel of the server. it wasted our time because there is no instruction on the rule of the data path. As I said, I still can't write data into the remote Access. Is that my code problem or server side problem? To retrieve data from database, I didn't use any code about userid and password. My code is as following:

    Set Con=Server.CreateObject("ADODB.Connection")
    dbpath=Server.MapPath("/xxx/cuxxx.mdb")
    con.open "provider=microsoft.jet.oledb.4.0; data source="&dbpath&""

    In terms of writing data into database, whether I need add some code about userid and password? Thank you all.
    • 真不知道该怎么回答你的问题。你先试着用ms ACCESS打开这个远程mdb,直到成功了,那个路径就是你的datasource. 然后你再考虑怎么写你的程序
    • 对呀对呀,Server.MapPath( ) 可以得到绝对地址。如果local没问题的话,估计是server端设置的internet用户对该mdb文件只有read的权限,没有write的权限。
      • Thank you. I'll contact the support staff tommorow.