[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…
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…
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…
Microsoft Access Error After April 2024 Microsoft Update: Too many client tasks
I am getting the error "Too many client tasks" when querying an Access database using ODBC after an April 2024 Microsoft update was applied, which was the update for Office 2016 KB5002340. When I uninstalled that update, it's working well…
ms access - Undefined function 'Dir' in expression. (Error 3085)
I.T have updated office 365 to the latest version. A access database now has all the security features set on it as attached. When i run on previous version this yellow security tag does not appear. The real problem is that the 3085 error stops a report…
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:…
Trying to access old account from almost 10 years ago!
Hi, I am trying to regain access to my old account that I stopped using due to trying to escape domestic violence and safety concerns around 2017/18. I am now safe to access my account, but cannot pass the generic application to do so, as I don't…
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.
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
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…
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
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.…
I need to share my subscription benefits with an employee
I paid for a subscription it says I can share with a few people. I have 4 employees I'd like to share with so they can open spreadsheets etc. How do I do this?
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
#Func! Error I can’t get around
I have a column of data ([Premium Hdr].[Rev]) that contains blanks, letters and strings containing letters+numbers. I need to do a Nz on the blanks, trim the + and numbers if they are there, and if there are just letters, return that in a calculated…
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
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.
Using FollowHyperlink not working
Have this code on a command button on a form. The field PDFName is also on the form. The filepath comes up OK. However, the line "Application.followhyperlink filepath,1,0" gives an error: RunTime Error 490; Cannot open the specified file."…