User Profile

Collapse

Profile Sidebar

Collapse
Harry1234
Harry1234
Last Activity: May 28 '14, 10:30 AM
Joined: Mar 10 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Harry1234
    replied to VBA: Database locked by Admin
    in Access
    Hi Jim

    Apologies for all the confusion
    Im running it now with the changes to Set DBS (it takes several hours but so far looks good)

    Can you tell me setting it to the current DB is different from simply specifying the full path of the DB

    Will this work for example if i load the DB from a network drive

    Im interested in understand the why as well as the answer

    Again, thank...
    See more | Go to post

      Leave a comment:

    • Harry1234
      replied to VBA: Database locked by Admin
      in Access
      Hi Jim

      Sorry, I was attempting to anonomize the code while in a meeting...multi-tasking :)
      I have updated it in the original question

      Basically Q1 takes messy information from a sharepoint list
      Q2 depuplicates that list

      Due to performance issues, Q1 was set up so that it only took the previous couple of months from the sharepoint list

      It is then loaded from the table 2-DEDUP into an...
      See more | Go to post

        Leave a comment:

      • Harry1234
        replied to VBA: Database locked by Admin
        in Access
        Hi Jim

        Firstly thank you very much for the quick response
        You are correct it dies on the the line where i set the dbs variable

        I use that variable to update the query (which has been created in the Access DB) with the SQL
        Code:
        ishare_query.SQL = "SELECT HAWB, [Orig Ctr], [Dest Ctr], True Value], [True CUR], [Created By], " & _ 
  
        "Undervalued.Created INTO [1-T_ISHARE
        ...
        See more | Go to post
        Last edited by Harry1234; May 27 '14, 02:47 PM. Reason: Added SQL Update

          Leave a comment:

        • Harry1234
          started a topic VBA: Database locked by Admin
          in Access

          VBA: Database locked by Admin

          Hello Bytes Community

          I have a problem with an access DB I was hoping you could help me with

          I have a MS Access 2010 database which is locking the database prior to me running the following code which takes a list from the sharepoint portal and inputs it into an array for further processing down the line

          It fails on the line in Set ishare_query = dbs.QueryDefs(s trqueryname), either with the database has been...
          See more | Go to post
          Last edited by Harry1234; May 27 '14, 05:04 PM. Reason: Changed Code Based on user feedback
          • Harry1234
            started a topic Hiding ODBC Credentials for Pass Through Query
            in Access

            Hiding ODBC Credentials for Pass Through Query

            Hi All

            I am currently building a Database which uses a passthrough query

            The query queries a teradata database using an existing ODBC setup; inserting records into a temp table

            I want to move the Access DBto a second PC which will automatically run it once a week

            Our IT department changes the passwords of ODBC once every three months

            Is it possible when setting up the initial...
            See more | Go to post
            No activity results to display
            Show More
            Working...