Thank you for every awesome videos you are continuously sharing to the world, your tutorial is so clear and very alive and quickly to understand. I love watching movies but your tutorial bit them all for its very interesting than Hollywood movies. Thank you so much sir:)
I have three buildings im responsible for and it is important for the databasse to differentiate which building they accessed (visitor log). Is it better to make three visitor logs (tables), one for each building or one large tables with three different front ends? In terms of speed and efficiency....
How can I set specific record locking if a certain condition has been met? For example, a case where one may register as a group or as an individual to set the record field for group name locked only of one has selected to be registered as an individual.
I have multiple users at three different buildings. It is important that each building log visitors and include location. I have set up one front end and back end for now. I will eventually make three front ends. But is it is better to have three exact tables (one per building) or one large table for all three buildings. I am thinking in terms of speed being, locked out etc... Is the speed affected if all one table and ends up being alooot of rows.
I am expanding into access from excel and I love your videos. Every time i close the database it locks me out. another locked file is created and the only way I can get back in to edit is to restart the computer. How do i stop it from locking me out. I am the only user on it.
Thank you for this lecture Sir. For a database of a small institution, is there any need for a web interface? If so, how does one link Access to vs code?
I have a situation with a split database where users enter new records and one of the columns is auto generated. For example, two users might be trying to enter new records in the same table and both of them are assigned ID Number 123456 for their respective record. What would be the best configuration of record locking, if any, for that situation?
@@599CD I have a similar situation, when two users input their records at the same time, only one of them is kept. Both are entering information for different clients.
@@599CD Hello Sir, I am trying to generate the QR Code but I don't know how to display it. I did convert the it to Hex and to base64, but still i couldnt display it.
Only problem with this video is it doesn't address the issue of write conflicts caused by bit fields. I've set up a database where I was the only the user of that database and would get write conflicts on a table I copied that contained bit fields. The write conflict also affects table level editing. Resolved this by going on the server and in design setting all bit fields to default of 0.
Can you do a video on access and one drive sync issues? I have a split database that is constantly running in to problems due to the file trying to sync to one drive. My entire remote computer is on one drive so I don’t know how to get around this?
Yeah, I have a video coming up on this soon, but the bottom line is DON'T USE OneDrive, Google Drive, DropBox or any of those file sharing services with Access. It will corrupt your database! See 599cd.com/AccessOnline
If you have continuous form. Should I use can still use "open database by using record-level looking"? I mean what is the best sitting for large database once you have continuous form and you want to keep your database with high performance efficiency.?
I have a different locking issue. When one user opens up the shared database it creates a temporary 0kb file with the same database name and a lock icon on it and no other user is able to even open the database file. Others users just get an error that says file is locked and it stays that way until the user that has it open closes it. I am not sure if this is some sort of group policy effecting this.
I am having a write conflict issue same as here but my backend is connected to a sql server, i am the only user, i close everything and reopen i get them same issue. How do i resolve this plz ?
What about different FE. If I put record locking in FE1. But FE2 , FE3 and FE4 are working. Their forms hv no record locking...can they have the issue if FE1 is not on?
pls i need help, i made hr/account application using access. I split it then I save my back end in google drive and i distributed my front end in different computers. When i open it on my side (while the other are also using it) and make some update like editing some information or attaching pdf/jpg file , it showing fine and i can see the updates, but when i log out early than they other users that doesn't edit anything, it seems the data will stay the same without my update. the problem is fetching data from the other user is delayed..so if the last user doesn't do anything, it will fetch the old data from that user's computer to my back end which is in google drive. its hard to explain but i hope someone can understand. thanks
If I set this sitting and save it as accde And disrputed to other users, Dose the sitting still apply to them or I have to make the sitting for each user?
Hi, first of all i wanted to mention that your own version of locking is much more user friendly. I want to ask you about some extras on your version. Is it possible to place timer, in order to prevent user having the x record in edit mode for a long time? Suppose i edit a record and i go out for a lunch or break , and leave it in "edit mode". Then other users cannot edit it. I have also seen in my job that that several users can edit the same record at once, no error message is appearing, but there is an audit trail table that keeps all the changes. I believe the same can be done here, based on both your audit trail video and this one, is my thought right? I will try myself to implement myself the above thoughts in Access Once again i like the material you provide. Keep going!!
Sure. I don't see why you couldn't implement both of these things. I have a "clear record locks" button in my database in case for some reason there's an error (system locks up, etc.). No reason why you couldn't put that on a timer.
Sir I am facing following error on changing the record it is important to tell you that my backed database is MySql. do you have any guide video on this issue ? The Data has been changed Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.
Nope. In fact I've never used MySQL. I'm working on an Access-to-SQL-Server video right now. But yes, if someone else has edited that record, you'll get that problem.
This is not very useful when multiple users are trying to edit the same table regardless of rows since it locks everyone out of that table. It's like having an excel sheet that is not shared. I do not like this solution. Sorry.
@@599CD That's what I thought too but for some reason, it kept locking the entire table. I ended up using code as a workaround with recordsets. At least now it does not lock any table or any row and still prevents write conflicts. Just need a lot of coding tho and I hate writing code in MS Access. I got spoiled by visual studio C# lol
Thank you for every awesome videos you are continuously sharing to the world, your tutorial is so clear and very alive and quickly to understand. I love watching movies but your tutorial bit them all for its very interesting than Hollywood movies. Thank you so much sir:)
You are so welcome!
I have three buildings im responsible for and it is important for the databasse to differentiate which building they accessed (visitor log). Is it better to make three visitor logs (tables), one for each building or one large tables with three different front ends? In terms of speed and efficiency....
How can I set specific record locking if a certain condition has been met? For example, a case where one may register as a group or as an individual to set the record field for group name locked only of one has selected to be registered as an individual.
I have multiple users at three different buildings. It is important that each building log visitors and include location. I have set up one front end and back end for now. I will eventually make three front ends. But is it is better to have three exact tables (one per building) or one large table for all three buildings. I am thinking in terms of speed being, locked out etc... Is the speed affected if all one table and ends up being alooot of rows.
I am expanding into access from excel and I love your videos. Every time i close the database it locks me out. another locked file is created and the only way I can get back in to edit is to restart the computer. How do i stop it from locking me out. I am the only user on it.
Thank you for this lecture Sir.
For a database of a small institution, is there any need for a web interface? If so, how does one link Access to vs code?
599cd.com/AccessOnline
Thank you for another awesome video!!!
You bet!
I have a situation with a split database where users enter new records and one of the columns is auto generated. For example, two users might be trying to enter new records in the same table and both of them are assigned ID Number 123456 for their respective record.
What would be the best configuration of record locking, if any, for that situation?
Are you using Autonumbers? If so, that shouldn't happen if you have your record locking set properly.
@@599CD Yes, auto numbers. How should I set record locking?
@@599CD I have a similar situation, when two users input their records at the same time, only one of them is kept. Both are entering information for different clients.
You saved my life Sir, Thank you very much.
You're welcome
@@599CD Hello Sir,
I am trying to generate the QR Code but I don't know how to display it.
I did convert the it to Hex and to base64, but still i couldnt display it.
Only problem with this video is it doesn't address the issue of write conflicts caused by bit fields. I've set up a database where I was the only the user of that database and would get write conflicts on a table I copied that contained bit fields. The write conflict also affects table level editing. Resolved this by going on the server and in design setting all bit fields to default of 0.
Can you do a video on access and one drive sync issues? I have a split database that is constantly running in to problems due to the file trying to sync to one drive. My entire remote computer is on one drive so I don’t know how to get around this?
Yeah, I have a video coming up on this soon, but the bottom line is DON'T USE OneDrive, Google Drive, DropBox or any of those file sharing services with Access. It will corrupt your database! See 599cd.com/AccessOnline
If you have continuous form. Should I use can still use "open database by using record-level looking"?
I mean what is the best sitting for large database once you have continuous form and you want to keep your database with high performance efficiency.?
Switch to SQL Server. LOL
@@599CD Yes but it is hard to install it at my work station because I have limited permission
Is there Free SQL Server?
I am currently only able to open one front end. Can I make it to where I can open several front ends at once?
Sure. You should be able to open several database files at once.
I have a different locking issue. When one user opens up the shared database it creates a temporary 0kb file with the same database name and a lock icon on it and no other user is able to even open the database file. Others users just get an error that says file is locked and it stays that way until the user that has it open closes it. I am not sure if this is some sort of group policy effecting this.
You may have this: 599cd.com/TFIX
Wow. Great video. Is there a button which i can allow editing?
You could make one, sure.
I am having a write conflict issue same as here but my backend is connected to a sql server, i am the only user, i close everything and reopen i get them same issue.
How do i resolve this plz ?
Can't tell from here.
@@599CD i added a timestamp column in my table seems to work so far, thx a lot for the reply
Thanks! Very helpful/intelligence
Welcome
What about different FE. If I put record locking in FE1. But FE2 , FE3 and FE4 are working. Their forms hv no record locking...can they have the issue if FE1 is not on?
Record locking has to be ON for ALL of your front-end files or else it won't work reliably.
How does this video not have more likes
I know, right?
@@599CD Should put cats I the videos... everyone loves funny cats
pls i need help, i made hr/account application using access. I split it then I save my back end in google drive and i distributed my front end in different computers. When i open it on my side (while the other are also using it) and make some update like editing some information or attaching pdf/jpg file , it showing fine and i can see the updates, but when i log out early than they other users that doesn't edit anything, it seems the data will stay the same without my update. the problem is fetching data from the other user is delayed..so if the last user doesn't do anything, it will fetch the old data from that user's computer to my back end which is in google drive. its hard to explain but i hope someone can understand. thanks
Do NOT use Google Drive to run your Access database. 599cd.com/GoogleDrive
If I set this sitting and save it as accde
And disrputed to other users, Dose the sitting still apply to them or I have to make the sitting for each user?
Should work. Try it and see.
"open database by using record-level looking". If I want to uncheck it should i uncheck it from front end or back end?
Both
Works perfect!
sweet
Hi, first of all i wanted to mention that your own version of locking is much more user friendly. I want to ask you about some extras on your version. Is it possible to place timer, in order to prevent user having the x record in edit mode for a long time? Suppose i edit a record and i go out for a lunch or break , and leave it in "edit mode". Then other users cannot edit it.
I have also seen in my job that that several users can edit the same record at once, no error message is appearing, but there is an audit trail table that keeps all the changes. I believe the same can be done here, based on both your audit trail video and this one, is my thought right? I will try myself to implement myself the above thoughts in Access
Once again i like the material you provide. Keep going!!
Sure. I don't see why you couldn't implement both of these things. I have a "clear record locks" button in my database in case for some reason there's an error (system locks up, etc.). No reason why you couldn't put that on a timer.
Top. Thank u.
Welcome 👍
Thanks!
Welcome!
Plz can you make videos for OLE/DDE timeout
Refresh interval
Number of updates retries
ODBC Refresh interval
Update retry interval
And so on
I talk about that a little bit in 599cd.com/ACX18 but it's not something most people have to change.
Is 70 users considered large?
They aren't all using the database at the same time. The most I've seen is 8-10.
It's concurrent users that you want to worry about. 8 to 10 is fine for Access provided your network is fast enough.
so if i have 50 forms i have to set it in all?
Yup.
Sir I am facing following error on changing the record it is important to tell you that my backed database is MySql. do you have any guide video on this issue ?
The Data has been changed
Another user edited this record and saved the changes before you attempted to save your changes.
Re-edit the record.
Nope. In fact I've never used MySQL. I'm working on an Access-to-SQL-Server video right now. But yes, if someone else has edited that record, you'll get that problem.
how to turn off record locker
What's record locker?
This is not very useful when multiple users are trying to edit the same table regardless of rows since it locks everyone out of that table. It's like having an excel sheet that is not shared. I do not like this solution. Sorry.
That's not how your database SHOULD behave if it's set up properly. Row-level record locking will only lock that RECORD, not the whole table.
@@599CD That's what I thought too but for some reason, it kept locking the entire table. I ended up using code as a workaround with recordsets. At least now it does not lock any table or any row and still prevents write conflicts. Just need a lot of coding tho and I hate writing code in MS Access. I got spoiled by visual studio C# lol