Forum Discussion
Neuro-VISION
Feb 17, 2023Copper Contributor
DoCmd.TransferText not working in Access 2019 and neither is Stop command
I have a function that worked correctly when running the mdb under Access 2010, but it no longer works under Access 2019. In addition, the vba is ignoring the Stop command. Any help will be grea...
Feb 18, 2023
Hi,
> DoCmd.TransferText not working in Access 2019 and neither is Stop command
How does the not-working manifest itself?
Regarding Stop:
Do you by chance have deactivated the Access option "Use special keys"? If yes, that ignorance of Stop and break points is "normal", i.e. a bug for decades.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
Neuro-VISION
Feb 20, 2023Copper Contributor
Thanks for responding!
I click the command button that runs the code, but it doesn't run.
This mdb was created 24 years ago under A97. It has been greatly expanded and updated over the years to A2003 format. There are a number of other issues, so I just converted the db to an accdb format, which thankfully removed all of the user level security from the earlier mdb, and that seems to have ironed out a number of problems. Of course, the db has to be run for a while to see if there are any new bugs now.
I click the command button that runs the code, but it doesn't run.
This mdb was created 24 years ago under A97. It has been greatly expanded and updated over the years to A2003 format. There are a number of other issues, so I just converted the db to an accdb format, which thankfully removed all of the user level security from the earlier mdb, and that seems to have ironed out a number of problems. Of course, the db has to be run for a while to see if there are any new bugs now.