[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Access updating linked tables

Asked by cstallings in Access Forms, Access Coding/Macros, Access Reports

I have a database that is linked to another database. We have them linked by serial. When I update the serial number on database 1 it updates the linked databases serial number. I do not want it doing this. The only reason we are using the link is to reference some info from the second database. Any help would be greatly appreciated. Listed is the query. Thanks. 
1:
2:

SELECT Laptops_Desktops.Serial_Number, Inventory.Device_Type, PCName_SN.Hostname, Laptops_Desktops.Date_Issued, Laptops_Desktops.Qtrly_Check, Laptops_Desktops.NSC_Tech, Laptops_Desktops.Owner, PCName_SN.User, Inventory.Division, Laptops_Desktops.Permanent_Yes_No, Laptops_Desktops.Scheduled_Return_Date, Laptops_Desktops.Aircard_Yes_No, Laptops_Desktops.Aircard_SN, Laptops_Desktops.WAH_Yes_No, Laptops_Desktops.Covers_Yes_No, Laptops_Desktops.Monitor_Yes_No, Laptops_Desktops.Monitor_SN, Laptops_Desktops.Remarks, Inventory.Serial_Number, Inventory.Serial_Number
FROM (Laptops_Desktops LEFT JOIN Inventory ON Laptops_Desktops.Serial_Number = Inventory.Serial_Number) LEFT JOIN PCName_SN ON Laptops_Desktops.Serial_Number = PCName_SN.SN;
 
Related Solutions
Keywords: Access updating linked tables
Title
1 Shared pool problem
 
Loading Advertisement...
 
[+][-]11/05/09 09:55 AM, ID: 25752039Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 09:57 AM, ID: 25752064Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 10:10 AM, ID: 25752198Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 10:38 AM, ID: 25752458Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 10:42 AM, ID: 25752507Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 10:46 AM, ID: 25752533Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 10:55 AM, ID: 25752638Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 12:37 PM, ID: 25753725Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/06/09 11:41 AM, ID: 25762384Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625