repicurus (6/27/2011)

---

I've had extensive experience using this development model: ACCESS 2003 front-end --> SQL 2005 back-end.

It actually performs very well if both sides are done properly.

Unless you did something really...

Yes. You can schedule a report to run multiple times with different parameters, formats, frequencies, and destinations.

pym8 (6/27/2011)

---

Here's the stored procedures. 85% of the time table 1 is being populated, the other 15 percent it doesnt and causes the code to error out. The...

Sounds like you need help identifying and deleting the duplicates?

Say again? 😀

I was just curious as to what the codes represent and what the significance of presenting them in the format that you specified?

What problem are you trying to solve?

What is the business objective?

Is this what you want?

USE AdventureWorks

GO

SELECT *

FROM sys.Tables

GO

Why would you create a surrogate key on a view?

What course are you taking?:-)

jmlsauls (6/27/2011)

---

So i managed to get the list of filenames from the ftp that i need to download. Is there a way to specify that only those filenames get sent...

You are not deleting the duplicate records or you would not be getting the error.

Now that you have determined the source of the problem, you should seriously consider avoiding a trigger unless absolutely necessary as was suggested.

Are you joining on the correct table in your trigger?

You can use the upsize wizard from Visual Fox Pro.

Here is a link on how to do this: http://msdn2.microsoft.com/en-gb/library