Remotely changing or adding tables to an access database

[hallm]

I'm using an access database to feed my news site.  Every time I make any changes to the structure of my database, I have to download the new database make the changes then re-upload it.  How can I make the changes remotely using Microsoft Access?  

 

[palbano]

Dear hallm,<br><br>The way I have done this is not very secure, however sites that use Access files for their databases usually are not real concerned with security. <br><br>I create an ASP page that allows me to enter SQL statements directly in an HTML &lt;textarea&gt; element and execute the statements on the Access database file. Then this is how I handle security.<br><br>*The page is not accessible from any links on the site &lt;duh&gt;<br>*An ASP login/password routine is built in the page.<br>*I disable the page altogether when I am not using it to alter the database.<br>*I rename the page after each use.<br><br>Hope this helps<br>-pete<br><br><br>

 

[hallm]

How do you create tables using SQL?&nbsp;&nbsp;I'm familiar with creating them in access but I've never really used sql, except on my asp pages (SELECT)<br><br>Table name&nbsp;&nbsp;login<br><br>Fields<br><br>loginID&nbsp;&nbsp;&nbsp;&nbsp;autonumber&nbsp;&nbsp;&nbsp;&nbsp;indexed (no duplicates)<br>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>username&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>password&nbsp;&nbsp;&nbsp;text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fieldsize&nbsp;&nbsp;&nbsp;50<br>

 

[palbano]

Dear hallm,<br><br>Create Table T_TABLE<br>( ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,<br>Email TEXT (30),<br>Name TEXT (20),<br>Age Integer)<br><br>Hope this helps<br>-pete