09-06-2011 12:50 PM
I'm trying to access Premium ACT 2011 via OLEDB or ODBC so I can export notes and history, and I keep getting- Act Data Link Error Invalid/Inactive Username and Password.
I've tried this with excel, magic DB and Open office Base, same results.
I've verified the username and password are right.
I rebooted the server to make sure noone else was in there while I tried it.
I went to ACTdiag on the server and it says Unlocked.
09-06-2011 12:56 PM
Are you using the ACTReader?
09-06-2011 01:07 PM
it's local as in on the same LAN, but I didn't try on the server itself (because in this forum, a helpful poster said the data extraction only works on a workstation)
i can connect successfully to a test db in the same server/shared folder, etc
thanks for the lightning quick response
09-07-2011 10:25 PM
09-08-2011 01:09 PM
thanks for suggestion
i tried this and still unable to connect
i don't know how to get reader, we have 2011 premium
any other ideas?
09-08-2011 01:26 PM
09-14-2011 07:17 AM
I have tried other logins, and I did follow the prescribed method.
Nothing worked until I restored a copy of the backup, called it something different in a different location on the server. Then, all is good.
Any ideas why?
09-15-2011 06:58 AM
09-15-2011 08:15 AM
we have a ton of customized fields, is that what you mean?
so what should i do with the original DB - is there some danger there if there is corruption?