I have a database that is getting quite large and I would like to set up an
SQL database to handle this.  Do you have to purchase an SQL database from
microsoft or any other software/hardware?  Also, where is the ODBC driver
located in order to update to the newest driver?

I have a table on SQL 2000 that I am accessing with an Access 2003 form.
This is a basic data entry form.  On 4 or 5 out of the thousands of records
there is a notes field that will not allow me to change or edit data in the
field (ntext on SQL).  I can change all the other data ...

Digging around I've found that there is no way to access Outlook/Exchange
data using the .mdb/linked table wizard technique, that is you have to code!
There's a quite simple sample on MS explaining how/to @
(http://support.microsoft.com/kb/290792/);  basically it shows how to move ...

I have a stored procedure that has multiple select statements, each select
statement is giving me a count on a specific recordset and than writes the
results to a temp table.
I am trying to get those results into form in an ADP; however when the form

I have a combo box that uses a stored procedure as a row source.  It always
starts off blank.  How can I have the first item in the list show up
instead?
Thanks,

Do I need to do this using a stored procedure?
I need to generate a report based on values from global variables
(varStartDate and varEndDate).  Whenever I try to use these variables in the
report recordsource query I am getting errors that they cannot be found.

I'm using Access 2k
Using SQL I have been creating tables with some text fields.
Something along the lines of:
CREATE TABLE MyTable (MyTextField TEXT(50));

I have a stored procedure that I use to return a filtered list but I’m having
a problem with null values returned with joined tables. Here’s my code:
@Tbl1Var1 As nvarchar(50), @ Tbl1Var2 As nvarchar(50), @ Tbl1Var3 As nvarchar
(50), @Tbl1Var4 As nvarchar(50), @ Tbl1Var5 As ...

How do Access ADP projects stack up against a dotNet solution?
There are about 150 users, with 10-20 concurrent users.  The user base is
increasing gradually.
The advantages I see to the ADP solution are

I just want to Know how to select the Records from a table by givin
the Start rowcount and end rowcount.
in microsoft sql server.
waiting for reply soon

Using A2K.  I have the following code:
   Dim rstSSN As ADODB.Recordset
   Set cmd = New ADODB.Command
   Set cmd.ActiveConnection = cnn

I'm using the IsEmpty function in an Access Procedure and am converting the
database to SQL Server. I would like to know what the equivalent for IsEmpty
is in SQL.

I am a newbie here. I want to link access tables dynamically to sql server
tables (mind you, not sql tables to ms access tables).
I have access tables that are constantly inputed/updated by user inputs.
Hence, i want them to be linked and not imported. Once i link them to

Hello, Hello,
For my SQL Server back-end/ Access front-end Database I have the following
questions:
When a record is inserted into the main table (tbl_REJ) via a Access form, I

There is a table in an SQL Server database which has a field which has an
image field which is actuallly a packed array of floats, ie, it is the
concatenation of the bytes for a sequence of single floats.  I would like to
replace the field with a similar pack for a different set of ...