Related Topics

Linked Table lock

Locking specific records via check box
I have 2 tables which are linked, the first table contains "Referral" info, linked to this is an "Activity" table. Both tables have separate forms. The PK on the Referral table is RefID and is obviously a FK in the Activity table. What I want to do is lock records in the Activity table if the master record in the Referral table has a check box ticked (this tick box being Discharged). I dont want user to be able to add to the activity table if this is checked in the Referral table using RefID.

I have done something similar to this before where there was a subform and I had used AfterUpdate to lock the subform, but I dont think this is quite as straight forward.

Any ideas on links to other threads/sites with a solution?


What views lock a table from being edited by another user?
How do I handle multi-user editing and updating of one single table? If I'm in datasheetview does that lock the table?

If I'm in a form view does that lock the table?

I don't want the table locked, as I want one user to be able to insert a new record at any time and still allow poweruser to edit current records.


Lock a record
I have created a payroll using access 2007. is there an option to lock only one specific record rather than the whole table.

For example, if John is no longer an emplyee I want to lock it and never be able to unlock it again


lock a record
I have created a payroll using access 2007. is there an option to lock only one specific record rather than the whole table.

For example, if John is no longer an emplyee I want to lock it and never be able to unlock it again.

if you can help me in the sample file


Spurious record lock
We have Access 2007 linked to a SQL 2005 database through an ODBC link. We recently removed a couple of old unneeded fields from a table in the database, but it turned out that they were needed somewhere in another application, so we re-added the fields in SQL 2005's Enterprise Manager and refreshed the links in Access 2007's Linked Table Manager, and all our Access queriesand the other application continue to work fine except that now when we open this table in Access and attempt to modify *any* field directly, we get the standard record lock message("This record has been changed by another user since you started editing it.

If you save the record, you will overwrite the changes the other user made.") even when no other user even has Access open.

This does not happen in other tables in Access, and did not happen in this table before we deleted and re-added the fields in SQL 2005. We can still modify fields in this table using a query - *except* the fields that we deleted and re-added, which now give the record lock message even if we attempt to modify them using a query.

We tried running the Compact and Repair function in Access, and rebooting the system, but the issue persists. How can we fix this?


Record lock when Checkbox (Yes/No) is Yes
I have a ECN table which contains many fields including ECNID it's related via relationships to another table containing part numbers linked to the ECN record in the ECN table.
The ECN table contains a 'Closed' checkbox (Yes/No) field.

What I want to do is lock the ECN table record and the related Part Number record(s) when the checkbox is ticked (Yes).
Can anyone let me know (a) if this is possible and (b) what I need to do


LockNavigationPane Action Disables Linked Table Manager
The title pretty much says it all. I am attempting to lock the navigation pane in order to keep users from accessing certain objects so I have an AutoExec macro that disables certain categories and then sets the LockNavigationPane action to true. However, I've noticed that as soon as the macro runs Access grays out the Linked Table Manager. I've confirmed it is the LockNavigationPane action that causes this by running just that one action in the macro and, sure enough, no Linked Table Manager.

This doens't make sense to me, and google hasn't been any help so far. Has anyone encountered this or found a way around it


How to locate linked tables automatically.
I have an MS Access database that has a linked table. For various reasons the location where the database and linked table is stored changes. Is there a way to store the linked table so thatI don't have to go in and update the location in the linked table manager? Like can the linked table be in the same folder as the accde file and it find the links?


Lock table contents?
I'm working on a school project where I'm creating a map editor for a game using C# and WPF. I have to add a load of monsters in the map and decided to create the database for this with Access. Each one of these monsters has an alignment like "berserk" etc. The list of these alignments is static and nothing should be added or removed from there. So I have a table and was looking thru the properties of the table but nothing seems like "lock table" or "disable deletions" or anything like that.

So, shortly: How do I make the table static i.e. lock the content


Field lock after entering data
I have a form that I need to lock the field (text box) after I enter the data (and unlock it if I need to update the data). I don't want to lock the entire record since other data in the form is changed periodically. It would be nice if it could lock during a save function.


lock link tabe
I created a database by access 2007. Finally, I want to lock my accdb file that so nobody can't link table my accdb file by other accdb file . how I can lock | link table and link query?


Lock table
Is there a simple way that I can lock a table or better yet configure it as view only. The table is used to populate a combo box in an entry form, and I do not want anyone to have the ability to add records to the table (options in the entry form), but I would like them to be able to view the table.

I don't need a robust solution with passwords. I would imagine there is a simple preference to set, I am just not seeing it.


Lock table
Is there a simple way that I can lock a table or better yet configure it as view only. The table is used to populate a combo box in an entry form, and I do not want anyone to have the ability to add records to the table (options in the entry form), but I would like them to be able to view the table. I don't need a robust solution with passwords. I would imagine there is a simple preference to set, I am just not seeing it.


Lock Record for Editing on a Linked table
I have linked tables front end application running on network drive. The data is becoming huge and the users are becoming more, as a result the application become slower.

Now, It has been decided to get the necessary tables data in a local tables when application starts, update it locally and then update the original database on server finally.

Everything is done and working fine.

The problem starts here:


textbox on form is stuck on lock
I disabled my lock feature on the form. and within VBA there are no lock commands. I am wondering what else I can do to disable the locked textbox on the form.


Can I lock out fields in a form by keying off...
I am trying to lock out 7 fieldsin a subform by keying off a value of a textbox, I want the 7 fields lock or non editable. how can I do this


Conversion made on Field type for liked tables
I have a problem related to filed type.
I have a linked table using ODBC. The table linked has improper field type: all numeric fields are linked as decimal. Because of this if I want to import the contens of this linked table in one new, the database has high dimension.

Please help me to find a place where I can set the field conversion for linked tables or to make Access to performe the better type conversion (if the field is integer on source table to be integer on linked table as well and so on


Linked in Table
We have an access database which was created ages ago and the creator no longer works here.

It is one mdb (Unit.mdb) with a linked in table to another mdb (UnitBE.mdb), however if we move the linked in table it will then fail (cannot find .\UnitBE.mdb). However I cannot find out how to amend the linked in table path.

The "Linked in table" manager is greyed out


Lock column width in datasheet subforms
I have a couple of very simple linked subforms that I'm trying to keep as clean as possible. They're both in datasheet format.

There should be no need of resizing columns on either; but if the user plays with the forms, they can drag them out, which results in a) horizontal scroll bar, and b) potentially inconsistent column widths as the child form updates from record to record.

I've tinkered in the properties for each of the text boxes, but can't seem to lock them down.

Surely I'm missing something simple


Finding ODBC table used by linked table?
Let's say someone gives you an Access database. You open it up and there is a linked table there. You can mouse-over the linked table and you see there is a connection string that names an Oracle database that you have on the same system.

Where do you go in Access to find out which exact schema and table within that Oracle database that your linked table is connected to