Deleting a table and autonumber on remote server

[andymccorkell]

Hey

I've been using access to remote edit a mysql database however im getting 2 problems:

1. it wont seem to let me use autonumber? i set up my primary field as an autonumber but then when it saves it to the server it is just number? then it wont let me change it?

2. due to this i have a number of tables that i need to delete and try again. ive been trying this,

DROP TABLE {galleryv3};

in the mysql console window in access as a straight through query but it gives me an error regarding my syntax?

any help would be more than apriciated.


Andy

ps what is the best way of editing/managing my database? access?

 

[sleipnir214]

1. By &quot;won't let you change it&quot;, do you mean &quot;won't let you set the auto_increment to a particular value? In MySQL 4.x, you issue the query &quot;alter table <tablename> auto_increment = 1&quot;.

You can't do it in MySQL 3.x -- you have to drop and recreate the table. However, when performing a &quot;DELETE * FROM <table>&quot; query, MySQL 3.x actually drops and recreates the table in order to perform the query more quickly. The auto_increment should reset.

If you're asking why the column type specified is an INT, it's because an auto_increment column has to be an integer type in MySQL.


2. I don't know where you're getting the curly braces from, but lose them.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!