Welcome to WebmasterWorld Guest from 54.167.157.247

Forum Moderators: open

Message Too Old, No Replies

executing SQL script on remote MS Access database

SQL Scripts for MS Access

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

5+ Year Member



Hi

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)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



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)

5+ Year Member



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)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



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)

5+ Year Member



Great!

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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month