Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
0 answers
Access Europe User Group Meeting - Wed 3 July
The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). We are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will…
asked 2024-06-28T18:28:52.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Colin Riddington
141
Reputation points MVP
edited the question 2024-06-28T19:09:19.6733333+00:00
Colin Riddington
141
Reputation points MVP
0 answers
How to set up client permissions on secure shared database
Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 54%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
0 answers
Object variable or With Block variable not set
I have this code that is executed upon pushing a button. After going through most of the code i get an error saying 'Object variable or With Block variable not set'. Private Sub CancelJob_Click() On Error GoTo Err_Close_Jobs Dim BOM As String Dim i…
asked 2024-06-18T16:01:14.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
commented 2024-06-18T16:44:58.51+00:00
Lopez, Ahiezer
236
Reputation points
0 answers
Bug in Access Database Compare Tool
Hello As seen in the screenshot: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
0 answers
Jet compact utility
Hello Any idea why this download is not signed with a code signing certificate by Microsoft? https://learn.microsoft.com/en-us/office/troubleshoot/access/jet-compact-utility-download And, there's a password protected mdb database that I need to compact,…
0 answers
How can I create a label in Microsoft Access that ignores empty fields and moves the remaining fields up?
I have a form that is a label and I need to have this as a sort of "general purpose" label so there may be a field missing from time to time (Company Name) that when the label prints, it ignores that field and moves the rest of the fields up so…
asked 2024-05-23T04:03:46.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 92%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jeff Toombs
0
Reputation points
asked 2024-05-23T04:03:46.13+00:00
Jeff Toombs
0
Reputation points
0 answers
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm)
I am unable to refresh an excel spreadsheet pulling the data from Access Database. [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm) I can refresh other spreadsheets from the same access…
asked 2024-05-16T12:24:00.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 73%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Trickett-Bell, Andrew
0
Reputation points
commented 2024-05-17T05:35:58.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
7,065
Reputation points Microsoft Vendor
0 answers
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
asked 2024-05-16T05:19:08.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
T West
136
Reputation points
edited the question 2024-05-16T09:33:54.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
0 answers
This Recordset is not updatable. (Error 3326)
I migrated access tables to SQL and use the linked tables in a series of forms. Once option in the Main Form updates fields from a table in a sub-form when I get the This Recordset is not updatable. (Error 3326) error. I checked and the tables all have a…
asked 2024-05-15T17:55:03.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 84%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Patrick Kelleher
0
Reputation points
asked 2024-05-15T17:55:03.09+00:00
Patrick Kelleher
0
Reputation points
0 answers
All of our Azure pipelines are failing - Datastore connection issue
Our pipelines have been running in the Azure sandbox environment for years - about a week ago all of the pipelines began failing with the following error: Error Code: ScriptExecution.DatastoreResolution.Authentication Failed Step:…
asked 2024-04-17T14:49:49.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Brittany Perry
0
Reputation points
edited the question 2024-05-06T03:39:27.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
30,071
Reputation points Microsoft Employee
0 answers
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. But in my machine Microsoft Access Database Engine 2010 was installed.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 83%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
0 answers
My authenticator app has lost all apps data and I'm unable to login to apps like twitter
My twitter account is connected to authenticator but after changing my device and restoring dat via smart switch ,all Microsoft authenticator data is missing and I cannot reconnect my twitter account with out the authenticator code
asked 2024-04-30T15:51:21.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gideon Githambo
0
Reputation points
asked 2024-04-30T15:51:21.86+00:00
Gideon Githambo
0
Reputation points
0 answers
I am having trouble unlinking my GitHub account from Microsoft App Center
Hi there, Is it possible to unlink my github account from Microsoft App Center? I wish to download software onto my mobile via the Microsoft "personal, company or school' option here. https://appcenter.ms/create-account. Currently I am unable to do…
asked 2024-04-30T13:32:40.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 31%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Adam Kavanagh
0
Reputation points
asked 2024-04-30T13:32:40.05+00:00
Adam Kavanagh
0
Reputation points
0 answers
I am making a report in Microsoft access and I need help.
I am making a database for school. It consists of a query and a report. I am making the report and having trouble. I inserted a page break on my report to make a new page, however in print preview it doesn't show my data on the second page on my report.…
asked 2024-04-26T00:16:19.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Briana Diaz
0
Reputation points
asked 2024-04-26T00:16:19.53+00:00
Briana Diaz
0
Reputation points
0 answers
External Partner cannot access SharePoint
I have a group of external partners that need access to some SharePoint site and although they have been added to Azure they still cannot access the sites, I have removed and re-added them all seems to fail.
asked 2024-04-17T15:09:29.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Boyd, Yvonne
0
Reputation points
commented 2024-04-17T22:22:41.4433333+00:00
Andrew Geddes
741
Reputation points
0 answers
ActiveX Control for Adobe PDF Reader not working
I have now posted this issue 3 times with no response. What's up with that !!!! Access 365 I have a form "ViewPDFForm" that has an ActiveX control named "ActiveXCtl2." It is an Adobe PDF Reader control. However, I cannot get it to…
asked 2024-04-09T21:14:49.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Maxine Nietz
1
Reputation point
asked 2024-04-09T21:14:49.2266667+00:00
Maxine Nietz
1
Reputation point
0 answers
como excluir minha conta
eu gostaria de excluir minha conta, mas aparece este erro:
asked 2024-03-29T21:26:20.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
asked 2024-03-29T21:26:20.49+00:00
Anonymous
0 answers
Unable to view my certificate.
Despite following the provided steps to obtain my certification transcript, I have been unable to locate it within my account. Specifically, after logging in and navigating to the appropriate section, my transcript does not appear as expected. I have a…
asked 2024-03-27T14:12:00.4533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
yodit araye
0
Reputation points
asked 2024-03-27T14:12:00.4533333+00:00
yodit araye
0
Reputation points
0 answers
How to include more than two decimal places for percent format on Microsoft Access?
123.jpg For Microsoft Access, even though I set the Decimal Place parameter to 5 decimal places, Access rounds it to 2 decimal places. Is there any fix for this? Thank you.
asked 2024-03-18T16:10:41.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Cheng-Hsiang Lee
0
Reputation points
asked 2024-03-18T16:10:41.7566667+00:00
Cheng-Hsiang Lee
0
Reputation points
0 answers
Il portale ha riscontrato problemi durante il recupero di un token di autenticazione. L'esperienza potrebbe essere degradata.
Informazioni aggiuntive dalla chiamata per il recupero di un token: Estensione: Microsoft_Azure_Support Risorsa: self Dettagli: L'utente connesso non è autorizzato a recuperare i token per l'estensione 'Microsoft_Azure_Support' perché l'account utente…
asked 2024-03-11T10:48:45.2466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 32%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGF%3C/text%3E%3C/svg%3E)
Giacomo Fabbian
0
Reputation points
asked 2024-03-11T10:48:45.2466667+00:00
Giacomo Fabbian
0
Reputation points