We help IT Professionals succeed at work.

Access 2000 trying to find table

bmorriso99
bmorriso99 asked
on
I am fairly new to access 2000. There is a form and there is a select on a table that populates the form (I can see this by going into the form in design mode and right clicking on a part of the form and saying 'properties' and then under the ALL tab under Row source it says 'SElect tablename.* from tablename').  How do I remove a row from tablename? I can't even get to it... I don't know how? It does not appear to be a linked table because when I go to the linked table manager it tells me that there are no linked tables.
Comment
Watch Question

BRONZE EXPERT
Commented:
You should be able to open the table directly and scroll through the records.    You can delete an entire record by clicking in the left Record Selector margin and then pressing the Delete key on your keyboard.

I suggest you take a backup first.

Author

Commented:
How do I open the table directly?  Is there a menu option?

Author

Commented:
OK - I found an icon on the toolbar called 'database window' when I click on that it brings up the table information. Thank-you.
BRONZE EXPERT

Commented:
Do you see the database window when you open the database?
If not, try opening it while you have the Shift key pressed down.
Capture2.JPG

Explore More ContentExplore courses, solutions, and other research materials related to this topic.