Table Locked message

[Tupacmoche]

I need direction in VBA code on how to check if a the data source for a Form is locked or not. Then, I can either continue with a process and lock down the table or open a msgbox and tell the user to try later table in use.:banghead:

Here is my pseudo-code :

If [Buyback Template t].RecordLocks = 1
Then
Msgbox( This function is not available at this time. Try again later)
Exit
Else
Forms(“Buyback f”).RecordLocks = 1

 

[Sweetu]

I need direction in VBA code on how to check if a the data source for a Form is locked or not. Then, I can either continue with a process and lock down the table or open a msgbox and tell the user to try later table in use.:banghead:

Here is my pseudo-code :

If [Buyback Template t].RecordLocks = 1
Then
Msgbox( This function is not available at this time. Try again later)
Exit
Else
Forms(“Buyback f”).RecordLocks = 1

Table or controls on form?

 

[missinglinq]

It would probably help if you tell us, in plain language, your underlying business need, here! In a properly designed db it is seldom necessary to Lock a Table.

Linq ;0)>

 

[pbaldy]

This appears to have been continued here:

https://access-programmers.co.uk/forums/showthread.php?t=291800

I'll close this thread and leave the more recent one open.