Search results

Hello Access World, I am storing Lat / Long from GoogleMaps API in SQL Server. It is recommended to use the Float Datatype to store Lat / Long, however, when I use Float MS Access presents me with the following error when I open the Linked Table. When I store Lat / Long as Decimal(9,6)...

Hello Access Forum, I am unable to import Excel into my SQL Server due to the error 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) 1) By running EXEC sp_enum_oledb_providers I can see I have Microsoft.ACE.OLEDB.12.0. on my machine. 2) It's...

Hello Access Forum, I imported a .csv that contains special Unicode characters using the Import Flat File wizard from SSMS. The .csv shows the Unicode characters properly but the output of the import in SQL Server does not. Please see the below screenshots. I have attached a sample .csv...

Hello Access Forum, I have encountered strange behavior between Excel Data and MS Access. I have an Excel field that contains strings and numbers that contain decimals. When I link to this Excel sheet or Import it in MS Access the last digit from the first number is truncated. (See below...

Hello MS Access Expert, Are there any advantages to a Stored Procedures vs. a Dynamic SQL Pass Through Query based on a View? Suppose I have a View and I need to include a user defined Parameter on the View from the MS Access Front End. I can create a Pass Through Query with a Where Clause...

Hello AccessWorld, I recently met a MS Access Developer at the gym and he is using Teleric to create his Web front end solutions connected to MS SQL Server. He is going to give me a Demo on Monday and claims he wouldn't develop Web front ends any other way. Teleric reminds me of Alpha...

Hello MS Access Expert, I didn't know what section of the forum to post this question, so I decided to post it here. I have a friend who has a MYSQL database on AWS. I was able to Migrate his MYSQL Database to my local instance of SQL Server using the Migration Assistant for MYSQL...

Hello MS Access Expert, Suppose I have the below stored procedure. Note, that currently it will throw a division by 0 error. In MS Access when I run the pass-through query, I receive an empty recordset which could imply no results when in fact there was a Division by 0 error. How do I...

Hello MS Access Expert, I used the SMMA migration tool today. When I insert or update records (both in MS Access or SQL Server) the SSMA_TimeStamp field is never modified. I was curious if it will ever have a data value at some point. If so, when exactly? Thank you

Hello MS Access Expert, I am receiving the below 530 Authentication Required error despite having Authentication turned on in my VBA code (See below). The email provider I am using is 1and1 with the below posted settings. When I turn on .Item(sch & "sendtls") = True I still receive the same...

Hello MS Access Expert, Suppose I have a table Y with 30K records and I have two queries in MS Access which are identical (SQL = Select x from Y where x = "a"). When I open the first query the results appear instantly. While keeping the first query open, I subsequently open a second identical...

Hello MS Access Expert, When I open an .accdb file using shift mode it does not Maximize on my screen. It merely appears in my Taskbar and then I have to click it to maximize it on my screen. The peculiar aspect is that if the file is Not in a folder but rather on my desktop it always...

Hello MS Access Expert, If I have ODBC Driver 17 for SQL Server in the ODBC connection string I presume that would require me to install this driver on the client's machine? However, suppose the client gets a new computer later on and it has ODBC Driver 18 installed. Will that break my ODBC...

Hello MS Access Expert, I noticed that when I delete a field from the SQL Server table the ODBC connection subsequently breaks. Additionally, if I add fields to the SQL Server Table the ODBC connection does not break but the newly added fields do not show up. The only solution that I have...

Hello MS Access Expert, I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip. I have...

Hello MS Access Expert, Unfortunately, it appears the latest FMS release does not support a 64 Bit environment. I recall there was a free Tool that offered very similar features to FMS Visual Code Tools but I cannot recall the exact name. Can you provide the name and link for this free VBA...

Hello MS Access Expert, I am learning how to migrate MS Access objects using SSMA into SQL Server 2019. I was not able to Migrate the following query using the SSMA wizard and I am curious why. SELECT Invoice.InvoiceNo, [Quantity]*[UP] AS Total, Month([Invoice].Date) AS [Month], Invoice.Date...

Hello MS Access Expert, I would like to know if it is possible to make API calls via VBA that meet the below standards: Ability to adhere to TLS 1.2 encryption for HTTPS connection Ability to support OAuth 2.0 JSON Web Token (JWT) Bearer Flow I have a MS Access system that has been in...

Hi Access Expert, I updated my MS Access 64 Bit via the Office Update Method (See attached Screenshot) and now my environment is slightly corrupted. 1) Now when I reboot my machine 2 Instances of MS Access load on Startup. 2) When I close an MS Access file and then open another MS Access file...

Hello MS Access Expert, My new machine came with Office 2019 64 Bit, hence, I have MS Access 2019 64 Bit installed. My application no longer compiles due to the Declare statements. I have been reading how to make the VBA 64 Bit compliant and it seems to be pretty straight forward if there...