Password request on form?

[gbshahaq]

i have a curious and annoying problem

I have a Access 2000 db, been working fine for 6 months+ and suddenly today, two out of three forms give "not a valid password" error on trying to open them.

There has never been a password set on the db, nor on the forms - and the same user who used it successfully yesterday now gets this error, along with any other users.

What has happened and how do i fix it? All ideas welcome!!

Sham

 

[dopedealer]

Have you tried Debugging it? Use the Code Builder to see where the error is, for all you know it could be a network services error or a disk error.
Chris

 

[gbshahaq]

the error is on opening the form.
my "start" form opens fine - then comes with runtime error 3031 - not a valid password - on opening either of my two other forms (both bound to a table).

on opening from the db window, i also get the "not a valid password" error - no **** prompt for a pword though

tried debugging - no errors found. tried compact-repair - no difference.

 

[dopedealer]

Is your database split into Fe Be? If so does the Be reside on another server?
Post your database, someone will have a look and get back to you.
Chris

 

[gbshahaq]

found the problem....

....user error (me!)

one of my tables is linked to a database which i passworded yesterday....makes sense now.

thanks for extending the offer to help - i would not have realised my elementary error if i hadn't tried to convert the linked table to an imported one to post here...



sham

 

[dopedealer]

happens all the time.