TntConnect TM
Helping you build powerful connections for a lifetime of ministry...
Exploring TntConnect » Database Tools & Other Resources > Dig Deeper: TntConnect Technical Manual » Link with Microsoft Access
Link with Microsoft Access

Contents


It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Syndication

 Link with Microsoft Access

Print this Topic Previous pageReturn to chapter overviewNext page

You should only link to Access and open your database in Access if you are already familiar with using Access.

Linking database to Access

Your database does not have an automatic link to Access. You have to create it first. You can view your database in Access—and utilize that table view and export features, but unlike in previous versions of TntConnect, you cannot modify the tables or data.

Menu Path: Tools | Microsoft Access | Create New Linked Access Database




Comments on this Help Topic

Mark Konrad wrote re: Link with Microsoft Access
on 26 Mar 2015 6:08 PM

What do I do if I want to modify the data in a table? Having that option, then loosing it sets us back to square one!

Troy Wolbrink wrote re: Link with Microsoft Access
on 27 Mar 2015 7:43 PM

The ability to modify data is not completely gone.  You can open your TntMPD database directly in Access 2010 or newer and modify data in the core tables.  Just be careful!  :)

Jim_Kornelsen wrote re: Link with Microsoft Access
on 6 May 2016 5:52 PM

Since MS Office is not on my machine, I tried opening the .mpddb file with MDB Viewer Plus or LibreOffice Base.  However, they both gave the error "Not a valid password."  Using LibreOffice Base, the linked .mdb file allows read-only access as stated above.

dave.meritt wrote re: Link with Microsoft Access
on 13 Apr 2017 6:35 PM

Can we still modify data in MS access? TNT database need a password via MS access - I enter my old TNT password but it does not work

Troy Wolbrink wrote re: Link with Microsoft Access
on 20 Apr 2017 11:39 PM

The new database password is "tntMPD".

Danny DeLoach wrote re: Link with Microsoft Access
on 27 Mar 2019 3:16 PM

Thank you for including the linked Access database feature in TntConnect. It is very helpful to me.

When I create a new linked Access database and open it in Access, everything works fine. However, when I try to open the same linked Access database a day or so later, I receive the following message:

'C:\Users\Danny\AppData\Local\Temp\TntConnectTemp\tmp-A5C9.tmp' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

When this happens, I have to create a whole new linked Access database. Is there any way to have linked databases point to a permanent instance of the TntConnect database, so that I don't have to keep creating new linked databases?

Thanks.

Troy Wolbrink wrote re: Link with Microsoft Access
on 3 May 2019 6:10 PM

Hi Danny,  The links are intentionally to a copy of your TntConnect database to keep your access to the database read-only.  That's why the linked tables are not directly to your main TntConnect database.