I'm using the standard filter and sort functionality in a datasheet view.
I'm finding that both the RecordSet and RecordsetClone properties are the
same even after filtering and/or sorting.  The RecordSetClone should
represent the data after filtering and sorting.  Instead they both ...

please help me out here:
(adp + MSDE)
I have a very simple view:
select tableA.fieldA + ': ' + tableB.fieldB

I have an Access 2002 ADP.  I created forms for my tblMbrInfo table and
tblCurrentFinData.  The main member form that is used to
enter data has a button that launches the Current Financial Data form.   If
a new member is entered into the database, if i click on Current Fin. Data

In access, we can create query on fly using QueryDef.
can we do the samething in adp
TIA
Jerry

I'm experiencing an intermittent problem in my Access ADP where report and
form requests seems to timeout.  I have never experienced on my computer, but
I have witnessed it at my users' workstations.  The network admin says he can
see the request hit the SQL Server, but says it's ...

I have imported all objects from an mdb (2000) to an adp file
all connections to tables and views working right
but when i enter to the code i get:
"error accessing file. network connection may have been lost"

I have an access front end which is attached to a remotely hosted sql
server.  My lovely database developer wandered off on an extended vacation
for an indefinite period of time without telling me.  I am an ASP.net
programmer with experience in Access and database design but I ...

Someone, please help me--even if you give me just a hint!  :-)
Hello
Issue 1: I have a list box on a form, which is populated based upon the
entries made in various text boxes, and upon the Search button being

I want to migrate all my db into an adp project connected to SQL server
2000.
I'm wondering what is the best way to retrieve values from a table and use
them in my vba code.

I've create an adp file that uses SQL Server authentication. Problem
is that alot of users use this same file and they do not want to see
the default username when they login - they have their own usernames.
Everytime they connect to to the database, they regularly have to

I use MsAccess 2002 on a Windows XP platform, together with SQL Server 2000.
I installed SQL Server on my XP machine prior to installing Service Pack 2
for XP. Everything worked fine: could use the Upsize Wizard, ADP etc.
After installing Service Pack 2, I can no longer get a ...

I'm trying to constuct an SQL statement in VBA code to create a table in a
separate database. I have stored the path and name of the destination
database in a variable. The code runs but the resultant query has the name of
the variable as the destination database rather than ...

This may sound a little weird ... I have a table with data, some records
have field "OrderNo" NULL, and others have it as value = 1
If the value is null i need to run one sql and return the result, if its "1"
then it should run a different sql and return another result, so that at ...

is there a way to log off a user from an ADP so that another user can log on,
without having to close down access?

I have a table with one field(varchar 100).  I can't add a record to this
table anywhere, in the table on a form.  This is a .adp file with SQLServer
and other tables work fine.  The add record button in the table view is not
enabled?