?
Solved

Access 2000 trying to find table

Posted on 2012-03-13
4
Medium Priority
?
247 Views
Last Modified: 2012-03-13
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
Comment
Question by:bmorriso99
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 37716109
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
 

Author Comment

by:bmorriso99
ID: 37716158
How do I open the table directly?  Is there a menu option?
0
 

Author Comment

by:bmorriso99
ID: 37716172
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
 
LVL 77

Expert Comment

by:peter57r
ID: 37716188
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
The best software application must always have an error handling tool
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question