Hi
Trying my best to make a conversion from Access mdb to a
project - but continue to hit some walls....
I have an up and running access mdb with linked tables

I am using SQL code I thought.  Can you guys help me with the following
code?  I am having a problem with the following line:
   objConn.Execute szSQL, , adCmdText Or adExecuteNoRecords
   Dim objConn As ADODB.Connection

On Form1 I have a list control whose row source is a
query.  When a row is doubleclicked, the record ID is
passed to Form2 to display the specific record in full and
refresh the Form1 display in the form_afterupdate sub.  

I have an .ADP and have no difficulty creatin the SQL conenction
My quesiton is "How often do I need to do this?"
For example, I have the following code:
Function fctBreakDownOrder(OrderID As Integer)

I have come across a problem with an Access 2000 or 2003 report where the
record source is a SQL Server 2000 database Proc when the Proc creates and
selects from a temporary table. The proc that I built was working fine, and
the report could 'see' the fields from the Proc until I ...

I am using Access 2002 as the front end and SQL Server 2000 as the back end.
It is a large app with 75 to 100 user at a time.
I am trying to cut down on the number of connections I have in Access.  Like
combo boxes that are populated using addNew instead of a query.  However,

In a previous post I've learned how to switch programmatically from two
database servers on two computers.
At startup a .ini file is read and the proper server is set.
Unfortunatelly it looks like the .adp project saves on exit the last server,

i have several questions, because i'm quite new to SQL-Server and Access
Projects. Till now i only worked with Access.MDB's
i created a new access project and have my database on SQL-Server. I see all
tables in my access-project and can work with them.