Linked tables don't appear to be (3 Viewers)

[isladogs]

That should be Database field in MSysObjects (not property). Similarly for the Connect field (not Connection property).

 

[Ken Sheridan]

Don't think I've placed it in a trusted location. When I opened it in the first place it says it was read only and to save it with a different name. I did, to my documents folder and ran it from there

You can see the current trusted locations from Access with File | Options | Trust Center | Trust Center Settings | Trusted Locations. It is likely that your Documents folder and its sub-folders are set as trusted locations, which is why you were able to open the file once you'd moved it to there.

 

[ryetee]

If your linked table is SQL Server or other RDBMS, the link to the table will be in the Connection property.
If your linked table is anything else, the link to the table will be in the Database property because it is a file name. So links to spreadsheets and text files are stored here also.
If you download the database (FE) from the internet, you end up with other security concerns and that causes the "save as" dialog.

ok i'm all sorted now. there was an issue created by july's update that was corrected by the one in august

 

[ryetee]

You can see the current trusted locations from Access with File | Options | Trust Center | Trust Center Settings | Trusted Locations. It is likely that your Documents folder and its sub-folders are set as trusted locations, which is why you were able to open the file once you'd moved it to there.

Thanks copied parts of your code. Had to changed a bit to fit my system and all is working so thanks for the help.