Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Access 2000 trying to find table

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.
0
bmorriso99
Asked:
bmorriso99
  • 2
  • 2
1 Solution
 
peter57rCommented:
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.
0
 
bmorriso99Author Commented:
How do I open the table directly?  Is there a menu option?
0
 
bmorriso99Author 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.
0
 
peter57rCommented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now