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 TonyImpossible 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.
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.
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 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.
Access Still Struggles on Data Import
More of a comment than anything else I have been a frequent flyer of Access since version 2.0. We used it almost daily for several years. I have since retired, and was away from it for a couple years now. However, due to a recent Office 365 account I started using again. One of the problems we had over the years with Access was on large data imports. This appears to be the same problem today as it was 30 years ago. Excel does not have this problem. Some of the same issues with Access "Does not recognize header name" Checking to insure header name was not a keyword and all rules were enforced, still did not allow the data to be imported. Since I needed to quickly turn around the information I had to link to an Excel file and run the queries. Pondering if MS has really done any improvments or serious upgrades with Access. I know programs cost resources to update. The other 3 Office apps have far more users than Access. I think Access is going to wither away within the next couple years. Was a great run when everything worked right. I have used a lot of different databases over the years. However, Access was the runt who was very user friendly and an awesome reports generator.
