so who is the PM at MS that let ADP ship without testing calc columns?
i mean-- from what i see that PM should be fired.. i've just had a
bitch of a time with calc columns in ADP.
SHOULDN'T THIS BE EASIER?

All,
I have to store some huge pictures in an ADP project.
The current needs are :
A small version of the image (ca. 100 Kb at most)

I have an ADP file created in MS-Access 2003 SP1 that is working very
well.  Unfortunately I have to deploy on workstations having MS-Access
2002 SP3.
I have rarely experienced a problem with this risky behavior but today

I'm building a client/server DB with Access as the front end and SQL
Server as the backend.  I have a subform in which I'm using cascading
combo boxes, however my design seems to be failing!  I've found
several examples, and have used them.

Is there any limitition in no of queries, in stored procedure when we are
working with batch queries?  If so how many queries we can create in batch?

I have an Access Data Project (ADP) in which:
1)  I want to run a stored procedure (that returns no records)
triggered by the AfterUpdate event of a form control
2)  The value contained in the form control (after being updated) needs

I've read through some posts on the ADO vs. DAO question.  Most seem to be
around a year or so old.
So:  I have an Access app that uses almost exclusively unbound forms and DAO
for data access.  A potential client won't accept the Jet backend and demands

By creating a new project in Access 2003, which should be connected to SQL
2005, I get the message, that the SQL Server is newer than SQL 2000 and
Access 2003 does not support this version.
Is Access 2003 not supporting SQL 2005?

I need a query that searches 2 fields in 2 tables. Below is an example.
There are 2 numeric fields in each of the 2 tables containing numbers such
as 51.565842 in 1 field and -0.331336 in another . I need the query to
search the other table and to compare the first 3 digits ie 51.5 ...

I am trying to create a form with a concatenated field to solve a one-to-many
relationship as explained in this example.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'
The example works great, but I can't ...

I have a following problem in my adp/SQL Server project. Having two joined
tables Invoice-Customer on a form frmInvoiceOverview in a Datasheet mode I
need to delete just records from the table Invoice. In order to do this
deletion I use the OnDelete hanler, so my routine looks like:

I have an adp project I have been using for some months now, but this
morning I got the following error:
Cannot create new transaction because capacity was exceeded.
I get the error in a ADO code with a transaction block.

I have a table that has stored images.  I want to link those images to
a form using a bound object frame, on update of a combo box (eg. If I
pick "1" from the combo box, I want the image for record 1 to display).
The table I'm pulling the images from is not the source table for the

I am using Access 2003 and have installed SQL Express 2005.  I don't know
too much about the whole SQL thing but I want to start using ADP.
I have tried to install SQL Server 2000 Developer Edition but am having
error message come up that is stopping me.

How can I add new user in SQL server through Access ADP?
User name should be the same name of windows login and the password should
be saved.
Is it possible?