Can anyone tell me how can I send email through stored procedure in sql
server ? I want to send attachment with this email too.
TIA

Open Connection to remote SQL Server DB from access 2002
How do I open a connection to a remote DB in SQL Server from Access 2002.  I
am using the ADODB Connection to do this, but I can’t figure it out…  I don’t
think it should be so complicated.  (basicaly trying to connect from ...

I have written one stored procedure. At the end it returns the set of rows.
I want to define cursor on the result which is sent by stored procedure.
How can i do that ?
Thanks

I'm currently developing an MSDE 2000 database using ADP as the front end.
Our plan is to store the database on a dedicated PC and make it the database
available to a small work group.  The operating system is Windows 2000.
How do I make the SQL Server instance visible to other ...

Is it possible that to have a child form or child page inside my page?
Any information is great appreciated.
Souris

I use Access 2003 in Windows XP Home Edition, but it doesn't work correctly.
I can't open the project of Northwind database, and it always shows error
all the time with the SQL Server. Please, what can I do? I'm running SQL
Server 2000 and I don't know how to use it. Please, help ...

I recently ported an Access2000 mdb to Access2000 adp. There were few
autonumber fields in few tables in old database, so I used Identity columns
for those fields in new .adp.
I am using ADO 2.6 and Sql Server 2000(without service packs)

I've got an adp-file that seems to be corrupt. When I try to open the file, I
get the message "The file is not in the correct format for a Microsoft Access
project"
I tried compact/repair and /decompile, but nothing works.

When I choose Programs, SQLXML 3.0, Configure IIS Support to open the IIS
Virtual Directory Management for SQLXML 3.0 snap-in, there are no nodes to
expand (in order to display the "Default Web Site" item). All I see is the
IIS Virtual Directory Management for SQLXML 3.0 icon and ...

I have an app using SQL Server as backend and MS Access as front end.
I wanted to execute store procedures in SQL server from MS Access front app.
Any suggestions or opinions?
Your information is great appreciated.

would anyone know what would be the best maintenence plan to incorporate into my SQL Database. or even any links.
i have just upgraded from access to SQL and am not up to date with how to set up the best plan
thanks heaps
Lee-Anne

I am creating an Access 2000 ADP.  I have created several stored procedures
in Query Analyzer but I cannot view the stored procedures when I look at the
sp database window.
How can I access any SPs created via QA?

i'm a newbie in access and trying to create small application for my office.
could anyone help me with this??
i have this record in text file and already imported to .mdb.
seq    item        wh    qty

I'm using the NT user to connect to the SQL server used by my ADP project And
I would like to create profil for users inside my database so if connected as
USERX show menu1 else show menu2. Maybe there is an other way to do it in
fact I would like to hide everything so user ...

Can someone help on this.
I've got a UDF Scalar Function that works fine in on database, but when
I try to copy the same UDF to another database I get syntax error
messages.