A trigger that is assigned to a table does not display an
error message when the trigger is executed

I'm migrating several small-scale Access applications to MSDE/SQLServer; my
question relates to security.
My customer sites tend for the most part to have their PCs networked in
'Workgroups' - ie. no domain controlers.

Is it possible to use Access front end Sql Server backend
without the data project. If so where do I find info on
the procedure to set up the configuration.
TIA

I am using Ms Access 97 on Windows XP Profession and use
MS SQL for the database by using MS Access 97 for
interface. I have got an error when do update query and
the error is "Operation must use an updatable query.

I have an Access XP ADP connected to SQL Server 2000 with a header/detail
form which is made up of the main form connected to the header table and a
linked sub-form connected to the detail table.  When trying to add a new
header record I get the message :

I have XP Professional with Access 2002 and a Win2000Pro
running SQL 2000 connected through a hub.  Both machine
see each other. My access to all the SQL functions on the
Win 2000 machine are fine using the Enterprise Manager.

Upsized Access 2000 to SQL Project, the Switchboard
Manager menu item is dimmed. Any reason why Switchboard
Manager is not available in ADP project?
Thanks

am using adp -> sql server and have a form with a subform on it.  when i try
and add a recording in the subform, i get this error:
"Cannot find object: "
I have debugged and traced but there seems to be an event that fires that i

I recently reinstalled my WinXP home edition, and everything works fine
except for my Audio Device. I've tried uninstalling/reinstalling the device
driver, but all attempts fail. In the Device Manager, under Sounds Video and
Game Controllers, everything says that it works fine. Has ...

An ACCESS 2000 project is connected to SQL Server 2000
database.
When I open the "Data Links Properties" dialouge box and
click on the Advanced Tab, the "Access Permissions" has

When I make a new View in Access 2000 Adp I get unwanted Expr1..2..3
Aliases. I add two tables. From the first table I select * (all columns),
from the second table I select one column. This column gets automatically an
Expr1 alias. This should not be the case since the column name ...

Can someone please tell me how to update a database field with the Image
type ?  For example, I have a .gif file on my C:\ drive that I would like to
add to my database.  How do I do that ?  Insert into Picture Values ( ???? )
Thanks,

Can someone point me to some good books/references specifically on improving
performance for adps and/or on form design strategies?  We're using SQL
Server 2000 and Access 2000 adps made into ades, Windows 2000 network.  We
now have several sites across the country accessing the SQL ...

I have a stored procedure that I want to use for the
record source of a form. I can put the record source in
the properties box as "Exec ip_rpt 12345" where "12345" is
the parameter I am passing. Now what I need to do is to

I'm moving an application from being a pure Access MDB to an Access 2000
project against SQL Server. I have encountered one situation which has me
frustrated for lack of an easy solution.
In the MDB code, I had one dynamic SQL string to execute that was about 3000