homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

executing SQL script on remote MS Access database
SQL Scripts for MS Access

 3:08 pm on Aug 11, 2009 (gmt 0)


I am working on classic ASP site and the database used is MS Access. I have to add some more tables to enhance the site functionality. Problem is that the database is of huge size and can't be downloaded, modified and uploaded. Google searches gave me the idea for SQL Scripts. I have wrote down the SQL Scripts for the database. But don't know how to execute them on the Access Database placed on remote server.

Can someone suggest how can I do this?



 3:26 pm on Aug 11, 2009 (gmt 0)

If you are familiar with how to do queries on the database through ASP, you can do it the same way. Just use the SQL statement for creating tables (CREATE TABLE) instead of a SELECT statement.

If you are not already familiar with how to do it, you'll need someone with more ASP experience than me- I haven't even looked at ASP in many years (not that I did much with it even then).

Another issue is that if the Access file is that huge, you may be pushing the limits of what Access can do- it wasn't designed for the web with multiple users or getting really huge.


 4:38 pm on Aug 11, 2009 (gmt 0)

Fact is that site was created some time earlier and I am performing it's upgrading. Issue is that Site Owner is not willing to convert the site to .NET platform.

I am quite familiar with SQL syntax and have good experience with SQL Server.

My problem is executing scripts not writing them. How can I do this for remote database?


 5:03 pm on Aug 11, 2009 (gmt 0)

I doubt you could setup a data source on your local machine to access a remote Access file- that seems like a huge security hole. Most likely you'd have to run the scripts on the server where the database is. Write the code in ASP, upload the ASP file(s) to the server, then run them.

The only other alternative that I see would be having direct access to the server- Remote Desktop in and add tables directly through the Access GUI.


 5:07 pm on Aug 11, 2009 (gmt 0)


Thanks for help. The script placed in ASP file is best.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved