Brandon,

You still have not said anything about teh limitations that you said you were running into with Access.   I would like to know what they are.  I have been using...

It is set as an undatable snapshot.  Are your users trying to update the same record and causing the deadlock?

I have tried the Toad for SQL Server and was not able to get it to work correctly.  I use Toad a lot for Oracle and have never had problems...

What are the limitations that you think you are running into?

I have been using Access against JET and SQL Server since 1.0 and have generally found the limitations to be...

Rachel,

Why are you not using the Access Data Project (ADP)? 

Access works with page locking and not record locking wehn using native Jet databases and, as far as I know,...

I just see a list of terms.  What are the questions.

Bad database design is the real problem here and not a SQL Server limit.  Look into adding audit columns for creation and modification dates.

Since you are trying to do something that has been identified as "buggy," I would stop trying to do it.

I have not tried this, but you should be able to...

No, you cannot store a .doc file in a TEXT column.  You have to use an IMAGE column to do that.   If a document contains both text and images, and...

In SQL Server, change it to a TEXT datatype and try that.  In Oracle, you are not storing the document in its native format, you are only storing the text...

Stefan,

An Image data type does not store text so how would you do a full text search of it?

What are you trying to store?  In Oracle is it a CLOB...

Now it makes more sense.

If C is an IDENTITY data type, it is always going to be unique.  Why do you have B (which is the same as C) and A combined as the primary...

But which version of SQL Server:

Developer?  Personal?  MSDE?

These are the only versions that will install on a non-server OS.

Some of the best books for general SQL syntax are those written by Joe Celko.  They are not SQL Server specific.

Another one is Guru's Guide to...