I have a form bound to a SQL Server stored proc.  The stored procedure links
2 tables, both of which have a unique index.  I have set the unique table
property of the form to be the table to be updated or have rows inserted -
this is the many join relationship of the select query of ...

I need some assistance
Trying to figure out a way, if possible, to somehow update an adp frontend
once user opens the old adp. Please help!

Access XP
MDAC 2.8 SP1
SQL Server 2000
I have an ADP that I use for reporting that I have used for about a year.  I

I have created my first data access page and this works fine when I run
it from Access, but when I right click on the report then run "web page
preview" I get the errors:-
"You do not have the necessary permissions to use......" then the path

Hi,
An ADE file that is accessed by multiple users returns the following msg when
accessed by more than one user:
The MS Access project will be opened read-only because one of the following

I'm really new to adp,
I created a form with a combo  box (1) to a with a list.
Once I selected a value from combox 1, I want to use that value for my
filter for my combox 2

I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error. I did it under
companyweb.
IIS seems to work properly because other WWW are working OK.

i'm new to this group.
i wonder if i can get answers to my question here, cos i cant find a
newsgroup with database mirroring.
i have two servers :

Losing what's left of my hair over this one, cannot get this to work. Access
2003
-----------------------------------------------------------------------------
FUNCTION dbo.mbtest

I simply can't get around the write conflict problem, even
tough I "googled" quite a lot.
We're running a "Free/Budy" database where several users are chaning
records at a time. In general, users are only editing their appointments

I created some SQL which I incorporated into a query to select a current and
prior record.  After a few second delay, after clicking the button to go to
the end of the query results, the following message is displayed:  At most
one record can be returned by this subquery. I put ...

I wonder which event to use in order to requery the content of a subform
after the user has deleted a record in another bound listform. I understand
that the order of events is BeforeDeleteConfirm, AfterDeleteConfirm, Delete.
So I put the code in the Delete event but it doesn't ...

I build a connection in my start up code.  Access Data Projects save
the last used connection properties.  I was wondering if anybody knows
of a way to avoid allowing Access to connect to the database prior to
my code running.   This application gets distributed to other

I've been using MS Access for the past 5 years, and I've never ventured any
further.  I am now working on creating a more robust application using Visual
Web Developer 2005 and SQL Server 2005 Express.  
Before I get too far into development, I want to ensure that I can upload my

Firstly... Sorry for crossposting (microsoft.public.sqlserver.security) but
I'm desperate and confused :o(
I'm using SQL 2000 on XP with an ADP front-end.
I just set up a test database so I can start figuring out security etc.