B
Brad Pears
Something strange is all of a sudden going on...
I have an Access 2000 project on my local machine. It is the development
copy of a live DB. I have not made any changes to this app in a while but
today I have some changes to make in there...
I logged into the app using the same username and password I always have and
go to a query to open in "Design" view. When I click "design" it opens in
SQL view - NOT deisgn view. If I attempt to switch to design view, I get an
error indicating "Not a valid password" and that is it. I try some other
queries, some are fine and others I get the same thing. I try "design" mode
in some forms and they appear to be all ok. I even imported from the Live
database the query in question I am having issues with - thinking that maybe
the ciorruptin is with the query itself. After importing it, I get the same
error.
Query design mode for the exact same query works fine when I do it in the
live database. I am also currently pointing to the same workgroup
information file as well - that the live DB is...
I tried copying the SQL clause for the query I was having the problem with
over to a new query and just rename it. I was able to add the new query and
run it but can NOT go into "design" view at all. I get the same error
message!! I can also create a new query in design view.
It appears to be some sort of corruption somewhere. I also tried a compact
and repair but that did not solve the issue. Is the .mdb file somehow
puked?? There are a lot of on-going changes in the design db that I do not
yet have over in the live db that I really do not want to lose!
Has anyone got this before? What can I try to fix it?
Thanks,
Brad
I have an Access 2000 project on my local machine. It is the development
copy of a live DB. I have not made any changes to this app in a while but
today I have some changes to make in there...
I logged into the app using the same username and password I always have and
go to a query to open in "Design" view. When I click "design" it opens in
SQL view - NOT deisgn view. If I attempt to switch to design view, I get an
error indicating "Not a valid password" and that is it. I try some other
queries, some are fine and others I get the same thing. I try "design" mode
in some forms and they appear to be all ok. I even imported from the Live
database the query in question I am having issues with - thinking that maybe
the ciorruptin is with the query itself. After importing it, I get the same
error.
Query design mode for the exact same query works fine when I do it in the
live database. I am also currently pointing to the same workgroup
information file as well - that the live DB is...
I tried copying the SQL clause for the query I was having the problem with
over to a new query and just rename it. I was able to add the new query and
run it but can NOT go into "design" view at all. I get the same error
message!! I can also create a new query in design view.
It appears to be some sort of corruption somewhere. I also tried a compact
and repair but that did not solve the issue. Is the .mdb file somehow
puked?? There are a lot of on-going changes in the design db that I do not
yet have over in the live db that I really do not want to lose!
Has anyone got this before? What can I try to fix it?
Thanks,
Brad