Our shop has used ODBC linking to SQL tables from MS-Access for many years.
I have recently noticed a problem and I am not sure how long it existed
and/or if there is a fix. Our environment is Windows XP(SP2), Office
2007/MS-Access 2007, SQL 2005 and SQL 2000. The error occurs ...

I'm using Access 2003 with a SQL 2000 back-end.  I have an OnClose event in a
form that calls a function, and the function calls a Stored Procedure in SQL.
There have been occasional strange results where it looks like only the first
portion of the SP executes, and I have not been ...

I have a table in sql that was imported from MS Access. One of the feilds was
a memo feild and now is a varchar with a length of 2000. The problem I have
is that there seems to be a lot of trailing spaces which cause problems when
runing reports. I use the Can Grow property and some ...

I have done some Access work in the past, but keeping an Access
Back-end.  I recently had to up-size to SQL for an ADP file without much
research or preparation.  I've been able to pass parameters to queries
and reports from a form by using =[forms]![frm_Name]![region] and the

Could you please help me on my problem?
im using ODBC connection on SQL server as backend and MS Access as frontend,
however whenever i tried to connect on on ms access, it always pop the
Microsoft SQL Server Login and i had always login my username and password

I have a database to log annual appraisals. It holds details of each
appraisal, including date, and the year of the appraisal, recorded as
'2005/6', '2006/7' etc. I wish to identify all those who have not had an
appraisal in 2007/8. The SQL below, of course, does not just ...

I have a UDF with two parameters and I'm trying to pass multiple values to
either parameter and can't figure it out. I'll show what I have tried.
Me.RecordSource = "SELECT * FROM fn_QcQuestions(IN(1,2,3),In(4,5,6))"
Me.RecordSource = "SELECT * FROM fn_QcQuestions(1 OR 2 OR 3, 4 OR 5 ...

I need to review the SQL statements of queries in Microsoft Access. I am
opening each one individually. Time consuming and tedious. Is there a way I
can download these queries and only their SQL statement to one table, excel
or word doc?

The following dynamic sql, compiled as a stored procedure, returns the
correct number of rows but only the columns from the first SET statement.
It's as if it executes the query which is the concatenation of the first and
second SET statement without the SELECT in the middle. ...

I have a form in Access mdb that I am trying to get to work in adp. In the
mdb version, a query underlies the form. One of the fields in the query is a
check box, the value of which is pre-determined by whatever item is selected
in another field on the form. In other words, there ...

any tips on creating ribbons for an access adp project.
I cannot get the database to read the USysRibbons Table and display
customized ribbons. Thanks
- Alibaba

I have an application written as an Access 2003 ADP. As long as an ADP is
supported in an Access 2007 environment I do not intend to switch to a MDB
with ODBC.
Are there any issues when migrating to the Access 2007 environment I will

I have a database form that has two lookup tables.  The entire DB has roughly
ten colums and six tables in it, but one requires a complex query.
  My database deals with antiques.  I have one table dedicated to types of
antiques, and another table dedicated to specific antiques.  ...

Does anyone have a downloadable version of Microsoft Frontpage
server-extensions 2000, becasue Microosft have stopped supporting the
downloadable version on their website.
Arjun

I have an Access adp that I need to allow the users to import data from a
csv file.    I am using SQL 2000.    The syntax I am using is
DoCmd.TransferText acImportDelim, , "dbo.Pack_Cell_Screen", strFilePath, True
It interprets the table name as dbo_Pack_Cell_Screen and therefore ...