I am finishing developing an Access aplication with ASP on a full fledged Windows 2000 server.

Everything is going ok. The database will receive data almost continually.

What im concerned is when i need to change the structure of the DB.

If i change it locally, i would upload but it would overwrite the fresh data in the server.

So the only way i can think of now is:
_ Close the data input page with a "mainteinance"
_ Import all the data to my local DB
_ Change the DB structure
_ Upload
_ Open the data input page again

AFAIK i cant change the structure of the access database remotely right? i can create ODBC connections but dont know if i can access the db structure like i can with mysql using phpMyadmin.

All help is appretiated,