Topics Search

Lock Record for Editing on a Linked table

Lock Record for Editing on a Linked table
Views: 7
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:
Sponsored Links:

Similar posts...

 

What views lock a table from being edited by another user?

What views lock a table from being edited by another user? Icon
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 field after editing

lock a field after editing Icon
Last year I asked the question is it possible to lock a field after editing. Lysander (thanks Lysander) gave me the following code:

Then in the After_Update event of myName put the following code

1) myAddress.setfocus
2) myName.locked=true
3) myName.enabled=false

I have used this this morning (in a different project to the original question) and it works while I'm still in the record. However when I exit the record and re-enter it the field can be edited again.

Is there a way I can lock this field so that it can never be edited. I don't really want to lock the whole record if I can help it.
 

Spurious record lock

Spurious record lock Icon
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?
 

UPDATE only where form value is different from table value

UPDATE only where form value is different from table value Icon
I am not sure if this is possible without many lines of relatively redundant if/else statements, but in my quest to be an efficient developer, I ask the masses.

I have a subform that I have set to open (via button) and view the currently selected record based on a separate subform. This form will be used for editing the record, so I can lock down the previous form to prevent accidental changes to data.

On the subform for editing the data, I have a button to save the record, which I am going to code to run an UPDATE to the table.

Is there an easy way to compare the value on the form fields with the value of its corresponding column in the table, and return either a boolean or integer, then use that value to UPDATE only the fields where the data has changed? I want keep this as streamlined and dynamic as possible,

There are about 20 fields that could possibly be changed, so you can probably see my hesitation to write an individual statement for each one.

I am currently exploring the use of some creative FOR statements in VBA to pass values through variables to the SQL statement, but I figured it wouldn't hurt to ask here whilst I grind away,in case anyone had any ideas off the top of their head that I had not come up with.

I am not a very experienced developer,
 

Lock records in a table based on a value of a field

Lock records in a table based on a value of a field Icon
In my table named "Commandes", when the field [Nom de l'état] value is "Payée" (3), I would like that record to be lock and a message that popsup saying that this record is paid, please select another order.

In the image below, you have details of the Réf Statut field that is the ID of the status in the table [État des commandes]

Sometimes when opening a form, I retrieve data that was already paid, if a user is not concentrated, then, he might change data in that record, that is the reason why I want to lock the records in the table "Commandes" that are paid.
 

Access: Locked Table for Editing

Access: Locked Table for Editing Icon
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. Theediting functions delete, cut, we can still filter the data.

If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
 

Editing one table and the same table in another folder update automaticaaly.

Editing one table and the same table in another folder update automaticaaly. Icon
I want to make a back up all records that a table may contain. The same table and the same form with same fields,I want to update records in one form and save the records in corresponding table.

So after some time I want the same record that is saved in one table is updated in another table. This table and form is in separate folder just for back up. I mean editing in one table and auto updating in the same table in another folder.

That is one for Back up and another one for editing.
 

Editing fields in a linked table

Editing fields in a linked table Icon
I have 3 tables linked together. Customer, Fillers & Service. All three are one to many.

I'm trying to change the name of two or three fields in the Service table, but it causes a pop up when I open the database. I tried to delete the field with same results.
 

How to locate linked tables automatically.

How to locate linked tables automatically. Icon
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?
 

Subform goes out of touch when its table is edited?

Subform goes out of touch when its table is edited? Icon
I have an Access 2007 subform linked to the mainfor, and they were both working fine. it linked on the proper parent/child link, edits on the subform tracked the proper parent record, etc. etc.

Then I edited the table bound to the subform simply to make one of its text fields longer; that's all!

Now, data from the subform table does not show up in the subform at all.

I can still add a new record via the subform, but I will only be able to see it briefly (while initially entering it). if I go to a different mainform record and then return to the one that should have the new subtable record, again, it doesn't show.

However, looking directly at the table for the subform shows that the new record (and the old ones) are indeed still allproperly there in their table.