[AccessD] Password Protected Back End

[Rocky Smolin]

No I don't want to go to ADO - too much rewrite - they're in a deep sweat to
cross the finish line.  I know this woks in the other app.  I just can't
remember how I did it (old guy, you know).

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Tuesday, October 13, 2015 6:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Password Protected Back End

Can you use ADO, set up a credentialed  connection object, run the queries
to populate the controls and work with them unbound?

Other than that I actually thought you just set up linked tables in the
front end in lieu of direct access to the backend. I have heard that stores
the password somewhere in the system tables, which might be undesirable for
you. But sounds like you have tried that and it isn't working for you.
On Oct 13, 2015 7:18 PM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:

> Dear List:
>
> A few years back I password protected a back end and made the 
> appropriate changes in the VBA to accommodate.  Mostly where I Set db 
> = CurrentDb, I
> substituted:
>
>     Dim wrkJet As Workspace
>     Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
>     Set db = DBEngine.OpenDatabase(gstrDB, False, False, ";pwd=avery")
>
> which worked just fine.  So now I have to do the same thing for 
> another app and after making that change in the opening form, 
> everything seems to work fine.
>
> Except the combo box with the user names is blank and when I ran the 
> query that's the Row Source for that combo box I get the error "Not a 
> Valid Password".
>
> So I combed through the first app to see what I might have done 
> differently but can't find anything. That error is global to all the 
> queries in the app.
> And all of the forms give that error and in design view all the bound 
> text boxes have an invalid control source.
>
> Trying to relink the tables using the linked table manager I get the 
> same result.  Won't link - "Not a valid password"
>
> So, there's something my senior brain can't remember about how I got 
> all these object to recognize the back end.  Anybody know what I need to
do?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus