Recently I had a need to add a table to an Access database. My first inclination was to open Microsoft Access and simply add the table. I pulled a copy of the database from the server. While proceeding to do so, it dawned on me. What if I build this table and upload the amended database to the server, and someone has entered data while I was working on it? Well, not wanting to lose any information that a user could have entered while I was adding my table. I immediately began looking for a better way. ADOX (Active X Data Objects Extensions) was the answer.
Using
ADOX, I was able to add a table to my database without the risk of losing any data after overwriting the original copy. Here's what happens. You determine what you want in the table and then put that information into an ASP and call it one time. That's it, your table is built.
It may take a little while to set up the page, but you don't have to worry about the possibility of losing any data that may be input into the other tables.
Here's
How It's Done
In this case we will assume you need a table that has four fields that will house the data from a form. This form will extract a name, email address, comments, and geographical region from users on your site.
First lets start with a connection. I use a DSN-LESS connection here, but it's up to you.
