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.

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?

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.

Great!

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