is there a recommended way to build up n:m relations in forms that
reside in adp projects? How do you deliver and fill and update the 3
created tables in one form?
Any idea, link, old tread or faq would help.

I'm using Access 2003/ADP and SQL Server 2000 on Windows XP
I've got relational constraints setup in my SQL server database. So, for
example, can't delete a customer who has orders.
I've bound a form to the customers table. In datasheet view, I delete a

I have an .adp project that accesses SQL Server. I want a customized version
to prevent users from changing form/macros... So, I modified the Startup
options (Tools/Startup) so that the user was presented with only the features
that I wanted them to use.

I am thinking of setting up the security for my current Access 2003 Project
with MS-SQL 2000 in the following way and would like some comments and tips
about it if possible:
- We use SQL Server 2000 with integrated authentication

I have an ADP front-end and on click of a save button I run the following
code:
me.dirty = false
me.requery

I am trying to convert an MDB to ADP and have gotten hung up on a report.
The report has the Record Source property set to the following,
SELECT DISTINCTROW [ClassesDueQuery].[Title], [ClassesDueQuery].[DueDate],
[ClassesDueQuery].[EmployeeNo], [ClassesDueQuery].[StaffLName],

I would like to set the User_Name() and GetDate() in a table before my
insert and update triggers start. Is there a way of doing this before the
trigger? Right now I update these fields after the trigger but it ends up
causing an unnecessary re-trigger to update the fields and I ...

I am have some very strange behaviors in my modifying my adp file.  When
trying to open or create new file the screen flashes yet I do not have my
stored procedure screen I just go back to the object window.  I am able to
modify the code on my forms.  I am also able to trace code.  ...

I'm using a ADP project file and I'm having a problem with this command :
DoCmd.TransferSpreadsheet _
   acImport, _
   acSpreadsheetTypeExcel97, _