Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access 2000
- Thread starter mkphan
- Start date
To make it available to the web, first converty it to "prior version" through the tools menu and convert to previous version. Next, you need to use ado to connect to the database in server side scripting...ex:
<%
dim sql
sql = "SELECT * FROM myDBtable WHERE ((myDBtable.oneColumn)="1"
;"
set conn = Server.CreateObject("ADODB.Connection"
DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSNtemp = DSNtemp & "C:\InetPub\ conn.Open DSNtemp
Set rs = Server.CreateObject("ADODB.Recordset"
rs.open sql, conn, 3, 3
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
DBQ is obviously where your converted to 1997 database lays on your hard drive tree, and anytime you want to work with the files within the database....inside the connection string use the recordset identifier to pull it up. Let's say you want the first and last name printed to the web page where myDBtable.oneColumn is equal to "1", as declared in the sql statement. then inside the connection string, write this code...
response.write rs("firstname" & " " & rs("lastname"
where firstname and lastname are the names of the table fields. does that answer your questions? if not, write back and I'll try to make it more clear.
Sincerely,
Jim
<%
dim sql
sql = "SELECT * FROM myDBtable WHERE ((myDBtable.oneColumn)="1"
;"set conn = Server.CreateObject("ADODB.Connection"
DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSNtemp = DSNtemp & "C:\InetPub\ conn.Open DSNtemp
Set rs = Server.CreateObject("ADODB.Recordset"
rs.open sql, conn, 3, 3
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
DBQ is obviously where your converted to 1997 database lays on your hard drive tree, and anytime you want to work with the files within the database....inside the connection string use the recordset identifier to pull it up. Let's say you want the first and last name printed to the web page where myDBtable.oneColumn is equal to "1", as declared in the sql statement. then inside the connection string, write this code...
response.write rs("firstname"
& " " & rs("lastname"where firstname and lastname are the names of the table fields. does that answer your questions? if not, write back and I'll try to make it more clear.
Sincerely,
Jim
Guest_imported
New member
- Jan 1, 1970
- 0
Do you know any good books about connecting access to web pages, i really need a step by step guide i can follow to design this web that is connected to access. so far i haven't found anything. I would be very grateful for any help you could give me. thanks
Anything you need to know you can find at the web workshop on microsoft's site for free!
If you still cannot find the answers you are looking for...feel free to email me at jimbob550@hotmail.com. I will try to answer your questions as complete and quickly as possible. But do try to learn it first as I usually work constantly and am busy a lot. But I will try to answer any Q's you may have.
-Ovatvvon
If you still cannot find the answers you are looking for...feel free to email me at jimbob550@hotmail.com. I will try to answer your questions as complete and quickly as possible. But do try to learn it first as I usually work constantly and am busy a lot. But I will try to answer any Q's you may have.
-Ovatvvon
Guest_imported
New member
- Jan 1, 1970
- 0
I want to connect ms access 2000 and Visual Basic through dao control. Please tell me where to find the required driver
- Status
Similar threads
- Locked
- Question