Hi, everyone.
I trying to connect a SQL Server 2005 to an Access 2003 frontend.  Now
in the past I have not had any trouble, but today seems to be a
different day.

I have converted both my front end and back end to using the upsizing wizard.
I read in the "Access 2003 Bible" that in a client/server environment it is
not good to use bound forms because of having constantly open connections.  
Is there any way to create and access a local ...

In a SQL Server database, I have the following stored procedure:
Code:
ALTER PROC Test_10
AS

The company where I work is installing SP4. Anyone know if this should cause
any ADP issues?
Thanks
Diarmuid

i get an error that says there says no active transactions when i
execute CurrentProject.Connection.CommitTrans.
i am executing CurrentProject.Connection.BeginTrans before.
why?

Access 2002 ADP & SQL 2005 Views
Recently we upgrade from Access 2002 ADP & SQL 2000, to Access 2002 ADP &
SQL2005.
This is cause a a few problems which we are trying to sovle.

Is there a programmatic way to use VB code to set the Primary Key for a
table?  This is for an ADP project accessing SQL Server tables.  Access help
shows ADOX method but my system doesn't recognize ADOX.
Thanks,

I am doing an access project with SQL backend. I am sure this must have been
discussed earlier, but was not able to trace the solution:
i have a field for which i want to formulate the below, except that instead
of 0 for the false, it should allow me an input.

Still working away on my ADP. Originally I took a copy of the Live SQL
database, and made any changes to the copy. So I'm ready to update the Live.
Most of changes are new tables. So I've generated some scripts, from within
table design. Thank MS for the auto script generator, as ...

test2

Greetings everyone.  I need help with a stored procedure.  I need to add a
column to enter a value, either 1,2, or 3 depending on the value of another
field in the query.  For example, if the value of the independent field is
'apple' I need the new dependent field to populate '2' ...

I have just converted several mdb's to adp's and now would like to migrate to
a web based product like .ASP.  Does anyone have any recommendations as to
which product would be the most practical. I have about 150 users on military
bases and it is a real pain every time I make a ...

I've done the upsizing of my Access database with the SSMA wizard of Access.
This has worked well, but I've got the following problem:
On a lot of places I have this code:
   Set DB = DBEngine.Workspaces(0).Databases(0)

I apologise if this is a question that's been answered everywhere else.
This week I'm helping out the employer of a friend (Kelvin Wilson) who died
recently. Kelvin has a nice .adp which connects using Windows Auth to a SQL
box.

I am missing something very basic that I need so I apologize for my inability
to grasp the obvious (because I'm sure it is) in advance.
I had an .mdb that I have converted to .adp.  There are many forms that
provide the criteria for either the underlying queries or recordsets such ...