Search results

  1. I

    How do you know if an Error occured in your Stored Procedure from MS Access Pass-through Query?

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

    How do you know if an Error occured in your Stored Procedure from MS Access Pass-through Query?

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

    SSMA_TimeStamp field never gets updated

    Thanks Tom. Makes Sense.
  4. I

    SSMA_TimeStamp field never gets updated

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

    SSMA_TimeStamp field never gets updated

    Thank you for both of your responses.
  6. I

    SSMA_TimeStamp field never gets updated

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

    Solved CDO Email: 530 Authentication Required

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

    Creating a Barcode and copy into Word Document

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

    Sending Email SMTP setting

    Based on the attachment that was successful sending the email, change the configuration settings to the below and it should work. With objFlds .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") =...
  10. I

    Solved CDO Email: 530 Authentication Required

    Thank you for your response isladogs. I was not able to resolve the issue using the suggestions in the Help file. (See below screenshots) Any additional assistance is appreciated. I entered all the parameters into your CDO program. For the 530 Authentication Required error, I actually...
  11. I

    Solved CDO Email: 530 Authentication Required

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

    Do most MS Access developers use DRIVER={SQL Server} in the ODBC Connection string?

    Thanks for the heads up. The link should work now.
  13. I

    Do most MS Access developers use DRIVER={SQL Server} in the ODBC Connection string?

    I looked at an older project I worked on back in 2017 and it is using the old SQL Server driver. I recall everything worked fine with the ODBC table links in that project. The old SQL Server driver may still be a viable option if the client has an older version of SQL Server.
  14. I

    Do most MS Access developers use DRIVER={SQL Server} in the ODBC Connection string?

    Based on testing, the old SQL Server driver is not performant using Access 2019 and SQL Server 2022. Please see the below thread. Necessity of using latest Driver I preferred to use the old SQL Server driver installed on every machine but because of the issues I am forced to use the latest...
  15. I

    MS Access slow when two identical Queries are opened simultaneously

    Thank you for everyone's responses. I figured out the cause. I was using the Windows Native SQL Server driver not ODBC Driver 17 for SQL Server. When I switched to ODBC Driver 17 for SQL Server everything executes quickly. Based on the below forum discussion (see the last post) I opted to use...
  16. I

    MS Access slow when two identical Queries are opened simultaneously

    Sorry, the table is an ODBC link to an SQL server table. If query one is open then the entire table also opens slowly, so, the field criteria may not be important. I’ll make a video tomorrow of the behaviour and attach it here.
  17. I

    MS Access slow when two identical Queries are opened simultaneously

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

    Shift Mode does not Maximize MS Access

    Yes, it appears to be a Windows issue then. Is anybody else experiencing the slow open phenomena as well. See attached. Thank you
  19. I

    Shift Mode does not Maximize MS Access

    Yes it is. It is maximized. Nice inquiry Josef. MS Access is maximized when the Folder is maximized it’s just not getting the Focus.
  20. I

    ODBC Connection Fails when I remove a Field from SQL Server Table

    It doesn't George. ODBC;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-5FFFFFF;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=NewBrunswick;;TABLE=dbo.Employees
Top Bottom