18 Mar 2019 
Support Center » Knowledgebase » How do I use an Access database?
 How do I use an Access database?
Solution
Microsoft Access is part of the Microsoft Office suite of applications and is a database that is suitable for low-usage web sites. The Access database is stored in an MDB file, eg mydatabase.mdb
 
Although there are many different ways of using an Access database we have documented an example for the convenience of our users. This knowledgebase article is a specific example, and you will need to adjust file names and other things as appropriate. This example is how to connect to an Access database from an ASP script.
 
Dim dbCon
Dim rst
Dim strConnection
strConnection = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=c:\domains\mysite.com\db\mydatabase.mdb;"
Set dbCon = Server.CreateObject("ADODB.Connection")
dbCon.Open strConnection
Set rst = dbCon.Execute("SELECT * FROM MyTable;")


Article Details
Article ID: 56
Created On: 12 Sep 2003 01:43 PM

 This answer was helpful  This answer was not helpful

 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | Troubleshooter | News | Downloads
Language:

Help Desk Software By Kayako eSupport v3.00.90