Can anyone tell me how to generate functioning .mdb files without Access on

the Server that can be manipulated with asp?

Here is a Code Snippet of a Membership application that I did awhile ago,

Let me know if you need more information



Tim Morford

<!--#Include File=adovbs.inc-->

<%



Dim Format,FileMDB,FileName,Catalog,objTable,col



'Format for Jet

Format = 5



'The File name of the DB we are creating

FileName = (server.MapPath("../member/membership.mdb"))



'Create the object of the DB

Set Catalog = server.CreateObject("ADOX.Catalog")

 Catalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _

 "Jet OLEDB:Engine Type=" & Format & _

 ";Data Source=" & FileName



'create the Table object

Set objTable = CreateObject("ADOX.Table")

Create the Col with Autoincrement

Set col = Server.CreateObject("ADOX.Column")

    With col

  .ParentCatalog = Catalog

  .Type = adInteger

  .Name = "Member_ID"

  .Properties("Autoincrement") = True

    End With



' write the col to the DB

 objTable.Columns.Append col

' Define the Table name / or Define the table name. I could never tell if it

defined it or created it at that point

 objTable.Name = "Membership"



' I was looping through request objects to use them as the col's in the DB,

So you have no more or less.

For I = 1 To Request.Form("frmOn").Count

    objTable.Columns.Append Request.Form("frmOn")(I), adInteger

Next



' tell the table where the Primary Key is

 objTable.Keys.Append "PK_Member_ID",1, "Member_ID"

' create the Table

 Catalog.Tables.Append objTable

' clean up

 Set objTable = Nothing



%>





The annotation could be wrong it has been about a year since I did this, and

I did not annotate it then, Sorry but it should give you an idea!



Tim Morford

-----Original Message-----

From: Thomas, Charles E [mailto:charles.e.thomas@b...]

Sent: Wednesday, August 29, 2001 9:22 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Using Access without installing





Can anyone tell me how to generate functioning .mdb files without Access on

the Server that can be manipulated with asp?

I made sure that the ODBC listed a driver for MS Access, if not go to

Microsoft's site and download the latest driver.  The filename is

ODBCJT32.DLL and gets copied to the Windows system folder.  You could always

do a Find for it first, then compare the version you have to the most recent

version. You'll need the recent version to work with an Access 2000 database

(an older version will only work with Access 97).



Roger



-----Original Message-----

From: Thomas, Charles E [mailto:charles.e.thomas@b...]

Sent: Wednesday, August 29, 2001 6:22 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Using Access without installing





Can anyone tell me how to generate functioning .mdb files without Access on

the Server that can be manipulated with asp?

http://www.aspalliance.com/mbrink1111/



Check out BuildDB and BuildApp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Thomas, Charles E" <charles.e.thomas@b...>

Subject: [asp_web_howto] Using Access without installing





: Can anyone tell me how to generate functioning .mdb files without Access

on

: the Server that can be manipulated with asp?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~