I have a table named MyTableBlank that contains no records. My intent is to
make a copy of this table, name the copy MyTable, append some records to
MyTable and import MyTable into an external database. I use the
TransferDatabase function to import MyTable into an external database. I
need MyTable to be in both the current database and the external database.
Prior to making the copy, I have code that checks to see if a table named
MyTable exists and if it does I delete it. To make the copy, I have tried
the CopyObject method and the TransferDatabase function. Whichever I try, I
get the same error message:
"Record(s) can't be read; no read permission on 'MyTable'..."
When I try to append some records to MyTable.
Can anyone interpret the error message and tell me how to cure this poblem.
Thanks!
Steve