Very nice description on the site above. My bet is that it will take care of your problem.

For added security:

If your Access DB happens to joined a custom .MDW (user-security),...

http://www.excelforum.com/access-programming/696798-recordset-query-how-to-open-and-retrieve-db.html

Good code (connected to SQL DB) examples for both Access / Excel using programming is avalilable at this site. The right forum for the right solutions...

Yes, Access...

Access Reporting fields -

One option is to use a function in the Access report rather than a fixed field.

A call to a function can include code, parameters, TSQL, a...

After another meltdown... and hours of learning.

Turns out that when us smaller shops run SQL on the same server as MS Exchange....

The Exchange update does something to the effect of...

Access 2003 Programmer

Upgrading linked tables from SQL 2005 to SQL 2008

I posted this set of very helpful information on the Access site.

http://www.access-programmers.co.uk/forums/showthread.php?t=182076

It would have been usefule to...

Status:

Just ran the script on a SQL Server 2005 to create the SP described.

One noted difference from the instructions at Microsoft.

MS implies to run Enterprise manager from Server A.

I ran...

:-D:-P:-D:-P:w00t::w00t::laugh:

OHH that was funny! Sorry to take so long to get back, had to get up off the floor!

Microsoft office products are extremely poorly supported for office automation. The business...

RE: Office 2003 Redistributable Primary Interop Assemblies

Starting back on page 7 and before.... Recap from Memory

This is one web site that I was attempting to get this working myself. Sorry...

http://www.excelforum.com/

Since the last question was about Excel (getting data from SQL Server)

My favorite place to post and find answers (with code and other details) for Excel -

-...

OLE Automation - Absolutely correct.

SQL Server does provide another option to do what OLE Automation using (almose) Pure T-SQL. On a previous thread, we discussed how it would be a...

"I have been repeatedly advised not to have SQL Server run Office automation"

We all hear this, probably because Office needs security patches from time to time. I would never suggest...

Linking Excel to SQL (and you can also store a query as part of the process) is one way to return a recordset. It is a popular way to provide...

Here is a code example from Access 2003 using pass-through.

First, it deletes the previous invoice information based on the users ID on SQL server.

Then it adds invoice information back to...

Microsoft Press:

Programming Microsoft Office Business Applications

ISBN-13: 978-0-7356-2536-5 2008

I am reading and really enjoying this book I won at the Denver (Rocky Mountain) Microsoft SQL Server...

I just opened my e-mail and grinned!

While my schedul won't allow me to respond for a couple of days...

This looks like some fun!

I will plan on getting back to this.