after searching and searching (and sometimes just trying to foget the
problem) im really stuck...
I deployed an adp-application to a customer network (win2k-server with
Sql Server 2000/ win2k-workstations with mdac 2.8, Access 2000 Sp3) .

hi, i am upgrading an Access97 mdb to Access2002 adp.  As part of the
exercise i am implementing further security by utilising stored procedures
calls.
The existing mdb calls dlookup in a number of instances.  Has anyone found a

I have an issure trying to send emails from Access 2003. I receive the
following error:
8007007e (-2147024770), "The specified module could not be found"
I tried the fixes listed at http://support.microsoft.com/kb/327219/en-us but

I'm converting an Access 2000 database to SQL 2000. In this conversion I will
be creating a Web front end and need to know how to conditionally format HTML
tables based on the results of a query/view in SQL. Example: If dept. A sales
are <= x then format table cell red. If dept A ...

in my access project (adp) I've bound a form to a SQLServer table and create
a control in the forms footer.
The controlsource is:
=Sum(([zeitaufwand]*[internerkostensatz]))+Sum([externe_kosten])

Access 2003 SQL 2000 Win 2000
In Access I added new rows directly into the linked table which resides on an
SQL back-end. When clicking on the table in Access the new rows are visible,
however, when I view the table in SQL Enterprise Mgr they are not added to

Following my earlier question ((CROSS POSTED) Very strange: Connection under
process info not whats in front-end)
I have set the permissions for a particular table so that none of the listed
users can do anything (select, insert etc.) yet when I connect from another

I am trying to run this query in VB but I must have it written wrong but I
can't find where.
Could some body help me out
RS.Open "Select email from team where SONumber = '" & SONumber & "' and where

when I attempt to call a SQLServer UDF from VBA/ADODB I get an errormessage:
Runtime error: -2147467259
Invalid scaling
UDF is as follows

Windows XP + Access 2003 + SPs + ADO 2.8 + MS SQL Server 2000
While loading a bound single form, in the open statement i try to find a
given record. Unfortunatelly it fails, because the recordset isn't still
fully loaded.

hi every body,
i am using access xp as front end and back end sql 2k.
i am trying to add some records for testing purpose using one form which is
bound to one table, when i use Data Entry Property =  yes with default view =

Hello everyone.  I had the following DateDiff work fine in MDB
=DateDiff("d",[Invoice Date],Date()).
Does anyone know how to write the code for the same thing in ADP?  I need to
do the above, which calculates the age of an invoice.  I also need to be able

Need help:
I have a form setup to run a report based off of data on that report.  The
report needs to know which record its looking at based off of the primary key,
an int value autonumber.   The report is setup to run based off of a stored

I have been hearing rumours, from Microsoft Product Support Technicians,
that Microsoft's enthusiasm in general for Microsoft Access, and in
particular .adp projects and SQL Server Client Data Manager Interface (CDM
OLE DB Service Provider) is on the wane; preferring instead, ...

I've converted an Access 2000 mdb application to Access 2003 ADP with SQL
backend on Window XP SP2 platform.  Deployed to client's Win 2000 running
Access 2000.
On the client's workstation when the application is adding a new record and