Tried ot go bak and edit, and got an error. Noticed that SQL Server Agent was not running. Tried to start and received:

Property PagerSendSubjectOnly is not available for AlertSystem '[denregsql\denregulator]'....

Wow, thanks! That was a lot to digest - cut it way down and looked at some other solutions.

Will post some code here that appears to work.

This works from...

Wow, thanks! That was a lot to digest - cut it way down and looked at some other solutions.

Will post some code here that appears to work.

Thank you both for your excellent advice and tips.

I may post my results later to garner additional suggestions.

[Solved]

Thanks. The IT her doesn't really have SLA.

They did agree to bump it up from 2GB to 4GB today.

After running the same exact test, will be able to go from...

Just a reminder, this is on a Virtual Machine. Plenty of Hard Drive. But, only 2GB RAM allocated.

I am running a very small simple View that returns 5,000 records as...

Would the attached Perf Monitor chart appear normal?

If the IT staff were asked to increase resources, what would you recommend asking for?

Both are the same query - one from...

Thanks for the speedy response.

The tables had multiple indexes that performed great in Access. Removed them one at a time because sometimes an index on a tiny table can get...

Pro or Con: Here are some terms and recent news to consider.

The generic terms "outsourcing" and "offshoring" are very confusing and used by different groups for different meanings. Google "H1"...

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

Welcome to the world of Access clients that use SQL Server back-ends.

While I did not transfer my Access 2003 (run time) application from Oracle to SQL.

I did recentlly...

Thank you for all the great inputs!

I set up a SQL 2008 Test Server and took an old PC for the Access 2003 runtime client.

Wow, there were several "gotchas'!" that...

http://www.sql-server-performance.com/articles/dba/migrating_databases_checklist_part1_p1.aspx

worth reading - then add version 100 to the version 90

There were several more things that I did becaue Microsoft recommended it.

Hope you were successful.

My test server and...

We did something like that and yes it works.

The problem was that we were successful.

Let me strongly advise you before you start to make an exact full copy of the...

It never hurts to set up a test SQL Server 2008 to test things out and find issues ahead of time. After setting up a virtual server with a SQL...

The scripts included the logon.

One logon and password were not know to me, and there was some encoded part of the script that created it.

the trick is to run the...