The "Database_Login_File" is an Access table not a SQL table. It is from a different Access DB and just referenced in the one I was currently trying to pick apart.

I...

Couple of things:

Firstly Read Isolation Uncommitted is basically the same as NoLock.

Secondly you can use NoLock on only a table or two in your query rather than all tables...

I will try to look into those things. Thank you for all of your help.

It's a weird situation and I wish I had someone here at my work that could...

Here is the code in z_log_refresh query

INSERT INTO DATABASE_LOGIN_FILE ( , [TIME], [DATE], [DATABASE], COMPUTER, NOTES )

SELECT Environ("USERNAME") AS , Time() AS [TIME], Date() AS [DATE], "Refresh HD-Stat" AS [DATABASE],...

So sorry...

One of the Report Applications (in Access) that I am looking to recreate some of the reports from, does have a refresh button. I look at the buttons properties and...

Well in my case Stored Procedures are used for Reporting Purposes and no I don't care because you report on the day, week, month prior. So the data shouldn't be...

I don't think it will hurt for you to have nolock on.

Any stored procedures that I write I add that in, regardless of how long something takes to run....

I would just like to comment: Sometimes the people asking the question give enough information but the people trying to answer the question either don't understand and shouldn't respond or...

The SQL DB is populated through the Main Application-front end in Access but connected to the SQL DB.

The Access Reporting/Applications use:

--SQL Tables

--Access tables that are from other Access...

Thank you, that was exactly what I needed.

Respectfully yours,

K8

Hi Karl,

So I am doing basically the same thing. We have reporting services set up on one server and we are going to be moving it to another server,...

Not sure if this will help you here is a link to some information.

http://blog.sqlauthority.com/2008/04/08/sql-server-change-order-of-column-in-database-tables/