Deleting

[mam]

I have a database linked to my SQL server. I am new at
Access and made the HORRIBLE mistake of deleting a ton of
files when I ran a query. My question is... is it OK to
delete files and/or rows from forms? Will this affect the
database?

Thanks!

 

[GVaught]

Yes it will. Think of the form as just a mechanism to view the underlying
table data in a friendly format. If you deleted a ton of records from the
form you indeed deleted them permanently from the table. To get these
records back you need to pull the data from a backup copy. You do have a
backup of the SQL Server tables right? Otherwise, hope you have a good
memory as you will have to enter them again from scratch.

Most db admins prevent 'normal users' the ability of deleting a record. Only
those who have admin privileges can delete a record from the tables. You may
want to look into applying this security feature until you are more familiar
with Access and writing queries that deletes data.

 

[StCyrM]

Be careful when deleting....once the records are gone they are GONE...you may
want to get your network admin people to do a restore and start all over again,
carefully this time.