Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dorourke

    Check User Password exists in MSAccess

    Stuart Your Defalut "Password" would have worked well but I found a "work around" Although the password in MSysAccounts is encrypted and, as you correctly stated even a nul value is not null. What i did find is that all null passwords have the same encryption and therefore set up a query to...
  2. dorourke

    Check User Password exists in MSAccess

    Thanks Ideally what I wanted to do was, when a user logs onto the system the program checks if tat user has a password set (and if not runs a change password form) I was thinking along the lines of checking the MSysAccounts file for the esistance of a password for the CurrentUser. Is there...
  3. dorourke

    Check User Password exists in MSAccess

    Thanks, but i was thinking more along the lines of a "if user password exists then...." that way it it doesn't exist we can force them to open the change password routine we have already installed Any ideas?
  4. dorourke

    Check User Password exists in MSAccess

    Hi Can anyone tell me what the VBA scripting is to check if a current user has set a password or the password is blank. We set up new users with a "blank" password and ask them to enter a password (using change password scripting) but this is uncontrolled and want to forse them to replace...
  5. dorourke

    Updating a linked excel table error

    Thanks for the info, I had heard this before and that was why we were running older versions. However, up until three weeks ago we were running three older versions of access as follows; v 2002 (10.2627.8639) SP3 v 2003 (11.6566.1832) SP2 V 2002 (10.2627.2625) The first two versions now...
  6. dorourke

    Updating a linked excel table error

    The upgraded to office XP appears to loset some functionallity which has not been resolved with the 2007 version. Previously I have been able to update records in a linked excel table with a simple query update, however Access XP does not seem to allow this, returning the error "cannot...
  7. dorourke

    Update linked excel table records with Access XP

    I have upgraded to office XP and have lost some functionallity. Previously I have been able to update records in a linked excel table with a simple query update, however Access XP does not seem to allow this, returning the error "cannot update'(expression)'; field not updateable," How do I...
  8. dorourke

    TransferDatabase

    Hi I am running front end databased (A) linked to a backend database (B) I need to issue a command to import a database table into the backend database (B) whilst in the front end (A) I assume the use of the transferdatabase command, but how do i get it to import the data into a different...

Part and Inventory Search

Back
Top