S
Scott
(Please see the above mentioned posts by Mike on 11/8 and Phone Home on 11/3
respectively and replied to by Lynn Trapp and Joan Wild..also respectively)
I would like to add a new twist here, even though this is about an old post.
I have
been recently trying to secure my Access2002 db and was having exactly the
same problems stated in this post and also phone home's earlier post. I tried
the suggetion made by phone home, and coincedence or not, it worked for me
also. I would like to thank you all for your unselfishness in helping others
over difficult spots on our journey to become access gurus such as the mvp's.
That's not the twist however. Once I imported the database, to a new database
to transfer ownership, one of my forms that runs some code when opened (it
opens a recordset based on the forms current record (employee) and populates
a section of the form with current safety training info. It does this by
building a SQL string to filter the recordset. setting part of the string to
the form's [EmployeeNo] control. In the old database code worked fine, but
now it gives me a type mismatch error. I've used a breakpoint to halt the
code just after it builds the string, printed it to the immediate window, and
copy/pasted it into the SQL view of a query builder and the query worked
fine. but as code, it doesn't. Also of note, if I link to the new
(secured)database via the /WRKGRP switch and the .mdw file, I don't get this
problem. Only if I link directly to the .mdb file does this error manifest
itself. I've checked the control of the form as well as the table field and
they both match in type as well as size. Any ideas on why this is happening?
sorry for such a long post, but I wanted to give as much info as I could w/o
going totally overboard.
Thanks in advance!
respectively and replied to by Lynn Trapp and Joan Wild..also respectively)
I would like to add a new twist here, even though this is about an old post.
I have
been recently trying to secure my Access2002 db and was having exactly the
same problems stated in this post and also phone home's earlier post. I tried
the suggetion made by phone home, and coincedence or not, it worked for me
also. I would like to thank you all for your unselfishness in helping others
over difficult spots on our journey to become access gurus such as the mvp's.
That's not the twist however. Once I imported the database, to a new database
to transfer ownership, one of my forms that runs some code when opened (it
opens a recordset based on the forms current record (employee) and populates
a section of the form with current safety training info. It does this by
building a SQL string to filter the recordset. setting part of the string to
the form's [EmployeeNo] control. In the old database code worked fine, but
now it gives me a type mismatch error. I've used a breakpoint to halt the
code just after it builds the string, printed it to the immediate window, and
copy/pasted it into the SQL view of a query builder and the query worked
fine. but as code, it doesn't. Also of note, if I link to the new
(secured)database via the /WRKGRP switch and the .mdw file, I don't get this
problem. Only if I link directly to the .mdb file does this error manifest
itself. I've checked the control of the form as well as the table field and
they both match in type as well as size. Any ideas on why this is happening?
sorry for such a long post, but I wanted to give as much info as I could w/o
going totally overboard.
Thanks in advance!