Add Columns to Access database with ASP

Question

I have an website written in ASP classic with VB. I need to add a column to the table, but I cannot take down the website to be able to edit the table in access. How do I do this in code?

I am very new to ASP and access, I have a lot of experience in PHP and MYSQL but I have been able to find the syntax.

Thanks for all assistance.

Adam · Accepted Answer · 2011-08-08 14:36:09Z

2

OpenDB("database/cpio.mdb") SQL = "ALTER TABLE Members ADD business_url text"

dbRS1.Open SQL, dbConn, adOpenDynamic, adLockOptimistic

answered Aug 8, 2011 at 14:36

Adam

772 gold badges3 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

d_ethier · Accepted Answer · 2011-08-06 14:32:51Z

0

Should be relatively easy if you are already connecting to the database and executing queries. Try:

ALTER TABLE <table> ADD COLUMN <column> <type> NULL/NOT NULL

answered Aug 6, 2011 at 14:32

d_ethier

3,92126 silver badges31 bronze badges

5 Comments

Adam Over a year ago

OpenDB("../database/database_name.mdb") ALTER TABLE Members ADD COLUMN Agency Integer NOT NULL Is that all i need?

d_ethier Over a year ago

It looks right to me. Do you have a test environment you can try it out on first? Or, grab a copy of the database and try it with VBScript first.

Adam Over a year ago

I don't have a test environment, and it does not work.. Microsoft VBScript runtime error '800a000d' Type mismatch: 'OpenDB' /edit_database.asp, line 3

d_ethier Over a year ago

Can you post a full example on pastebin?

Adam Over a year ago

got it! OpenDB("database/cpio.mdb") SQL = "ALTER TABLE Members ADD business_url text" dbRS1.Open SQL, dbConn, adOpenDynamic, adLockOptimistic

Collectives™ on Stack Overflow

Add Columns to Access database with ASP

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related