*** Auto change MS Access table design ***

When using an SQL command to update the design of an MS Access database like this

ALTER TABLE mytable ADD COLUMN [mycolumn] number

can you tell me whether it is possible to make the column an autonumber ?

ALTER TABLE mytable ADD COLUMN [mycolumn] autonumber

Gives a syntax error.


## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

2000 +

Habilidades: Administração de Bancos de Dados, Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: ms access work, design access database, by design auto, auto hire, auto design sites, auto by design, access database design software, 3 column web design, ms access web database, ms access sql, ms access to web, MS Access Database, auto update, php sql syntax error, update form access, change column, database table design, sql syntax error, auto update source code, add code access database

Acerca do Empregador:
( 65 comentários ) Ashford, United Kingdom

ID do Projeto: #3498426

Concedido a:


See private message.

$1 USD em 2 dias
(1270 Comentários)