error importing a .csv file to a linked-table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases:
one for the tables
one that is put at the user end with all forms, queries, ect... and with all
tables linked to the first one.

Now I'm trying to import a .csv file (but by APPENDING the data) into one of
my table and I need to run my saved-import automatically from my user desk,
when the first user opens the database.

Well the exact same steps don't work if i do it into the linked table
instead of a table that would be directly in my DB. (I tried both ways, I
even created the table from an import, append after, works fine, import that
table into my tables DB, and then link to it from my second DB: doesn't work
!)

Is it possible that it just doesn't work to append imported data into a
linked-table ?

Any suggestion ?

Thanks for helping !
 
You should be able to append to a linked table. Not sure why it is not
working. Is it in your startup routine?
 
I assume you have recreated your original table from the front end to the
back end again to see if the one in the back end is damaged. Do you get any
errors messages? Are the keys the same? Is security enabled? Do users have
access to the table in the backend?
 
Back
Top