We have an ADP app that behaves just fine on XP platform w/ Access 2003 and
SQL Server 2005.  One client recently added a Vista Business desktop w/
Access 2007 on it.  On that machine only, when the client asks for any
record, the subform returns #Name? in every field until we ...

We're creating an ADP for an end-user to use to create ad-hoc reports against
a small SQL DB. We're hiding all the usual tools in favor of our own
"dashboard". We've been able to build queries and build reports from the
dashboard, but can't figure out how to present a list of ...

if i will do the linking of MS Access as frontend and SQL Server as my
backend, Is my size of my MS Access program be affected considering i have a
thousand or even a millions of data stored on SQL Server , i am quite
confused since the two connected to each other. Please help.

HI  ITS JAKAYLA

I'm a bit stuck creating a 2007 ADP file.
When I select New -> Filename -> Save as type -> MS office Access
project  -> Create -> Connect to an existing server/DB, Access 2007 header
reports as "Access 2002 - 2003 file format".  I have the default file format

anyone could help me on how to connect my MS access program to sql server for
storage of data. i'll be using sql database instead of built in MS Access
database. i have separate workstation for sql server and separate workstation
for access program. please teach me the step by step ...

I just noticed something strange on  an ADP I'm working on.
I wanted to make a button that would increment through a combo box so I  
wrote the following and bound it to a click event of a button:
<code>

I have Access 2007 on Vista and SQL 2005 SP2 on Windows 2003 Enterprise.
I created ADP from Access 2007, created the connection and Test Connection
was successful.
However, when the database is open up in ADP, I cannot browse any Table or

I have a problem connecting my SQL Server 2005 from a ASP Webpage.
When I trying to connect using the following connection string:
"Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
User Id = xxx; Password=xxx"

I have a view that is filtered by input from the user:
   stLinkCriteria = {user-specified month and year}
   stDocName = "TestView"
   DoCmd.OpenView stDocName, acViewNormal, acReadOnly

I have the following stored procedure in sql server 2000 and I am
trying to use text boses on a form (adp) to pass parameters to this
stored procedure. I then want to use the temp table created for a
report. I have named the text boxes on the form: s_date and e_date and

I can't connect a client computer with windows 2000 to sql server 2005 :
I have 2 kinds of PC clients : with Widows XP Pro (every thing is OK), and
Windows 2000 Pro (no connection to Sql Server)
My problem is only with 2 computers turn with Windows 2000 :

What tipe of data i must use for store a hyperlink in sql 2005 ?
Is possible use a format type of access??
I have installed access 2003 and sql server 2005 , access can not modify the
structure of the tables , why this?? is a problem version???

I am in the process of migrating an Access mdb database to an adp file linked
to a SQL 2000 server. Of course, I'm finding that some of the things I was
able to do in mdb query-by-design pane dont quite work in the SQL design
environment.

Hello...
I've tried
Select @@version
and