Microsoft Access database update question

30 pts.
Tags:
Database programming
Linked database
Microsoft Access
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it is so attendance can be taken offline and if someone is not there their student ID can be put in and a fine will be added to their account. When I add the student ID to the attendance table, usually a drop down field will appear allowing for me to see the student that is being added. For some reason this works on one of the fields in the table but none of the rest of the students. I have tried everything I can think of short of just starting all over. This does work because I created two more separate databases and linked them and tried again and was able to get the two to update and run reports and queries.

Answer Wiki

Thanks. We'll let you know when a new response is added.

do you get an error message saying that Access can’t find the linked table specified?

Have you verified that the tables are linked after the databases are taken offline? May be you need to run the link again. Is this access 2007?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following