rpouwels (9/25/2012)

---

Hi Everybody,

I am trying to fetch some data from an SQL Server Database.

I have a query, but it keeps prompting for credentials.

SELECT Invoices.NavisionInvoiceNumber, Invoices.NavisionInvoiceDate, Invoices.NavisionCustomerNumber, Invoices.NavisionCustomerName, Invoices.NavisionTotalDeliveries, Invoices.FilesDistributed, Invoices.IsComplete, Deliveries.DeliveryNumber, Deliveries.PDFName, Deliveries.NumberOfTries, Deliveries.FilesMoved, Deliveries.HasFailed, Deliveries.IsComplete

FROM LVA.dbo.Deliveries Deliveries left outer join LVA.dbo.Invoices Invoices on Deliveries.InvoiceId = Invoices.Id ORDER BY Invoices.NavisionInvoiceNumber, Deliveries.PDFName

It keeps asking for an DSN (The DSN is on a networkshare)

How can i make sure that it goes automatically?

Edit: It has to be imported in Access 2010

Regards,

Robert