Search results

Looks like I have a solution... A bit of further googling has turned this up.... //stackoverflow.com/questions/14349671/why-is-my-sql-server-auditing-trigger-messing-up-obdc-call-referesh-from-access ..it looks like Access does pick up the ID of the last inserted record as it uses the...

I agree that the trigger shouldn't be causing an issue but it definitely is.... If I disable it, then the form returns the correct record. The problem has only started occurring since introducing the trigger, and the system has been in use for 10 years! There have been no changes to the front...

The code in the form is literally just using DoCmd.GotRecord,,acNewRec with the form itself bound to the credits table. The trigger is as follows - the AUDIT_CREDITS table has an identity column called AuditID which is it's primary key: ALTER TRIGGER [dbo].[TRG_AUDIT_Book_Credits_INSERT] ON...

Hi all, Am looking for advice regarding a very odd problem.. Our booking system is an Access 2003 front end on a SQL Server 2000 (I know..!) back-end. Our finance department have asked us to implement an auditing solution to enable them to track changes in key tables. I've implemented this...

Hi New forum user here. Been using Access since 2000 on and off with a fair bit of development experience. In current role I'm IT Manager for a small holiday company in Devon who use Access to front end their SQL Server booking system. Cheers Jon