Tables with name of "Usys...."

[fredk]

In another post, someone used some code and advised to create a table named USysTBLUsers. I did so but cannot view the table. I am guessing this is because of the name.

Can someone clue me in on how to view the table. The post was regarding the creation of a user and password table so the user can log-in. I realize it is probably better to use access security but this was really an exercise in coding for me.

Thanks very much!!!!!

fred

 

[mikey69]

It's probably automatically hidden by Access and you'd have to select the option to view hidden objects

Access makes all things possible. It even makes them intelligible

 

[fredk]

Thank you very much, I will try that when I get back in the office tomorrow.

Thanks again Mikey69!

Fred

 

[fneily]

Maybe that was my post. Usys in front of table names make them "system" tables. System tables are automatically hidden from view. With your database opened, click on Tools - Options - Place a check next to System and click Apply. You'll be able to see not even your tables, but the secret microsoft access tables.

Neil

 

[fredk]

Thanks Neil - It was actually posted by quincy but he removed the "notify me" in the thread.

Thanks much for the information, that got it!

Thanks again!

Fred