can't delete from multiple tables in access 2000

[Guest_imported]

I'm trying to delete entire records in 2 tables in an access 2000 database, but it's not working. I don't get any errors, the records are simply not being deleted. Syntax follows:

delete * from users inner join answers on users.user_uid = answers.user_uid where users.user_uid = [user id]


If I change the statement to delete from one table it works, so I know the "where" clause is correct.

 

[JoeMiller]

DELETE FROM users inner join answers on users.user_uid = answers.user_uid where users.user_uid = [user id]

you don't use a *

HTH Joe Miller
joe.miller@flotech.net

 

[Databaseguy]

And, don't forget to use the DISTINCT keyword if your query has more than one table. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy