Creating tables from scripts

[accesscoder]

Hello everybody,

I have created database containing, 4-5 tables, some are static, some are dynamic. During the testing of application I entered a lot of data in it. Now I want to deploy the application to client. Is there any way, using which I can create a script of all the tables and execute it on client machine? Basically my goal is to deploy the database at client's Access, with primary keys(auto number) of the table starting from 1. It will be very difficult to create the tables again.

I appreciate your help!
Thank you!

[pbaldy]

To my knowledge, Access does not have a feature to script the CREATE TABLE statements like say SQL Server does. That said, it should be a relatively simple matter to make a copy of the db, and delete all the data from the tables. If you then compact/repair, the autonumbers should reset.

[accesscoder]

Wow..thats what I wanted!
Thank you, pbaldy!

[pbaldy]

No problemo!

[ajetrumpet]

To my knowledge, Access does not have a feature to script the CREATE TABLE statements like say SQL Server does.

Paul, i believe the DD queries can execute command like in Sql server and PHP/mysql. I've never run one, but I was reading up on it the other day. The statements look pretty much the same as server side querying does. ever used one?

the article I was reading used commands like 'alter table' and 'drop'

[pbaldy]

I'm certainly aware that Access can run DDL queries. I think the question revolved around whether you could have Access create the DDL SQL for you, which I'm not aware of it being able to. In SQL Server, you can simply right-click on a table and have the DDL query created for you that would enable you to recreate the same table elsewhere.

[ajetrumpet]

i just wondered Paul. I've never used them, but I will experiment whenever I have time. Interested in what they offer...