I would like to know if it is possible to execute a DTS
package from within a stored procedure. If so, could
someone steer me in to right direction as to what the
syntax would be for that?

Do I need to write a procedure to produce a crosstab
reprot?

my cursor keeps flying off!!! without me moving the mouse how can  i stop
it>?!?!?!?!?! plz help me!

Hi and thanks!
I have an Access 2000 that uses an ODBC link to a SQL Server (7.0). Very
basic form to look up basic information on Borrowers. Everything surrounding
capturing, editing, printing etc works fine. There are roughly 16000 records

Does anyone know how to convert a date in the cyymmdd
format to mmddyyyy?
Thank
David Chavez

I have my app almost complete.  I did all the development using the sql "sa"
account for the connection.
I set up a new sql user which has public and dbo rights.
When I change the apps connection to this new user my forms blow up.

I have an 2000 ADE using office 2000 automation.
I have a client that tries to run this on their 2002 office
they are getting a 400 error when trying use the excel automation.
in the vba  references I have the office 2000 excel object and 2000 access

Forgive me if this sounds a little elementary to some of you out there, but
is it possible to use Access and Access forms as the front end to input/read
data to/from SQL databases?
I know how to create SQL databases and all I really need is one table with

I am researching as to the easiest way we can create reports in our web application so our clients can export reports that can be imported into Access database
We have a web application that clients can search the system but the best output is a relational Access output with forms ...

I'm looking for a way to improve the app performance by moving my queries
with filtering to SQL2K server.
Is there a way to bind a form or report to a dynamic query in a stored
procedure? TIA.

I have a problem with a simple loop through a recordset.
I am using MS Access 2000 to link to a SQL 2000 database.
I have a simple select query that I know returns 86
records. However when I try and iterate through this

I know Access 2K pretty well and now I am trying to learn SQL Server.
Someone suggested I use Access Projects to get my feet wet.
Using an Access Project, I made a Stored Procedure that has an Input
parameter. The code is as follows:

I have converted access 97 to access xp adp project and connect the
table from my sql server 2000. my problem is that when i run my report
it says "Invalid SQL Statement. Check the server filter on the form
recordsource"

I am finalizing a MDB to ADP conversion using Access XP (2000 format), and running into goofy little bugs that do not appear in XP.  If I go to my client and ask him to upgrade the client machines, would you suggest Access or 2003?  I have not used 2003 yet, so I am looking to ...

I?m mostly a SQLServer guy, and I?m only using an Access adp to build a
REALLY quick and dirty "prototype GUI".
My app is based on stored procedures and I need to get to the RETURN code
and RAISERROR messags.