I've created an Access Data Project to do some data entry
using a SQL Server database, but I keep getting the
message that the recordset is not updatable.  Is this a
permissions problem?

I have a db that is shared between 17 sites that are
located in different towns. Each site has its own front
end and the back end sits on the network.  My problem is
that one of the sites gets the following message when

I would like to know if there was any way i could find out if MSDE is
already installed on a machine. This needs to be done through a batch file.
Thanks and Regards,
Ayush H N

Tables:
COMPANY: COM_ID, COM_NAME, etc.
   1 Cola
   2 Microsoft

How do I call(execute) a stored procedure using code in an
event within a .adp?
Any help would be greatly appreciated!
Thanks in advance

I have a form for which I have set Max Records = 1 so
that forms loads up quickly. I am now running into the
following issue:
When user clicks on button "Add new record", I have code

I have an application, which on logging on goes through the merge
replication.  I want to confgure my publisher and subscriber so that if the
user is working on the application ... publisher and subscriber
automatically synchronises every 5 mins. Also, I want database to keep

I have an adp project (access 2002, sql server 2000) . How can i get rid of
access menu (without defining a new menu bar) when I make an ade?
Thanks in advance ,
Reza

I am wondering how I can call that screen from vba code?  
Is it possible.
I have a customer that can not remember to hold down the
SHift key and open the application to put their database

I have linked from a regular ACC2002 MDB to a large SQl
table that is uniquely keyed on an nvarchar field. For
some reason, when I search for a record via that key
field, and "search as formatted" is checked it takes

I have an MS Access ADP that is finished up and working
great.  It is testing out perfect, and I am excited.  
Except my London users are having errors.  I traced the
error down, and it is due to the date format differences.  

Using an ADP Access 2003 front end application with SQL Server  backend:
An application form is "populated" with several  controls (textboxes,
dropdown etc).
Some text fields have recordSource datatype nvarchar, other fields have

I have question in mind that if database contains more than 1 million
records, How much data (records or KB or number of pages) that bound form in
MDE and ADP fetch at a time ? I don't think MS Access XP will load all
records when bound form is opened. And Can I control MS Access ...

I am upsizing an Access db to SQL. I have these tables: Products, Brands,
Colors, a Junction table between Products and Colors, and a Junction table
between Brands and Colors. They link in a circle. The idea is to be able to
pick a brand from a drop list and have only the ...

I have read from an old post that if I use Access UI or call DAO in my code,
Jet will be loaded. Is it also true when do that in ADP ? If it is, How to
aviod loading Jet ? Do I have to change bound form to unbound form and
manage all data by myself (programmatically) ?