hydrazi
asked on
DACEasy Autologin
Hello,
I have been successful in creating and ODBC link between an Access database and DACEasy data. I want to implement this connection for several users excpt there is one issue.
When running a query that involves these tables linked to DACEasy, we get a Username and Password prompt. Regular users do not work, only Admin level users work. Is there a way I can pre-specify or auto-logon with this? Or create a user that cannot logon to DACEasy but has the rights to link to these tables?
It's runnng a Pervasive 9 engine.
I have been successful in creating and ODBC link between an Access database and DACEasy data. I want to implement this connection for several users excpt there is one issue.
When running a query that involves these tables linked to DACEasy, we get a Username and Password prompt. Regular users do not work, only Admin level users work. Is there a way I can pre-specify or auto-logon with this? Or create a user that cannot logon to DACEasy but has the rights to link to these tables?
It's runnng a Pervasive 9 engine.
ASKER
There is no such area for these options in the ODBC link, as far as I can tell.
Open your query in MSAccess and switch to the "Design View", select from the View Menu the item Properties, and you should see a dialog box with the ODBC Connect String in it.
If you are Using Access 2007, open the query, switch to Design View, then go to the Database Tools menu and click on "Property Sheet".
The default ODBC Connect String should just be "ODBC;". Change it to the string indicated above.
If you are Using Access 2007, open the query, switch to Design View, then go to the Database Tools menu and click on "Property Sheet".
The default ODBC Connect String should just be "ODBC;". Change it to the string indicated above.
ASKER
Ok, interesting. I could not find this, but then realized I had linked in 2 tables from the DAC database then ran the query from the tables soooo... the ODBC link should be in the design view properties of the tables. I found the ODBC screen and added in the UID and PWD items... but it didn't work. And then when I go look at the string it has changed back, excluding anything I typed in.
ASKER
Ok, interesting. I could not find this, but then realized I had linked in 2 tables from the DAC database then ran the query from the tables soooo... the ODBC link should be in the design view properties of the tables. I found the ODBC screen and added in the UID and PWD items... but it didn't work. And then when I go look at the string it has changed back, excluding anything I typed in.
Actually, no. The odbc data string that I was talking about is in the design view of the QUERY.
ASKER
There is no ODBC string in the query.
I've only got cell phone access to EE until Thursday.
I will build you a complete step-by-step with pictures when I can get some screenshots. Please confirm the version of Access that you are using so the screens make sense.
ASKER
We are using Access 2003. Awesome, many thanks to you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome, I will give his a try tonight! Thank you so much!
ASKER
Honestly.... this was an awesome solution!
DSN=dsnname;UID=username;P
If you set this up separately on queries, then you open the query in design mode, select View/Properties from the menu, and look for the ODBC connect string there.