SQL Noob, your cursor declaration has a top clause so your resultset only has one record. You are also not fetching the next record in the cursor so SQL...

Installed it a few weeks ago and have not had any issues.

When you create a linked server with the Jet 4.0 OLE DB Provider you need to add the provider string.

Provider String: MS Access;Pwd=mypassword

Then you can use the OpenQuery function...

If you are using access runtime then the users will not have access to the database window. You will need to setup a startup form and develop an interface...

Here is the script that I use

Option Explicit

'on error resume next

Dim oFSO

Dim sDirectoryPath

Dim oFolder

Dim oFileCollection

Dim oFile

Dim iDaysOld

'Customize values here to fit your needs

iDaysOld = 2

Set oFSO = CreateObject("Scripting.FileSystemObject")

sDirectoryPath = "Backup...

I have a similiar issue.

I set up the DTS package as a job then use ADO to run the sp_start_job procedure on the msdb database.

Dim cnn As Object

Dim cmd As...

I came across this yesterday. It allows you to create an ODBC connection without a DSN.

http://support.microsoft.com/default.aspx?scid=kb;en-us;892490

A code example would be helpful

You can pass the return value of an ADO command by assigning the @Return_Value parameter which is always the first paramater of an ADO command.

Function sqls_mail_ado(str_to As String, str_subj As...

You can use the OpenRowset method or the OpenDataSource method to open the access table and append the SQL records. You can view more about these methods in BOL....

You can always use the return value to see if the procedure suceeded or failed it will be: 0 (success) or 1 (failure)

DECLARE @rv int

exec

Try using the Min function instead of First. First is not a function in T-SQL.

Here is another option using ADO

Dim cnn AS ADODB.Connection

Dim cmd as ADODB.Command

cnn.ConnectionString =""

cnn.open

with cmd

     .ActiveConnection = cnn

     .CommandType = adCmdStoredProc

     .CommandText = "ProcedureName"

     'Issue a refresh to get the named parameters

     .Parameters.Refresh

     .Parameters("@Variable") = txtVariable

     .Execute...

Sounds like you need to install the SQL 2000 readiness patch from Microsoft.  SQL 2000 was released over a year after Access 2000 so Access requires the update for the...