May 29 2022 05:06 AM - edited May 29 2022 10:04 PM
I have update today to the may release 16.0.15225.20204 - now i have Problems to start our Access Runtime Application. I get a message 3167 Record has delete - but their is no Record deleted.
After this there is a message - to complex.
This Problem exists ownly by the accde file - the Database accdb runs correct -
> Problem exists on both Files
May 29 2022 08:30 AM
"This Problem exists ownly by the accde file - the Database accdb runs correct"
Does it help if you create a NEW accde from the current accdb?
May 29 2022 10:01 PM
- I found the Problem - this Release has a Problem to use an SQL-Server table with a Primary Key of three fields (integer, nvarchar, nvarchar). In all older Versions this works in the new version it work not. The Tableview in Access shows all rows but each row shows the entry record deleted.
Workaround:
I changed the Fields to varchar an use another PrimaryKey. Now it works.
May 30 2022 05:58 AM
May 30 2022 06:37 AM
Hi,
I think i have a similar problem but relinking the table is not enough.
I can not access my tables if the primary key is a varchar.
For the moment my only issue is to add a serial , make it the primary key and add a unique constraint corresponding to my former primary key ...
The problem seems to be linked to the last update (Version 2205 build 16.0.15225.20172-64bits)
Is the problem identified by Office team ?
Thank you for your response
May 30 2022 06:48 AM
Yes, this newest bug release is widely discussed in several forums.
I didn't know that it impacted the runtime as well, but version 2205 has this and other problems.
The solutions include changing the Primary Key fields from NVARCHAR to VARCHAR, or preferably, to an Identity integer or even to a sequence (which is what you did I suspect?)
Also, it has been confirmed that ODBC drivers for SQL Server 17 and 18 are not impacted by this problem.
May 30 2022 07:10 AM
May 30 2022 07:20 AM
May 30 2022 07:24 AM - edited May 30 2022 08:03 AM
Jun 03 2022 07:32 AM
Jun 03 2022 01:11 PM
Jun 06 2022 07:42 AM
where is link? I need this badly. thanks
Jun 06 2022 07:52 AM
"It does not require a new build but will require closing and restarting Access to see the change. In other words, the fix was done by rolling back the change that caused the problem"
Jun 06 2022 07:57 AM
Jun 06 2022 08:35 AM - edited Jun 06 2022 08:36 AM
not true odbc SQL Server 17 driver still giving me #deleted
Jun 07 2022 12:07 AM
Hi,
I have Microsoft Access Version 2205 Build 16.0.15225.20172 64bits version
Since friday it works again for me with sql server and with postgresql
Best regards
Jun 07 2022 06:05 AM - edited Jun 07 2022 06:08 AM
I am using 365 Access Version 2205 Build 16.0.15225.20204 (both 32-bit & 64-bit)
My experience (backed up by the MS Access team) is that anyone using the SQL Server 17 driver was unaffected by last week's #DELETED bug. Indeed it was one of the recommended workrounds before the fix was released
However, it sounds like your issue is unrelated,
There are other reasons why records may be shown as #DELETED.
Jun 07 2022 10:49 AM
Perhaps, then, you are being impacted by a different problem. Sorry, but in the flurry of reports about this bug, it is easy to assume such problems are all caused by it.
If your tables worked properly up until the day of the update, it's hard to think of any other reason, though.
Can you delete and relink the tables? When you do that, do it in a back up copy of the accdb.
Make sure that all tables have a valid Primary Key and that you designate it as the Primary Key if Access asks you to do that. If any of those Primary Keys are of NVarchar datatype, this bug did impact such tables. Again, if your tables use such NVarchar datatype fields as Primary Keys, and relinking doesn't correct the problem when linked using ODBC Driver 17 or 18, then there could be some other, yet to be determined problem.
Jun 07 2022 10:51 AM
Jun 07 2022 10:56 AM