does anyone have any links to tutorials on how I can insert tables and
columns into a pre-existing access DB through the use of ASP and SQL?

I have a huge DB online and am tired of downloading and uploading all the
time. I've seen this done with Cold Fusion, however I no longer have access
to the source.

any help greatly appreciated.

--



Kind Regards
Mark McCarthy (Dip MM)

i think the best way to do that would be to build some forms that can send SQL statements through to the database, such as <pre id=code><font face=courier size=2 id=code>CREATE TABLE name (name TINYINT (3) UNSIGNED DEFAULT '0')</font id=code></pre id=code> and so forth, thus creating a "Database Admin" panel for access.

i'm not sure how access reacts to real SQL being fed into it, and i'm also not sure about the SQL syntax that Access uses to manipulate data structures. I don't think it'll be exactly the same as other SQL-based platforms.

However, i have another idea.... why don't you create a local Access database to act a a remote client for the one on your server? You can link to the tables and any changes you make to the remote linked tables will be automatically reflected on the master on the server. It's been a long time since i've used Acc*ss (thank god for that) and i don't remember if you can actually manipulate structures through remote clients, but it's worth a try.

The only other things i can suggest is look around the Opensource community for a solution, although i doubt you'll find anything since Access is made by microsoft and already provides its own easy to use interface.

Or you could use an adult database like MySQL or Postgre <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I hope that helpeda bit! <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

------------------------
Julio Mellado

PHP | MySQL | UD4

ICQ: 19735247
MSN: