asp 連結 access 資料庫
今天在寫網頁時,因為懶得寫後端的管理程式,想說用 access 資料庫,就可以偷懶,讓管理者直接用 access 來處理資料就好,可是在連結資料時一直很不順,有時可以有時不行,重整又可以,一會兒又不行,真是xxx,後來在微軟網站找到問題.
本來的連結:(第一種方法)
SET CN=SERVER.CREATEOBJECT("ADODB.CONNECTION")
CONN.OPEN "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" & SERVER.MAPPATH("資料.mdb")
後來更正的連結:(第二種方法)
Set CN=Server.Createobject("ADODB.connection")
CN.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("資料.mdb")
網站上說:
第一種是舊方法,主要是給 access97 用
第二種較新,是給 access2000 用
所以改用第二種連結方式問題就解決了
2010/07/01
office2007用
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Fname 'Access 用
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Fname & ";Extended Properties='Excel 12.0 Xml;HDR=YES';" '連接EXCEL文件
必須到 microsoft 下載 AccessDatabaseEngine.exe
迴響
asp 連結 access 資料庫 | 豬窩
First off I want to say great blog! I had a quick question that I'd like to ask
if you don't mind. I was curious to know how
you center yourself and clear your thoughts before writing.
I have had trouble clearing my mind in getting my thoughts out there.
I do enjoy writing however it just seems like the
first 10 to 15 minutes are lost simply just trying to
figure out how to begin. Any recommendations or tips?
Thank you!
asp 連結 access 資料庫 | 豬窩
Hello there I am so happy I found your webpage, I really found you by accident, while I was searching on Askjeeve for
something else, Regardless I am here now and would just like
to say thanks a lot for a tremendous post and a all round interesting blog (I also love the
theme/design), I don't have time to read through it all at
the moment but I have saved it and also included your RSS feeds, so when I have time I will be back to read a great
deal more, Please do keep up the awesome work.
asp 連結 access 資料庫 | 豬窩
It's amazing to pay a visit this site and reading the views of all mates concerning this
paragraph, while I am also zealous of getting knowledge.
asp 連結 access 資料庫 | 豬窩
It's remarkable in favor of me to have a web site, which is beneficial in favor of my experience.
thanks admin
asp 連結 access 資料庫 | 豬窩
What's up everyone, it's my first visit at this web page, and piece of writing is in fact fruitful designed for
me, keep up posting such articles.