I have upgraed my ISA server 2004 with sp2 (installed in a PC) memory
from 512mb to 1Gb . After that the ISA firewall service is not
starting. If I remove the extra memory it works fine.Please let me know
anybody having any clue!!!!

Greetings everyone.  I am having trouble understanding how to get a cross
join to work properly.  I am experimenting with a running total and grand sum
feature using cross joins.  My problem is that all the help articles I have
read make reference to 'tablename a' and 'tablename ...

Hi. What is ADP and what it stands for?

When I create a view in Access, it seems to choose to order the fields
differently than from top to bottom in the view.
example
Field1

I have a form with two unbound combo boxes from which a user selects a
month and year of interest.  The form also has textboxes whose control
sources are populated with the names of fields in my (as yet unrun)
stored procedure (actually it's a function).  The form itself does not

I have SQL Server 2000 with access 2003 frontend. The following line of vba
code in access gives an error:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3,
"dbo.TM_ProjectMembers", strInputFileName, True, "sheet1!"

What is the most efficient way to migrate a report from an .mdb to an
.adp?

I am new to the arena of Access 2003 and ADP.  I am converting an Access DB
and application to ADP and SQL 2005.  As a test I created a DB on the SQL
2005 remote (not on my LAN) server and then created a new ADP in Access that
links to it.  I see the tables OK and can operate on ...

I'm working on my first SQL Server application using Access as the front-end.
As I do understand the most simple stored procedures and use defined
functions, I have some things I'm not quite sure how to handle. List below is
an example of what I need to do and my goal is to ...

I have an ADP that was linked to SQL2K, now to SQL2005.  There are
tables that contain lookup columns (the data was an integer link to a
record in another table) that displayed values in easy to read formats.
The columns that were created in SQL2K still work and have the lookup

For the life of me, I can't get this to work.  I have 2 combo box
controls.  I want the value selected in the first box9cboCarId) to be
passed as a parameter to the query underlying the second combo
box(cboPrevWeightEntry).  Here's what I've got.

I'm working on a new SQL 2000 database. Views that are created keep their
SQL, but the diagram pane window will be blank when the view is re opened in
design.
This happens in an ADP and in SQL 2000. Makes it very awkard to change the

The front end is an MS Access 2003 ADP.  The back end is an MS SQL
Server 2005 database.  I have a form that is based on a view.  The view
is based on a couple of tables.  The primary table in the view has an
"Instead Of" trigger.  The trigger automatically generates a value for

Looking for any comments about incompatibilities between an Access ADE (2002
format) & SQL Server 7.
One of my clients is reporting data dropout with an ADE against SQL Server
7/SP3.

I don't know if this was posted prior, but it was recently sent to me
from Microsoft regarding A2005 & sql server as well as other pertinent
info..
http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a-8ff2-22176
9a58ba51033.mspx?mfr=true