Forum Widgets
Latest Discussions
Access Query Finding Old/Deleted Data
I have replaced several outdated tables in an Access database recently with updated versions. The issue that is now occurring is that my queries are pulling the old data that doesn't exist anymore in the table and creating duplicate entries in my output (one row with the updated data and one row with the deleted data). Does anyone know why this happens and what the fix is? The old data isn't in my table so I'm not sure how to surface it to remove it.
"Access" does not close completely, so the further application must be closed in the task manager
If vba was used in "Access", the application no longer closes completely and must be closed in the task manager. The problem occurs on one device and the same application runs without problems on another. The problem arose with Access 2019 on windows 11. Now I have uninstalled Office 2019. But even with Office 365 the problem remains.
Query failure in Windows 11
Hi I just had a new computer at work, and changed from windows 10 to windows 11. I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1. This has been working for years, but now it, only sometimes, double all the rows. INSERT INTO MPS Columns from Table2 (Access linked to sharepoint) SELECT MPS2. Columns from table1 FROM MPS2 WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]); It compares a unik field MPSid It doubles the rows sometimes, and the MPSid is the same, in the doubled rows Has something changed, or is there a workaround? Best Regards Tony
Impossible d'installer Windows 10 22h2
Bonjour, je n’arrive pas à mettre à jour Windows 10 vers la version 22H2. À chaque tentative, j’ai le message « Des problèmes se sont produits lors de l’installation de certaines mises à jour, mais nous réessaierons plus tard. » Mon PC a un processeur AMD Ryzen 7 1700, Windows 10 version 1909 installé sur SSD et aucun antivirus tiers actif. J’ai essayé le dépanneur Windows Update, redémarré le PC et vérifié la connexion Internet et l’espace disque, tout est OK. Je voudrais savoir comment forcer la mise à jour vers Windows 10 22H2 sans perdre mes fichiers ou s’il existe une autre méthode officielle via l’outil de mise à jour ou l’ISO. Merci pour votre aide.errore nel salvataggio di maschere ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO
Da qualche giorno, a seguito di aggiornamenti, non si riesce a creare maschere e report guidati con Access. Al momento del salvataggio della maschera, compare il messaggio ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO. Faccio presente che fino a 10 giorni fa funzionava tutto perfettamente. Ho anche provato a disinstallare e reinstallare il prodotto.
Access Not Responding
I have an Access database (32 Bit) with a SQL Express backend that has been constantly Not Responding ever since Jan. 9th. There have been no programming updates to the database for a week, so it is not a programming change. Have there been any reports of Access not responding all of a sudden on a database that was working fine prior to the Windows updates installed on January 9th, 2024?Access Error on File Import through VBA
We are running a custom VBA routine in Microsoft Access that imports and parses text files into a database. Starting around September 9th, some machines began showing an error dialog during this process. The dialog mentions a failure in the VBA Regular Expression engine. The error does not occur consistently. On the same machine, the import may succeed several times and then fail (roughly 1 out of 4 attempts). The behavior appears to vary depending on the input file. The VBA code itself has been unchanged for years and continues to function correctly on older builds. We are wondering if this is related to a recent update in Access or the VBA runtime. Has anyone else encountered this behavior, and are there known workarounds or fixes? Going to leave version numbers out of this post because it keeps getting deleted and I'm not sure why. This is my 4th or 5th attempt to write this post and it keep getting auto-moderated.