error importing a .csv file to a linked-table

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 !
 
G

Guest

You should be able to append to a linked table. Not sure why it is not
working. Is it in your startup routine?
 
P

Pete

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top