A bad day with Access, is it only me?

[KitaYama]

I wanted to reply in a different way, but it seems that @CJ_London already said what I wanted to say. So no need to repeat.

I think you have three options here.
1- Abondon Access just like what you did 10 years ago and go back to all other tools you used during those years for your application.
2- Allow Access to do whatever it wants to your outlook folder. After all , I don't think it will send your mail contents to Microsoft.
3- Uninstall all office applications and clean install everything.

I really don't see a fourth option here.

 

[GPGeorge]

It may be the only case where some other error is triggering the reported error. We have no way of knowing without some serious digging as to whether ANY of the Office elements are passing back data, or how.

That's the point I was getting at in my inelegant way. This appears to be a singular case, not a common problem, based on the sparsity of inquiries about it.

Moreover, the time and effort required to dig into it seems like something only a truly dedicated person would invest otherwise. Heck, why would anyone even think to do it before reading this discussion? Would anyone ask if Access is somehow interfering with Outlook, or vice versa, if they had never seen or heard of it happening? There are lots of well known problems in need of understanding and resolution without coming up with new--potentially hypothetical--scenarios to investigate.

On the other hand, there are a handful of Access pros who probably would be happy to invest that time investigating the possibility of a problem, if the incentive is there. The challenge has been laid down. If someone has the time, knowledge and energy to devote to it, knowing that it is, at best, a singular reported case, let them have at it.

 

[NauticalGent]

Although not surprised, I am intrigued that NO ONE has asked the OP for a copy of the DB for troubleshooting. If they have, sorry I missed it...

 

[KitaYama]

Although not surprised, I am intrigued that NO ONE has asked the OP for a copy of the DB for troubleshooting. If they have, sorry I missed it...

In several occasions, OP has claimed opening a blank new database has the same effect. #66 above is one of those cases.
So, it's not a per database problem.

 

[AccessBlaster]

I wanted to reply in a different way, but it seems that @CJ_London already said what I wanted to say. So no need to repeat.

I think you have three options here.
1- Abondon Access just like what you did 10 years ago and go back to all other tools you used during those years for your application.
2- Allow Access to do whatever it wants to your outlook folder. After all , I don't think it will send your mail contents to Microsoft.
3- Uninstall all office applications and clean install everything.

I really don't see a fourth option here.

I would probably resort to #3, it would bug me if the symptoms presented.

 

[CJ_London]

but I do think it is a peculiarity of the OP's windows/office setup - evidence: a) no one else is aware of a problem, b) OP has a penchant for trying to do things in a way that fits his model of the world rather than the model defined by access/windows etc. so may have unknowingly altered something somewhere to cause the problem. The one suggestion which would prove or deny this has been rejected - to do a complete reinstall.

This comment in particular 'Bought an on-line licensed Office Pro product key from a reputable source.' gives me pause for thought. In my experience the only reputable source is Microsoft. The key gets referenced twice, once on install and again on registration

 

[spaLOGICng]

The last 24 hours have been hell day with Access 2021. I had burps, crashes, and contaminated data and tables, queries and forms. In multiple dbs.

It all reminds me of my first experience with Access almost thirty years ago, when I first walked away from it. Maybe I'm doing things all wrong, but if that's the case, why does Access permit it?

First, I had another, maybe the 10th this week, where the db(s) just hung and nothing would move, just a bell that kept dinging.
So I had to end it with task manager. But then I opened it up and ran the compact/repair and things seemed okay.
A little later, as it's done many times recently, it just shuts down after a pause and forces a backup, no explanation given.
After that I saw some data in a table that had been corrupted with strange characters in several records.

I had changed some field names from within the relationship view, and everything seemed good. I exported tables, queries and reports to another db. Things ran, then I made a .accde, it went through its steps, but when I tried to run the .accde, there were errors asking for parameter values. Digging deeper, I found that some of the field names I changed had corrupted the queries and forms with new sources for the data source properties.

I know how to reset and stop a running VBA procedure that's stopped for an error, and that wasn't the case in these problems.

Is it just me, or are others seeing these kinds of errors? It's not a complicated db, I'm just doing some simple reports and coding.

Hi,

I am sorry that you are having such a terrible experience with Access. I cannot comment without great detail. Maybe it is something that you are doing wrong. Since the issue persists, I recommend that you hand the DB over to a second set of eyes. I freelance on Upwork and I am often that second set of eyes to determine where the gaps are in an application. I believe your issue is more technical that what is known here. But I will tell you this, it is not access.

In my experience however, the biggest reason for crashes are where an Access Table has an Autonumber Field and it has lost its seeding Value. The seeding value issue a lot of times begins when Records are Deleted. I cannot explain why, but it is also my opinion that this has stabilized over the years to where I feel confident about using Autonumber Fields again. Nowadays, I prefer SQL Server as a Backend over Access, even if it is SQL Express.

As for the naming of things, it is very important NOT to use reserved words or special characters for Table Names, Field Names, Query Names, Form Names, Control Names, Report Names or their Control Names. Avoid using the word "Name" at all cost.

I DO use the Auto-correct Features for development. The Auto-correct does not catch everything, but most of it. I have learned to build DBA/Developer Tools over the years that I have incorporate as a Template where I begin with everything. It is kind of dirty and is why I do not resale it, but might behoove you to build your own tools. My tools let me change the name of anything in any query. It allows me to quick find "Expr" expressions that were previously a Column Name. I can also search for any Control in any Form or Report.

Lastly one of the biggest cause for Expr Expressions in Queries is caused when Objects are copied from one DB to another, where a dependent Object was pasted later. A Query is dependent on "Table A" for instance, and the Query is pasted into the DB before Table A is. The Query does not know what table to bind to and therefore creates the expressions.

So consider giving it over to a second set of eyes and let them consult you on best practices once they discover where or what the issues are.

 

[The_Doc_Man]

Problems start. It's possible that the install files were corrupted by some kind of malware that wants to steal my contacts or some such thing, but those install files came directly from Microsoft, so I rule that out as highly unlikely.

That is actually not that hard to pursue if you have a decent anti-viral package that can operate in Windows "Safe" mode (which requires a reboot to get there, of course.) If your A/V system supports it, you need to do a full (whole-disk) scan in Safe mode.

I also have to ask you if you have looked at the exercise I offered in post #55 which requires you to play a little bit with Task Manager to get to Resource Manager, and which later requires you to enter debug mode with code stopped for a breakpoint so you can explore items in the Locals Window. It might look a bit tedious, but the Locals Window stuff takes a few seconds to get to the Recordsets collection. Admittedly, the exercise for Resource Manager can be a bit tedious, too. But if you do it when an Anti-Viral package is NOT scanning and your browser is NOT open and no other apps are open, ... should be easy.

One last thought: Security. If you are getting these errors, check the event logs. There is a Security log that might tell you something about the events in question including telling you the specific file reference AND the image name and maybe a supplemental library file or module name that is responsible for the error. Event Viewer is under Windows Administrative Tools, or you can just click the Start icon at lower left and type EVTVWR and hit enter. Browse through the available logs listed on the left. It helps if you have a specific time and date for one of these events where you get that message, because events in the viewer are sorted chronologically and thus it is easy to find the event.

CJ's comment reminds me that some products do funky things if they are not legitimately installed. (I.e. you thought you had a good key but you don't, so the products won't play together.) As to your license key, look at the 2nd and 3rd items in this link. The 1st item requires you to download something and I'm not suggesting that.

How to Find a Windows 11 or 10 Product Key

You might need the key to install Windows elsewhere.

www.tomshardware.com

Here is a link for on-line validation of your Windows key.

Redirecting

 

[NauticalGent]

I have experienced something similar to what the OP is experiencing in regards Access "reaching out and touching Outlook" which I will share with you all.

O365
Linked SP lists as BE

What happens:
If I do not have Outlook started and I start up my app, in my Hidden Icons portion of the system tray, I see a small Outlook Icon (screen shot attached). If I hover over it, a message appears, please see second screen shot.

The icon stays in the tray until I close my app.

Not sure if this is something new but I just now noticed it. I have been able to recreate this situation about 10 times in a row, so I am confident this isn't a fluke.

Why it is happening:
When the start-up form loads, I have a function that determines the user's email address ("GetEmailAddress()"), which uses the Outlook.NameSpace and Outlook.Folder objects

If Outlook cannot connect to the server - the user cannot be validated and I have code that informs the user that there is a problem with Outlook and to contact the J6 (IT dept) - without that "catch" there is an error message and the app WOULD shut down IF I did not have a trap for it when it is me logging in. Everyone else would get bounced out rudely.

If I comment out the GetEmailAddress call, no Icon in the systray.

In summary, as others have said: Access WILL reach out to external apps - but ONLY when told to do so.