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!

 

[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 -

 

[Matt]

_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

- Show quoted text -- Hide quoted text -

- Show quoted text -

_OR_ i could USE ranDOm__ CapITAL lett_ERS and uNDErscoreS

 

[dbahooker]

oh yeah?

at least I'm not a _YAHOO_ newbie LoL

_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 -- Hide quoted text -

- Show quoted text -

_OR_ i could USE ranDOm__ CapITAL lett_ERS and uNDErscoreS- Hide quoted text -

- Show quoted text -

 

[Matt]

oh yeah?

at least I'm not a _YAHOO_ newbie LoL

On Apr 13, 4:24 pm, "[email protected]" <[email protected]>
wrote:

_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 -- Hide quoted text -
- Show quoted text -

_OR_ i could USE ranDOm__ CapITAL lett_ERS and uNDErscoreS- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What does that even mean?

 

[dbahooker]

it means I'm not a yahoo fag

yahoo won't be around in 5 years

guarantee it.. either google or aol or msn will buy them

hope you look forward to losing your lifetime email address LoL

oh yeah?

at least I'm not a _YAHOO_ newbie LoL

On Apr 13, 4:24 pm, "[email protected]" <[email protected]>
wrote:
_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 -- Hide quoted text -
- Show quoted text -
_OR_ i could USE ranDOm__ CapITAL lett_ERS and uNDErscoreS- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

What does that even mean?- Hide quoted text -

- Show quoted text -

 

[Tony Toews [MVP]]

What does that even mean?

Unfortunately you've just encountered a troll by the name of A a r o n K e m p f.
I'd suggest ignoring his postings.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[dbahooker]

tony is a mdb faggot i'd reccomend not listening to those dipshits

 

[Matt]

tony is a mdb faggot i'd reccomend not listening to those dipshits





- Show quoted text -

I dunno hooker ... I think you have many more qualities that would be
associated with faggots, from the love of cock to the assfucking of
the english language. dba ... deep butthole action?

 

[dbahooker]

rofl

at least I'm not a MDB _WUSS_

I dunno hooker ... I think you have many more qualities that would be
associated with faggots, from the love of cock to the assfucking of
the english language. dba ... deep butthole action?- Hide quoted text -

- Show quoted text -

 

[Matt]

rofl

at least I'm not a MDB _WUSS_





- Show quoted text -

Well then you do got that going for you.