I searched for an answer and tried a couple examples, but i'm still
getting an error message...I am trying to query people whose birthday
makes them less than 19 years old from today:
...WHERE Birthday > DATEADD(y, - 19, CONVERT(char(10), GETDATE(),

I have an access 2003 adp using a SQL 2005 database as the datasource.  I
have a list which uses a function as the data source.  When I execute the
function the results are sorted per the order by fields, but when I look at
the list in Access the list is seemingly random?  Any ...

I have a column that does not allow nulls and it works just fine. When a user
trys to enter a new reccord and leaves the field blank they get an error.
How do I trap the error from the server so I can write my own message and
perform vba code once the user acknowleges the message.

Hello again
I am migrating an MDB/MDE to MSDE/ADE  (both XP).
Currently the front-end (mde) holds several tables which are used to
temporarilly store data for reporting etc. There are also tables in another

I have an Access FE to a SQL BE that has been running fine for several
years.  Recently the SQL part was moved to a new server.  I changed the
connect string to reflect the new server name and my user can get to the db
but she has started getting

I have a table with dynamic values form the a recordset, one matches upto
the other and sets the background images accordingly and everything is
working ok to a point.
Problem is that there are more than 2 options (i.e. types of vehicle) I need

I am encountering a problem in SQL Server 2005 that I have never before
encountered with previous versions of SQL Server. I have an Access
(ADP) client accessing data on a SQL Server backend. A form is bound to
a view and records can be added in the usual way.

I have a situation where I need to create a new table in the current sql
database in my access project and then use the contents of the table in other
parts of the project.  It seems that the project cannot see the new table
unless I disconnect and re-connect the ADO connection.  ...

Using Access XP (with integrated windows security), MSDE and a very very
slow network.
I am migrating a small mdb to ADP and have many instances where I use
"dbEngine.Idle dbRefreshCache" etc.

trying to create ADP front end that will connect to company's SQL Server.
Need help in doing this since this is my first time.
1. Have an mdb form - would like to utilize it in ADP. I migrated the forms
and the tables and code over and am unable to make them work. I don't know if ...

Dear friends:
I am a SQL developer known personally to most of the MVPs ( I have been one
for 5 years, and hope to be again soon).  They know I am a proponent of the
superiority of SQL Server to Jet.  This has been no secret for those 5

I have some problem with datetime in sql server 2005.
In adp project connected to an sql server 2000 when I refer to a datetime
formatting I use something like this:
select * from  aaa where  mydate = '" & me!date & "'"

I have an apllication that uses Access but want to switch to SQL, is it an
easy process and are there any rescources to see.
Regards
Simon

I have setup an ADP linked to SQL on the server.  Here are a few simple
questions that I hope are no too basic for this newsgroup...
1) Each user must be running their own version of the ADP since it is the
front end.  Hence, if 2 people try to open the same ADP file, one will get ...

using mdb, when a user open the mdb file and put his username and password,
the windows keeps username for next time...
but...
using adp, the username's default  always is the connection's username