Record Sync or check out and lock

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a project that is going to require the ability to "check out" records
for a specific set of records, probably a job or project.
The client wants do disable the selected records so they can't be edited
while the records are "checked out".

I have thought of using the applications forms with a query that has the
records filtered on a [checkedout] field.
Is there a way to copy records from a backend database and then sync or
replace the same records in the main database?

Help
 
You really don't want to physically remove the records into another
database IMHO. That would carry a whole new set of problems.

I'd go with what you've thought of already. Base the exiting form(s) on
a query which excludes the checked-out records. Then have another form,
restricted by password (for example), to set and clear the checkboxes.

Alternatively, use the Current event of the form to stop the user
editing or deleting a checked-out record. Then they can still see those
records on the screen, but they can not mess with them:

sub form_current()
me.allowedits = not me![TheCheckOutField]
me.allowdeletions = me.allowedits
end sub

None of those methods would stop a determined person editing the data
tables directy. However, 1% of effort will keep 99% of users under
control. No amount of extra effort, will restrain the other 1% !

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Back
Top