A2003 Msysxxxxxx tables

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

How do I suppress the display of the Msysxxxx tables
from the database tables directory display. I don't know
what role, if any, they play with the other various tables,
reports, queries, etc. that might be a part of my application.
But, from what I can tell on the surface of things, they are
of no consequence to me.
 
Hi, Bill.
How do I suppress the display of the Msysxxxx tables
from the database tables directory display.
Click to expand...

Those are the system tables, and you don't really need to see them, but they
do need to be there in order for your database to function normally. To
avoid displaying them in the Database Window, select the Tools -> Options...
menu and select the "View" tab. Uncheck the Show System Objects check box
in the upper right of the window, then select the "OK" button to save your
change.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Thanks Gunny, I had just stumbled onto that as I was looking
to answer another question as to why when I build a new form
using the wizard that my text boxes display with the up/down
arrows? I couldn't see anything in the text box format properties
that indicated vertical scroll bars for each box?????
Bill
 
Hi, Bill.
why when I build a new form
using the wizard that my text boxes display with the up/down
arrows?
Click to expand...

That happens when the field size property of the column is large. Remove
the scroll bars by opening the form in Design View, then selecting the text
box and opening the Properties dialog window. Select the "Format" tab and
change the Scroll Bars Property to None. Save the form and open it in Form
View.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
That one must have just gotten by me, as that was the first
place I had looked...........been a long day, SIGH!
Thanks,
Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
A2003 and Visual Source Safe 8
A2003 bringing in data from an Excel spreadsheet 1
Table design question 8
Programming a result field in a table 5
Linked Tables and SQL Server permissions 3
Access Dynamic/Crosstab Form 0
FORM DOES NOT POPULATE WITH A2007 1

Back
Top