Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
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?
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.
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?
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.