I agree with Gail, you should not be randomly making changes to your tables. But if you insist on doing that, you could create a view WITH SCHEMABINDING, check the...

She Through Whom All Data Flows (4/21/2009)

---

I want to convert a DMax function that I use in my MS Access vb code to something that will more efficiently run on...

Thanks Jack, great introduction to Profiler. Looking forward to the next installment.

Please allow me to explain.

If mandayperdistrictpermonth is a view in SQL Server, that is what it is. When...

First of all, make a copy of the file before you attempt any repair.

Second, try to determine which type of corruption you have: system, tables, or VBA. Or total failure.

If...

You could also use

sp_tables '%yourcriteria%'

Some commercial products that are designed that way, for example Microsoft's Retail Management System. The application handles all of the integrity issues & business logic.

The basic problem is that you're bringing all the records into Access and then applying the date filter. I would suggest using a pass-thru query, following these steps. . .

--...

Robert, you make a very good point. Sometimes only one reply really connects with the OP.

I have to agree with the previous posters, using the GUI to generate the change script is the best approach. The column being changed stays in the same ordinal position,...

If you are using Windows Authentication, you can use SUSER_NAME()

Examples of good advice:

The reply indicates that the poster fully understands your question.

If the poster does not fully understand your question, they ask for clarification or relevant details.

The reply specifically...

dwjongbloed (2/23/2009)

---

We have a third party application that uses an Access front end but the tables in Access are pointed to our MSSQL Server. I have no idea how these...

try changing these two lines as follows:

Dim db As DAO.Database

Dim rstCurves As DAO.Recordset

Check out this script by michael vessey, it tests for "SQL Server 2005 readiness"

http://www.sqlservercentral.com/scripts/Miscellaneous/31542/