Having Problems With an Append Query

B

BrianPaul

I have 2 seperate databases, 1 with all my table data, forms, etc that I call
the Main Database.MDB. I can export out to my 2nd Database called Update.MDB
Just fine but I have to run 2 append queries because the two tables are
linked. The reason is that I want to post the Update.MDB on the web for end
users to download and upload there new studies. When they open the 2nd
database a macro runs automatically which will export the new study into the
Main Database.MDB, Here is where I hit the snag. I changed the study title
in one and it exported just fine to the Update.mdb, tables(s) just fine.
However when I ran the Update.mdb since the Primary key was the same, it
wouldn't update. I got to thinking If I changed that then I would loose the
link to the 2nd table because of the join. Is there a workaround for this or
is my design incorrect? Thanks.
 

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

Similar Threads

Update table using data in a different .mdb 0
Append Crosstab Query to Existing Table 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
QBF & Query Malfunction 0
Table Security in Access 2013 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Table missing when running an <Append Query> 1

Top