Record Lock Problem

[Matt]

Hi All,

I have a databse that runs queries against an ODBC source throughout
the day and night. I am having an issue where a query will run at
night and throw an error message about not being able to append due to
record lock. What could be causing this? Is there a way to ignore
the message? Any suggestions to avoid this?

Thanks in advamce for the help!

 

[Jim Bunton]

You could:

Run the queries from code which traps the error
Writes a message (including time error message etc) to a table
Then resumes at the point following the error

[On Error goto xxx
:xxx
Write error to errors table
resume next
]

Hm! might be an idea to count the number or errors as you go and give in
after a given number incase you get into an unescapeable loop!


Then wake up in the moring and see what and when been written to your
'Errors' table

 

[dbahooker]

_OR_ if you want a REAL solution

a) use Access Data Projects
b) learn SQL Server
c) don't rely on macros for ETL; learn something like DTS or
replication

You could:

Run the queries from code which traps the error
Writes a message (including time error message etc) to a table
Then resumes at the point following the error

[On Error goto xxx
:xxx
Write error to errors table
resume next
]

Hm! might be an idea to count the number or errors as you go and give in
after a given number incase you get into an unescapeable loop!

Then wake up in the moring and see what and when been written to your
'Errors' table

Hi All,

I have a databse that runs queries against an ODBC source throughout
the day and night. I am having an issue where a query will run at
night and throw an error message about not being able to append due to
record lock. What could be causing this? Is there a way to ignore
the message? Any suggestions to avoid this?

Thanks in advamce for the help!- Hide quoted text -

- Show quoted text -