I have been working in Access (mdb) for ten years and have just started
moving databases to SQL with an ADP front end.  I know there has to be a
simple answer to this question, but for some reason it is not sinking in.  I
have an unbound form with two unbound controls Startdate and ...

Greetings all.  I know this is probably very simple, but I could not find the
solution by searching previous posts.  In SQL2K and ADP I have tblOrderID
with fields ID(int identity), Job# marchar(50), and OrderDate(smalldatetime).
I have a form with Job# and OrderDate as fields ...

When I click on the connection part of my adp, the sql server I normally
connect to is not in the dropdown list. If I type the name it, the
connection works ok.
Anyone got any ideas why this has happened?

I've gotten my .mdb transferred over using the assistant into the dbo
schema - I'm trying do the same thing but in a schema called Tracker.
I'm able to create the tables in the schema with the tool, but when
migrating data I get:

I have been cutting and pasting sprocs in an ADP-- seems like a pretty
natural thing to do.
I am signed in as 'sa'.
I'm confused about why this statement returns the wrong DDL?

Team;
I've got a string like
'hello world grandma'
and I want to find or write a UDF that will tell me the longest WORD

What is the simplest and most efficient way to recreate the  
NorthwindCS.adp Orders form (with the detail subform) as a .asp (I assume)  
web page ?

Greetings all.  The following works very well to filter my dependent combo
lists:
SSI.RowSource = "Select distinct tblmaterials.ssi " & _
           "from tblmaterials " & _

I have problem with this kind of view:
SELECT name, (SELECT 1) as foo FROM table
The result of this view is read only, but only in Access. When I try to open
it in Sql manager, it is possible to change values (in column "name").

I have a DATATIME field that I must display in the MM/DD/YYYY format. The
DATETIME field stores the Date and Time, and that's how I want it. But in my
Stored Procedure and Views I want to only display the Date Portion.
So, I want the value of "10/11/2006 10:20:00" to be displayed ...

I am open to using either a stored proceedure or an inline function to be
able to do this.  I have looked trough all 12 pages in this section and it
starts to talk about what I need and then it goes off on a tangent to where I
get lost.

I have an adp project that includes a main form tied to a query that is
manipulated by a criteria string to filter records when opened.  The subform
is tied to the main form, the record source is the table to allow editing.
The problem is this.....when you open the form the buttons ...

In Access.mdb, I use Forms!FormName!ControlName in the Query criteria
field to filter a query.  I need to do the same thing with an
Access.adp front end and a SQL in-line Function.   Currently, I am
using two LIKE @'s in the function criteria fields to produce parameter

The table in the database has a field called LabID.  That field is an
integer and consists of the year plus a counter.  For example, the
first record of 2006 would be "20060001," the second record of 2006
would be "20060002" and so on.

It might be an old subject, Running T_SQL script froms Access, but I can't
get it right.
I am running Access 2003 and SQL Server 2000.
I generate a SQL script from Enterprise Manager through Generate SQL script,