Recent content by barnstorm

You have to be clear if it a Database Password ( which I guess it is) or a Security password Here's how to do it in ADO Dim cnn as ADODB.Connection strPass = "DeadParrot" strDB = "C:\Work\MyWind.mdb" Set cnn = New ADODB.Connection With cnn .Provider =...

Hello to everyone who has replied The company that maintains the installation (nothing to do with me) has gone through a virus removal procedure on this PC and detected FOUR different viruses on the system. On cleaning it the problem has gone away. Sorry to waste everyone's time - but we all...

Thanx everyone for the feedback CCLINT - The problem originally occurred in an mde library However in my noddy database I tried the function in a library, in a module, and in the form's own code. none worked - just event procedures. The function is exceptionally simple and does not use SQL. It...

Hi Folks I have a very odd one I have an Access 97 MDB application. It has all been working fine for over a year - upwards of 10 users. Suddenly one user starts getting errors. On investigating I find that event procedures and calls from code are working fine. What is not working is calls to...

Hi Folks I have a very odd one I have an Access 97 MDB application. It has all been working fine for over a year - upwards of 10 users. Suddenly one user starts getting errors. On investigating I find that event procedures and calls from code are working fine. What is not working is calls to...