Selasa, 21 April 2020

Re: [MSAccessProfessionals] No longer see table properties in MS Access 365 Query

Hi jfakes,

You aren't the only one having this issue. I believe the only workaround is to go the the SQL view and add the alias there like:

FROM dbo_WO_WorkOrders AS [Work Orders]

It looks like you have rather complex queries so copying and pasting into an editor  to search and replace might help.

Sorry there isn't a solution at the moment that I am aware of.

Regards,
Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of jfakes.rm via groups.io <jfakes=rocketmail.com@groups.io>
Sent: Tuesday, April 21, 2020 8:48 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] No longer see table properties in MS Access 365 Query
 
In past editions of MS Access when I was in a query design view, I could click on the table and see certain properties such as the table name.  That way, if I wanted to change the alias to a table used more then once, I could change the name.  I no longer see that info and Access automatically names the duplicated table.

I also used to use that feature to copy the names of tables when I'm making user manuals etc.

I checked one of my databases on a computer that has Access 2013 and it works but not in a computer running Access 365.  Any suggestions?

I've attached a Word document with screenshots from both versions of Access.

Tidak ada komentar:

Posting Komentar