Search results

  1. I

    SQL Server importing strange characters despite specifying nvarchar

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

    Encountered strange interaction between Excel data and MS Access Link / Import

    I believe the issue is with my Excel. The Excel Link doesn't show the 2nd digit and that is where I think he problem originates. When I imported using SQL Server as a .CSV the 2nd digit appears
  3. I

    Encountered strange interaction between Excel data and MS Access Link / Import

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

    Encountered strange interaction between Excel data and MS Access Link / Import

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

    Encountered strange interaction between Excel data and MS Access Link / Import

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

    Stored Procedures vs. Dynamic SQL Pass Through Query based on a View

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

    Stored Procedures vs. Dynamic SQL Pass Through Query based on a View

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

    Stored Procedures vs. Dynamic SQL Pass Through Query based on a View

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

    Stored Procedures vs. Dynamic SQL Pass Through Query based on a View

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

    Feasibility of Teleric for MS Access Developers for Web Front End Development

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

    MYSQL Connection on AWS

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

    MYSQL Connection on AWS

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

    MYSQL Connection on AWS

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

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

    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...
  15. 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...
  16. 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...
  17. I

    SSMA_TimeStamp field never gets updated

    Thanks Tom. Makes Sense.
  18. 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
  19. I

    SSMA_TimeStamp field never gets updated

    Thank you for both of your responses.
  20. 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
Back
Top Bottom