Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel Automation - Checking if a record in Access is locked
Hello,
I'm writing some code in excel that takes information on a spreadsheet and writes to a table in Access. Basically, this takes information from two columns in a row and finds a match in the Access table. From there it updates information on that record with information from the other columns. Is there anyway for the code to detect whether that record is locked prior to trying to update that record? If so, if I was the user who had it locked and I tried to run this macro from Excel, is there a way I can move the record out of edit status? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automation excel to access | Excel Programming | |||
Excel/Access automation | Excel Programming | |||
Automation between Access and Excel | Excel Programming | |||
Access Automation to Excel | Excel Programming | |||
Access automation from Excel | Excel Programming |