Search results

  1. J

    Returning a row from SQL and storing in local table

    The following error occured: The record is deleted. [3167] I know that there is an issue getting the data from the SQL table and inserting it into the local DB table. The problem is I dont know what is causing it. I am using an .mdb file BTW Also I can copy and paste the data from the SQL...
  2. J

    Returning a row from SQL and storing in local table

    Hi all! I have a bit of an issue. Im trying to retrieve a row from SQL and insert it into my local DB table. However, when I try and execute the code, I get an error message. The data had not been inserted into my local DB table. Here is the code: strsql = "INSERT INTO EntryDetail_Local...
  3. J

    Stored Procedure Query

    Hi all, Quick question regarding queries. Im working on a project in Access 2002. I want to execute a stored procedure as a SQL Pass-Through Query and pass a variable to it from my code. Im guessing the statment will look something like this: exec get_companylist_search @variable I have...
Back
Top Bottom