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!
I'm attempting to insert new records into the database. The ID fields are all full of some long ID number. Can you provide a reference to where this ID number comes from and if it's safe to just insert a unique number into this field?
It can be anything as long as it's unique. I believe Access has a Rnd() function that could be utilized.
The documentation for adding an add-on to the Tools menu should clarify that the "currentgroup.csv" tag should be added to a Parameters key instead of included in with Target. Including it with Target will give you an error about specified file not found.
I am using TntConnect 3.1 r14. When I create a linked Access database, the links point to a database in the directory: "C:\Users\danny\AppData\Local\Temp\TntConnectTemp\". The temporary database in this directory does not update, when data in my TntConnect database is updated. When I use the Linked Table Manager in MS Access to point the links to my actual TntConnect database (i.e. my .mpddb file), I receive the error, "Not a valid password".
I tried entering the password that I used in TntConnect back when it used to encrypt the database, but that didn't work. To troubleshoot further, I created a new database in TntConnect (i.e. from File | New... in TntConnect). When I try to link to this new database, I receive the same, "Not a valid password" error.
How do I resolve these issues, so that I can create functional links to my TntConnect database? Thanks.
Hi Danny, TntConnect creates a read-only snapshot for your linked database to refer to. If you want to change data in TntConnect, you can run action queries from that database within TntConnect, but you can't refer to tables in your linked database.
If you want to use the Linked Table Manager in Access, the password for a TntConnect database is "tntMPD".