Search results

  1. 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!
  2. 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...
  3. 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") =...
  4. 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...
  5. 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...
  6. 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.
  7. 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.
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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
  13. 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.
  14. 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
  15. I

    Shift Mode does not Maximize MS Access

    I asked a colleague and he confirmed he is experiencing the same behavior, MS Access not maximizing in Shift mode, on his machine. He also confirmed another behavior that is happening on his MS Office 64 bit machine. MS Access is randomly opening slowly. See attached video. I think this...
  16. I

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

    Yes that is what I wanted to confirm. If I use a DSN File to create the ODBC links than I can distribute the FE to another machine without the other machine having the DSN file. Thank you
  17. I

    Shift Mode does not Maximize MS Access

    Thanks for your response isladogs. This only occurs if I hold down SHIFT with MS Access. If I open without holding SHIFT, MS Access opens maximized. Since there is no SHIFT mode with MS Excel I cannot test this behavior with Excel.
  18. I

    Shift Mode does not Maximize MS Access

    Hello MS Access Expert, I observed that if the Folder is not maximized, MS Access opens maximized in shift mode. If the folder is maximized then MS Access only opens in the taskbar. I have attached a video to demonstrate this behavior. Does this occur on everyone's machine? I am using MS...
  19. I

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

    Pat and George, I apologize for my late response and thank you for yours. I understand that for Schema Changes in the SQL Server Backend the ODBC links need to be refreshed. My follow up question was why do we need DSNless VBA code, if when using a DSN file to create the ODBC links the links...
  20. I

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

    Thanks Pat. How about my interpretation of table links being DSNless using a File DSN? Is my understanding correct. Only User Machine Data includes the DSN in the connection string. ODBC;DSN=NewBrunswick;Description=NewBrunswick;UID=jrwei;Trusted_Connection=Yes;APP=Microsoft...
Top Bottom