Is there not a Primary Key (Integer) to join the 2 tables together? How could you expect perfomance to be good by joining 2 tables on the above information?

Grasshopper,

it depends if you want the new tables to participate in the Replication!

Ok. Then Merge Replication would be a better option if the users are disconnected from the network at any length of time. However, if the users are always connected to...

(A) Upload the Database any way you like.

(B) Set up Transactional Replication between the 2 Databases.

I don't see how a view would accomplish this!

A simple trigger is definitely what you need! It would be something like this,

CREATE TRIGGER TrgInsDelRecord

ON Address

FOR INSERT, DELETE

AS

BEGIN

 INSERT Address2

 SELECT * FROM...

Sorry, correction it should be,

SELECT Customer_No, Date, Order_No, Part_no, SUM(Total_Amount_Paid) AS 'Total'

FROM Table

WHERE Order_no = 14

GROUP BY Customer_No, Date, Order_No, Part_no

Try this!

SELECT Customer_No, Date, Order_No, Part_no, SUM(Total_Amount_Paid) AS 'Total'

FROM Table

WHERE Part_no = 14

GROUP BY Customer_No, Date, Order_No, Part_no

That error means that the SQL Server is not configured to use "Windows NT Authentication". You have obviously configured the SQL Server for "SQL Server Security only".

Check the properties of...

In your first paragraph,

I have a lot of users who are using a Microsoft Access 2003 ADP (an Elementary school report card application) to input and print out report...

If you are talking about scripting your replication once you have created it then, in EM click on the tools menu then point to replication and choose "Generate Script". In...

Good! Now join the rest of us!

Create an IDENTITY COLUMN in your table and run the following query. A self JOIN is the easiest way to do this!

SELECT A.Col_A, A.Col_B, A.Vol

FROM TestTbl A CROSS JOIN TestTbl B

WHERE...

Did you check BOL?

You have to DECLARE a Variable and fill that variable with @@IDENTITY....

Here, try this!

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

CREATE PROCEDURE InsertNewPhone

AS

DECLARE @PhoneID INT

INSERT INTO phone (PhoneNumber) VALUES...

If your application was written correctly in the first place then you would only have to make the change ONCE in yolur application!

One correct way of doing this properly the...