Isloaded works for table? 1

[gertNo1]

Hey Guys, got a question. Can you use the "CurrentProject" and the ISLOADED function to tell if a table is open? If not is there a way to tell if a table is open?

Thanks

 

[gertNo1]

Even better, is there a way to tell of the table has been updated? Whenever someone updates the table the owner wants to validate it.

Thanx again,

 

[jrbarnett]

Is there a way to tell if a table is open:

If SysCmd (acSysCmdGetObjectState, acTable, "TableName") > 0 Then ' Table is Open

It returns 0 if the table isn't open.

For table validation, as Access doesn't support triggers you either need to lock down the interface and use forms with code to audit the changes, or restrict entries using check constraints, primary/foreign keys etc to only valid values.

John