deleting from a table in a 'shared environment

[Ssstacey]

Hi,
Im working on a database that has to be shared by 3 or 4 users. In on of the actions that the database performs, it has to delete records from a table first.
When sharing the database, it always asks the users (using access viewer) whether 'they are sure that the want to delete the records'. Does this always happen? And why? How can I get rid of it? Would it matter if I change it from a table to a query?

Thanx,
Stacey

 

[ghudson]

You just need to turn the warnings off.

DoCmd.SetWarnings = False
'your delete code here
DoCmd.SetWarnings = True 'Ensure that you turn them back on!

 

[Ssstacey]

Thank you.. I will try it out later..

 

[Ssstacey]

Im not sure if Im running a query in VBA. Im using VBA to perform certain calculations. How do I implement the .execute method?