Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table names being shortened in db window, list view

Status
Not open for further replies.
VickyC

VickyC

Technical User
Sep 25, 2010
206
CA
hi to all.

I have thousands of reference tables with names like tRef__nOT_4_sOTX_12_v23. These are stored in multiple MS Access 2002 mdb files.

Recently, a problem has arisen, and I think it may have happened when I switched from Windows 7 to Windows 10 (not sure).

Here's the problem: The table names (in the db window, list view, have been truncated. The example above looks like tRef__nOT_4_sOTX_12... The name is still there, and the tables still function properly, but I now have MULTIPLE tables that ALL look like tRef__nOT_4_sOTX_12...

Is there any way to allow the full names to be seen?

For what its worth, NOT ALL table name's have been shortened. Some of the older ones that I haven't accessed are much longer. Maybe a Registry setting?
 
Sort by date Sort by votes
If you can't change the table names, create queries and name them with shortened versions of the names. Don't put any criterion in the queries, just use them to build off so you can see the names.
 
Upvote 0 Downvote
Can you not widen the viewport?

access_cybubf.png


Click, hold, drag.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
776
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
542
dhookom
dhookom
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
580
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Prevent new data being used when using Archive backend
Replies
0
Views
4K
TrekBiker
TrekBiker
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
942
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top