Search results

It's 255 George. I also tried it with Long Text. Same results on my Machine.

I am running MS Access 2019. What are you running MarkK? I imported using the Import Wizard.

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...

Thanks for the suggestion Pat. Splitting the WasteClass into multiple components make sense.

Thank you CheekyBuddha and everyone else who contributed to this thread.

Thank you for everyone's responses. The Where Predicate on the View can get complex (See code below) depending on the search criteria from the user but what I am gathering is I can link the View and still create the Dynamic SQL on an Access Query. MS Access will send the below Access Query...

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...

I downloaded ODBC MYSQL 8.3 64Bit from the below website and everything is working now. Thank you CheekyBuddha! https://downloads.mysql.com/archives/c-odbc/

Thank you CheekyBuddha. I appreciate your response. It looks like it's probably a driver issue. I'll try the 8.0 version later this afternoon.

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...

I was doing some testing today in regards to Errors showing up in Pass-through Queries with Stored Procedure having a Try Catch. Raising custom Business Logic Errors works well using RAISERROR ('My message', 11, 1). Also, I was getting the error 'Invalid column name' after changing a field...

Thank you for everyone's response. tvanstiphout you are correct without a Try Catch MS Access displays the error. Not including the Try-Catch may be sufficient for simple SP. Galaxiom I don't have much experience with ADODB especially with SP returning multiple recordsets. Do you have any...

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...

Thanks Tom. Makes Sense.

Thank you again for both of your responses. I have a follow up question to the SSMA_TimeStamp field. If I have an updateable View using the SalesOrder and SalesOrderDetail tables should I include the SSMA_TimeStamp field from one of the tables in the view? If so, from which Table? Thank you

Thank you for both of your responses.

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

Hi isladogs, Changing the port to 465 allowed the email to be sent. Thank you very much isladogs!

stu_c, I wanted to brush up on my MS Access and VBA. I believe I developed the solution that you are looking for. (See the attached zip file.) Ensure that you install Z3OF9.ttf which is the Barcode Font recommended by George and which I have used in the past. I also show how you can strip...