Deleting

  • Thread starter Thread starter mam
  • Start date Start date
M

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!
 
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.
 
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.
 
Back
Top