Forum Widgets
Latest Discussions
Access Abfrage Schaltfläche Ausführen! deaktiviert
Seit Tagen ärgere ich mich in Access über den folgenden Sachverhalt: Ich habe eine DB erstellt. Ich habe eine Abfrage über den Abfrageentwurf erstellt. Dies funktioniert korrekt. Wenn ich jedoch im Abfrageentwurf die Schaltfläche "Ausführen!" betätigen will, ist diese deaktiviert. Microsoft Support ist nicht in der Lage oder Willens diesen defect zu beheben. Ich habe dieses Problem schon in der Tech Community aufgeschaltet, erhielt die verschiedensten Antworten. Ich erhielt den Rat im untenstehenden HKEY die Anpassung vorzunehmen. Schon der der Ordner Access Connectivity etc. fehlt auf meinem Rechner... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office[Version]\Access Connectivity Engine\Engines\SandBoxMode
Troubleshooting Queries in Access
Hi All, I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected. As per the set-up process, 1. Have deleted old tables (with previous data), and imported new data for these tables from a different Access database 2. Then I am doing a compact and repair. 3. Then I am running query that is expected to populate the table, I see no records are added to the table Could this be a file reference issue **or** lack of data **or** missing tables /steps **or** a connection within Access. Appreciate step by step process to diagnose the issue
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
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.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?
