First, sorry for cross-posting, but as I have flexibility on how I do this,
I thought I'd post it to the two most-relevant groups.  I can do this either
server-side, using a stored procedure, or I can do it client-side using VBA.
The recordset is only a few thousand records, and ...

Can someone tell me what versions of SQL can connect to an ACCESS 2003 data
project?
Specifically, can a 2003 adp connect to a sql version newer than 2000?
Thanks for your help,

Is it possible to connect to SQL Server 2005 from an APD project.  When I
pull down the connection menu, it only shows the SQL 2000 server and does
not show the SQL 2005 server.  Am I missing something simple here?
Ed Warren

I have a client with an access 2002 frontend linked to a sql backend.  I need
to add a new field to the sql backend from access.  I'm new to sql backends
and work offsite so I don't have access to their sql server.  I am tring to
set up a wrkodbc.connection but am not sure of the ...

the access to the application is with sql server Authentication
for login i use a login form
but before it opsen's there is a system login prompt
how can i cancel this prompt?

I have used an ODBC connection to link an MDB to MySQL, but I also have an
ADP program connected to an MSDE database, but need to also fetch addtional
info fom a MYsql datgabase.  I have been unable to establish such a link.
Can someone point me at an explanation for how to do this?

Is there a way to close a connection in an adp/ade after a certain period of
inactivity?
Thanks
Bill

We have developed an Access/Jet database (2000, XP & 2003 versions) that has
been used by clients all around the world for several years and is extremely
robust with 55 tables, 172 hard stored queries (plus about the same in VBA
SQL code), 60 forms and about 18,000 lines of code. ...

I am migrating date from Access 2000 to SQL Server and am trying to deal
with replacing the IIF with an IF.
In the simplified code below, I am getting an error around the IF statement.
Could someone let me know what's wrong here?

I have a Microsoft Access front-end for a SQL 2005 database.  The Access
front-end was in SQL 2000 and worked perfectly.  When I migrated it to 2005,
I relinked the database and I can view the information, but I am unable to
add anything to the database.  All of the Add Record ...

How do I do this in an ADP?
UPDATE tbl_QuoteDates INNER JOIN Quotes ON tbl_QuoteDates.QuoteId =
Quotes.[Quote ID] SET tbl_QuoteDates.CustomerID = [Quotes].[CustomerID];
It appears as though the update statement cannot have joins?  If so, then

I need to count how much "assenze" I have in this query, as cover is a text
field I try to use the IIF as you can see below. BUT It does work! Damn.
Query = "SELECT Sum(IIF(cover = 'NO', 1, 0)) as assenze, SUM(stato) as
daypresidio  FROM copertura  WHERE day between '11/12/2005' ...

I'm converting a MDB database to ADP and I have some problems:
1. Is it possibel to find any function in SQL server to replace Format,
left, mid functions?
2. I know, we can not use my VBA functions in SQL server.

how can i make a simple Select Query with VB in Access (.adp)?
Thanx a lot

I have been looking everywhere to track down the answer to something that I
suspect is simple but it has eluded me!!!
I am using an Access 2003 ADP project with an MDSE backend.  I have just
recently used the wizard to change from and .mdb to an .adp.   I have an