Export Structure?

[Pryach]

I'm trying to find a way to export the structure of a table in my Access database.

I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.

I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.

I can't seem to find a way in Access 2000 to export the structure of the table.

 

[deBassMan]

Hi there

what db are you using on your web server?

 

[Pryach]

Access 2000

 

[Pryach]

Is this something that can't be done? Seems like a fairly common function in other database.

How are you supposed to backup your database to a text file?