[AccessD] Perhaps I'm just being a dolt...I hope!

[John W. Clark]

I just got back into this believe it or not. I had forgotten that we were off last Friday for Veterans Day, then there was the weekend, and yesterday I was quite busy with other things. I actually still have many other things to do...we're in the middle of rolling out a GroupWise to Exchange conversion...so I just wish this would go away.


As usual I am impressed with the quick and useful tips I received. I will check out the decompile a bit later and see if that helps. I'm thinking the decompile needs to be on the back-end side? I'll get a good backup and try that.


I'll have to verify but I think they are running Access 2013 downstairs. I just recently upgraded to 2016 and the problem follows the same. I believe I'd written this on 2007...not positive, but pretty sure.


I will check the PK data type as well. I don't think it is that because we are able to add data directly to the tables...just not the query, like they've done in the past. It is a great tip though because it could cause me issues down the road.


I'll check the relationships as well...did not do this yet. That tip took me by surprise as I don't generally do this. I'm normally a one-stop shop with all of this, but they basically took something I did, had one of their people alter it, and then kicked it back to me to support it. She basically stole my code and did a half-baked job of things, and then when it began having issues, she proclaimed she really didn't know what she was doing...nice! So, while I don't think it is the case, I never really know for sure, that nobody has messed with things.


Thank for the help...I really do appreciate it. I always do, but more so right now because I don't seem to have the time to explore and play.

________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Lambert Heenan <Lambert.Heenan at aig.com>
Sent: Thursday, November 10, 2016 4:53:43 PM
To: 'Access Developers discussion and problem solving'; John W. Clark
Subject: Re: [AccessD] Perhaps I'm just being a dolt...I hope!

John,

Did you try to Decompile to application? That can clear up more weirdness that Compact and Repair can...

"X:\FullPathToAccess\MSAcess.exe" "C:\FullPathToyYourFile\somefile.accdb" /decompile



Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Clark
Sent: Thursday, November 10, 2016 3:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Perhaps I'm just being a dolt...I hope!

So...just to clarify something...I did check that I can enter into tables to be sure. Yes, this can be done. Actually in that same field that brought the problem to light, a calendar comes up and you can choose a value that then goes into the field. And you can directly enter it as well.


So I guess the problem is simply, why can I not enter into queries...when I could 2-3 weeks ago?

Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation.