Deleted information

[way over my head]

I deleted tables that had relationships to my master query. Now i can only
see the master in SQL which I have no experience in. I've tried other means,
such as System Restore and downloading a free trial program which costs way
too much for my project. Is there any way to undo the modifications I have
made or reinstate the tables? Or how can change the SQL to reflect my
previous relationships, which by the way, someone else did for me?

 

[Clifford Bass via AccessMonster.com]

Hi,

Have you a backup of the database? Always make a backup before doing
something so drastic as deleting tables.

You could recreate the table, or at least the pertinant parts. Then you
should be able to go into design view of the query. Otherwise, just delete
all of the parts of the sql that deal with the table. So if the table you
deleted is named "tblA" and there is also a "tblB" in the query delete
everything that used tblA. So if the query looks like this:

select tblA.Field1, tblB.Field2
from tblA inner join tblB on tblA.Field3 = tblB.Field4
where tblA.Field6 = 123 and tblB.Field7 = 456
order by tblA.Field8, tblB.Field9;

You should end up with something like this:

select tblB.Field2
from tblB
where tblB.Field7 = 456
order by tblB.Field9;

Note that it includes the removal of some tblB items because they were
associated with tblA fields.

If you have trouble, you could post the SQL.

Clifford Bass

 

[Jerry Whittle]

Your best, probably only, hope is that you have a recent backup copy of the
database.