I cannot send e-mail  and it keeps coming up as a server problem.   I contacted the server and they set up a whole new account and now they say it is a problem with outlook express.  HELP
Karen  Martin

I'm looking for the function in ADP that is similar to the
INT function.  I need just the integer/whole value of a
number.

I have one form for user to login consist of two fields, txtUserName and
txtPassword. I have one button that have the following code.
dim oConn  as new ADODB.Connection
dim cnStg as string

I have a fairly complex system using an Access 2000 .adp from an SQL Server
7 database, which is used across the state by several hundred users.  I
have
encountered a recent problem with a couple of reports which have been

I created a ADP in Access 2000. (2000 format) it worked
fine for months.  Then I loaded Access XP 2003 Beta on my
machine.  Well, the Beta license ended and now I am
trying to go back to 2000.  Now, I am having trouble

AC 2002 is doing a lot of
EXEC sp_MShelpcolumns N'ExternalOrderNumbers', NULL, N'id', 1
before each Excute MySP.
it there a way to defeat this?

Hey Guys I know that I have sent you info about my new computer company
www.outoftheboxcomputers.com  .
This is a new computer that I created and patented. It is not the worlds
best gaming computer ... That I can built too if you want me too. Email me

We have an Small Business Server on which SQL Server 2000
is running and this server is also PDC.
On the same server , we installed an application ADP-
ACCESS, and simples users ( Domain users ) can execute

Client: Access 2000
Server: MSDE 1.0
Error: "Automation error", "Operation is not allowed when the object is
open.".

I've got images stored in a sql table that I'm trying to
display on Access forms and reports... but doesn't work.  
We're able to handle these images in ASP from sql to
display them on a webpage but can't get them to display

I have an Access app that uses SQL 7.  When I changed the
ade to connect to SQL 2000, the stored procedures don't
work.  When I run a trace on SQL, the stored procedures
execute with "select * from "spxxx"".  With the runtime I

Hey people, sorry for the cross post but both groups have dealt with this
problem in the past.
I have an unbound ADP that I want to connect and disconnect to using code. I
found some stuff from Mary Chipman that talked about creating a new ADP and

I am trying to create a form that is based on two tables: Members and
MemberDetails.
The Members table has the following fields
- MemberID (primary key)

I have a simple form with subform.  The subform has some
simple calculated controls.  Every time I change any
value on the main form, the subform appears to
recalculate.  This could be normal behavior.

Is there any T-SQL that will find an empty table or which
tables have records?