E
Ed Brant
I create a make table(Table 1) query by importing data from ODBC linked table
off an AS400 so as not to change anything in that data base. After creating
this table, I then make another table of duplications(Table 2) based on
Table1. I modifiy Table 2 to remove records I want to leave in Table 1. I
then create the delete query to remove records from Table 1 which are in
Table 2. In the datasheet mode all of the records are listed correctly;
however when I run the query, I get a 3086 error- no permission. I have
checked all the properties I can find, none that are set to read only.
I am logged on to my machine in administrator mode and I am the creator of
said database. Any ideas of where I went wrong or where I need to check for
the proper authority?? Any and all help appreaciated
off an AS400 so as not to change anything in that data base. After creating
this table, I then make another table of duplications(Table 2) based on
Table1. I modifiy Table 2 to remove records I want to leave in Table 1. I
then create the delete query to remove records from Table 1 which are in
Table 2. In the datasheet mode all of the records are listed correctly;
however when I run the query, I get a 3086 error- no permission. I have
checked all the properties I can find, none that are set to read only.
I am logged on to my machine in administrator mode and I am the creator of
said database. Any ideas of where I went wrong or where I need to check for
the proper authority?? Any and all help appreaciated