office 365
378 TopicsUsing Access Database on Two Computers [Case #:1053617826] Microsoft Support
I have several Access databases that are linked together for various queries I run. They are located on my OneDrive. I want to use them on 2 different computers. My main desktop computer was set up as "C:\users\admin\OneDrive\ " The databases are linked and all the queries have worked fine for many years. I just bought a brand new laptop to keep at another location. It was automatically set up as "C:\users\wcrim\OneDrive\". I can access all my OneDrive files on the new computer individually. However, my databases have linkages for many queries that point to the original "C:\users\admin\OneDrive\" locations for other the databases. So on the new computer, they can't be found. On the new computer it's set up as "C:\users\wcrim\OneDrive\" I keep getting not found. I was hoping to just be able to change the user name directory on the new computer to "admin", but it appears that can't done, at least not easily. That's what I was told. What can be done so I can use these databases and all the queries on my new laptop computer also. I'm looking for an uncomplicated solution. Thank You, Wayne Crimi [Case #:1053617826] Microsoft SupportSolved3.3KViews0likes19CommentsAccess 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\SandBoxMode50Views0likes2CommentsQuery 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 Tony105Views0likes3CommentsAccess 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.113Views0likes3Commentserrore 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.82Views0likes5CommentsAccess 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?2.3KViews0likes4CommentsAccess 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.119Views0likes2CommentsNo longer able to edit/enter into Access Query
I am working with a very basic table and a query from it. I was able to enter into the query. I am no longer able to. I have read every how to and to do and do not understand most instruction. Called for assistance and was directed here.70Views0likes1CommentAccess Northwind Dev Ed - Error GetRandomPkValue
Just downloaded the newest MS Access and selected a new Northwind Dev Ed as the first DB to create. It fails to open due to an error in the code as it searched for a non existing function GetRandomPkValue... The purpose of the missing function is to return a random primary key value by passing in the variables for a query name and a field name and then it should return a "random" numerical ID from those possible based upon the passed in variables... My question is, Is the new Northwind Dev designed to fail on purpose or did I manage to download a corrupted incomplete version or???107Views0likes3Comments