Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference in behavior with MSysConf table--Win 7 and Win 8 Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 8:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:43 PM
Points: 264, Visits: 164
I was planning to use the MSysConf table in a database to prevent MS Access from saving passwords to linked tables.

The client is using SS 2008 R2 and Access 2007 on Windows 7. I have been developing on Windows 8, using Access 2010 and my own dev install of SS 2012. My plan was to work out the code locally and then copy it into the client's dev environment for refinement and testing.

What I have found is that the desired behavior -- not saving passwords -- is exhibited on my own Win 7/Access 2010/ SS 2012 box, but NOT on the Win 8/Access 2010 box linked to the same SS 2012 instance.

I have several questions.

1) Is this something others have experienced?
2) Since the behavior differs, not by the SS instance, but by the client OS, am I wrong in looking at that as the problem?
3) What else could I be missing that would account for this behavior?

4) The obvious implication here, as I see it, is that this should work today on their Win 7 clients, but I am looking ahead a year or two and wondering what happens if they upgrade to Win 8 (and I know "upgrade" is a term not all might agree with)?

Thanks.

Post #1466763
Posted Monday, June 24, 2013 8:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:43 PM
Points: 264, Visits: 164
I should add that I haven't yet had time to investigate whether this is related to ODBC driver differences.
Post #1466780
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse