I am converting a mdb to an adp with sql server 2000 backend. I have a
query in the mdb which uses a custom vba function in an expression
field to work out the number of working days between two dates. This
function also uses a table of Bank Holiday dates and a bit of ado to

I have an .adp connected to a SQL database named SCSdb.  I just added one
form to the application and would like to set the record source of a drop
down to a table in another database in SQL named SCSAdmin.  Can someone
point me in the right direction.  I would just like to be ...

I have an Access 2k adp file that displays a strange behavior, but only on
one PC. On the computer in question, table, views, and forms work fine. On
the other hand all stored procedures are listed as "spName;1" rather than
just "spName", and when you try to open them the screen ...

Hello;
In case someone needs... when ADP or ADE connects to sql server with
integrated authentication, the developer's machine name appears in sql
server instead of the user's machine, because ADP hardcodes the development

Currently working on an existing system written using an Access 2002 project
(.adp) and SQL Server 2000 and need to add some ehancements.
The system is a leasing system where a customer leases one or more assets
for a defined term (eg. 24, 36, 48 months...). Each lease may also be ...

I am using a stored procedure as the source for a report in an Access
Project.  This report displays letters (which are generated by the
database into a single TEXT field for each person, similar to a
mail-merge feature).  The problem is that while CHAR(13) works as a

I have an .adp file which I have converted to .ade and compiled into a
Runtime version with Windows XP Microsoft Office Developer. I have developed
a SQL Server 2000 backend database and on my computer they talk together
nicely.

When I start my computer, small windows pop up that say Protection Error 34
and Error 158.
Does anybody know what this means and what I can do to resolve the problem?
Thanks for your help.

Can I use the character ":" in a field name of a database SQL? For example
can I name a field as TitlePerson:D1 ?
Thanks

i try to implement a function which contains a CASE statement. Unfortunatly
i did only found samples with CASE statements within SQL-Statements.
The following code was rejected by the SQL-Server, and i have no idea what
the error is. Any ideas are welcome.

I am getting the following error when trying to connect to Heat
software. I have almost 150 PC and they all work fine except one, that
doesn't seems to keep the ODBC connection configuration which mean i
have to enter the password each time i use the software. Anyone has an

i have a stored procedure which transfers records from one table to another.
The first table has about 14000 records.
When i run the procedure only 10000 records are tranfered. I have specified
to transfer 'TOP 100 PERCENT'.

Hello!!
am trying to find a means to redirect error messages from windows Operating
system  and send them to Microsoft Outlook so that i can address them
easily!!

I upsized my backend to SQL Server. Retrieval of data for display in my forms
seems to work fine. However on some of the forms where editing and adding of
new records is allowed some errors occurs. The errors are associated with
trying to add a new record or edit an existing one.

I'm having trouble getting a stored procedure to run from an Access
.adp project form.
The stored procedure runs fine from SQL Query Analyzer. It has no
inputs and no outputs, and takes about 3 minutes to run on a local copy