I'm using SQL Server 2000 for BE, and msaccess 2003 as FE. I have problem
when I tried to edit design tables in the database which being replicated,
the error message is :
Unable to modify table.

Hi, Lately we have this issue.
Currently we have Access 2003 ADP with backend of sql 2000.
About 10 concurrent users are using bounding form to enter record.
some users record they entered using Form which has two more subform,

After SP3 for Office 2003 was installed last Thursday we have had some
problems.
One of the problems are that Access2003 crashes when we try to select a
value from a ComboBox.

ADP 2003 – SQL Server 2000
Catch 22?
I have a form where I want to have underlying record source of a single
record.  The stored procedure used for the record source is expecting an

I am trying to open some Sybase tables with Access 2007 through an ODBC
Driver and I am getting a Reserved Error -7748.
Does anyone know what is that?
Thank you

I need to get a list of the recordsources of all the reports in an ADP
database application. In a regular Access database, I could use the
following code to derive the recordsources from reports in a database,
but it does not work with an ADP.

I'm having an issue with a form. This issue has just started happening
to the user and I cannot recreate the problem in my test environment.
We have a form that pops up if you make a selection from another
form.  The pop-up form contains 6 checkboxes.  You are supposed to

Can you change a SQL Server Connection string in an ADP program by possibly
using something like a drop down box.

I have an access 2000 project and sql server 2000. On the sql server there is
a complex stored procedure downloading records to a subform. How can I make
the data on the subform updateable? Here is my code:
Dim PLonnraltVer As New ADODB.Parameter, PLRNR As New ADODB.Parameter, RS ...

I have the following stored procedure that compiles fine, but does not run.
ALTER PROCEDURE [dbo].[usp_Order_LISTING]
AS
BEGIN

I am converting an Access 2003 database to an Access Data Project using a
SQL Server back end.
I have a form that is bound to an Employee table and inserts, updates and
deletes records.  My table does not have Employee name, it is another table.

I have installed SQLServer 2005 Express and Access 2007.  I want to use a
SQLServer database (view tables, etc.) from within Access.  I have
successfully opened SQL Server management studio express.
When I am in Access and try to open a database "databasename.adp" I get a

We had problem users not able to keep record into SQL2000 database.
FrontEND users are using Access 2003 with SP2
But couple of user also have MDAC 2.7 RTM version with SP1
And Other (8) users have MDAC 2.8 with SP2 version

Using File>Connection in Access one can connect to database of
choice. My Access application needs to be able to switch SQL
database connections from within the application, without having
to do it in Design Mode.

It's the strangest thing - in access xp the connection page/screen now
shows asian characters, in the label/info areas and text on buttons.  
It's only the connection screen - all others are fine, both in the adp
and in a regular access mdb project.  No where else on my pc, do I ...