Restore file-go back

[Guest]

I accidently deleted one table in my database. The table was called
"departments" and only has about 10 entries. It was mostly used for a drop
down in other forms of the database. I have a queries that uses it also.
When I run the "dependency" option, since the table is not there it shows
"missing". Is there a way to restore my file to yesterday? If not, can I
recreate the table so that it links back to my existing data? I know enough
about access to just get me in trouble. Again the table was a short list, but
I don't know how to go about setting up the relationships correctly.

 

[John W. Vinson]

Is there a way to restore my file to yesterday?

If you have a current backup, yes; just restore it. However Access doesn't
keep backups for you - deleted is GONE. It's good practice to keep daily (or
more frequent) backups of every file that you think you'll need... and keep
several generations (you might have deleted the table last week, not
yesterday!)

If not, can I
recreate the table so that it links back to my existing data? I know enough
about access to just get me in trouble. Again the table was a short list, but
I don't know how to go about setting up the relationships correctly.

Create the table, enter the data into it, and then use the Relationships
window (the icon looks like three little datasheets joined by lines). Use the
Add Table icon to add this table, and drag its primary key to the foriegn key
field in each table to which it should be related.

John W. Vinson [MVP]

 

[Guest]

I thought my company was taking care of the backups on a daily basis, oh
well! I was able to follow your step two and just re-create the table. I
think I have the relationships back to where they belong. I guess from here

 

[John W. Vinson]

I thought my company was taking care of the backups on a daily basis, oh
well!

They might be, if the database is on a shared folder on the network... or
*maybe* even if it's in a shared folder on your PC. You'ld need to talk to
your IT department to find out if and where it is.

John W. Vinson [MVP]