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.
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.