If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
File already in use error
So I split my database and noticed performance was way slow so I took
suggestions by removing record source from forms and adding to the On Load Event. Well now when a user tries to open a form from their front end they get an error message saying the BE file is already in use. I had the user hit debug and this is where it goes first. Private Sub Form_Load() Me.RecordSource = "tbl_parts" End Sub Have I misinterpreted the readings and suggestions? Thoughts on what I may have done to generate the error? Thank you. |
#2
|
|||
|
|||
File already in use error
Put the record source back in the form's property, not in the form's code. A
lightweight form (a form with no VBA code) loads faster than a form with code behind the form. The more code in the module, the longer it takes to load. The db is way slow because of other db design factors, like leaving subdatasheets on "auto" on all tables instead of changing them to "none", not having indexes on the right columns in tables, bringing over the entire table across the network instead of only one or a few records when opening forms, etc. The user is getting a "file is already in use" message because the first user to open the db didn't have create permissions in the folder where the mdb file is, so no ldb file was created. No one else can share the file while he's in it. Chris Microsoft MVP learningaccess wrote: So I split my database and noticed performance was way slow so I took suggestions by removing record source from forms and adding to the On Load Event. Well now when a user tries to open a form from their front end they get an error message saying the BE file is already in use. I had the user hit debug and this is where it goes first. Private Sub Form_Load() Me.RecordSource = "tbl_parts" End Sub Have I misinterpreted the readings and suggestions? Thoughts on what I may have done to generate the error? Thank you. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200807/1 |
#3
|
|||
|
|||
File already in use error
So are you saying that the form code has nothing to do with the error
message, file already in use? Just curious, why it allowed me to debug and then took me there. The properties of the folder show we all have full control of the folder,subfolders, and files where the BE sits. I am the first one to open the database and then a form...while it's open I check the shared drive and it does show the "ldb" locking file with the BE; however, another user opens the database and attempts to open the same form thus getting that error message. But then I thought I should reverse that...I have another user open the database first (I am not in it at all at this point). I then look at their folder where their FrontEnd sits and see an "ldb" file within the folder on the desktop where the FE is and also an "ldb" locking file where the BE is located at. And then it appears they can't add any new records to the form. Something is going terribly wrong here. Please help. Any other thoughts? Would any of my code cause an issue? I made these changes and the forms/subforms still appeared slow thus why I went to removing the record source and doing it so via a form load. Turn of Name AutoCorrect Subdatasheet - None on all tables in BE Not sure about how to only bring over a select few records from a table. You are right it does bring them all over, but what if a user needed to view one that wasn't brought over? Could you give me some more guidance here? What to do and exactly what happens? Thanks for the help Chris! "Chris O'C via AccessMonster.com" wrote: Put the record source back in the form's property, not in the form's code. A lightweight form (a form with no VBA code) loads faster than a form with code behind the form. The more code in the module, the longer it takes to load. The db is way slow because of other db design factors, like leaving subdatasheets on "auto" on all tables instead of changing them to "none", not having indexes on the right columns in tables, bringing over the entire table across the network instead of only one or a few records when opening forms, etc. The user is getting a "file is already in use" message because the first user to open the db didn't have create permissions in the folder where the mdb file is, so no ldb file was created. No one else can share the file while he's in it. Chris Microsoft MVP learningaccess wrote: So I split my database and noticed performance was way slow so I took suggestions by removing record source from forms and adding to the On Load Event. Well now when a user tries to open a form from their front end they get an error message saying the BE file is already in use. I had the user hit debug and this is where it goes first. Private Sub Form_Load() Me.RecordSource = "tbl_parts" End Sub Have I misinterpreted the readings and suggestions? Thoughts on what I may have done to generate the error? Thank you. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200807/1 |
#4
|
|||
|
|||
File already in use error
Can anyone think of suggestions?
I asked IT to check the folder/subfolders/files where the database sits and they repsonded the group has Full Access; however, when trying to just open the BE from their desk they get the Read Only message (and I don't even have it opened). They will close it and I will try to open it and get no read only message. I moved the BE to another folder (a team folder on the shared drive) and then they can open the BE with no read only issues. Only problem is this folder sits several folders down thus greatly slowing down performance of the database. Don't want to sound like an idiot going back to IT telling them there is something wrong with folder rights when I can't explain it. Any suggestions are welcomed. "Chris O'C via AccessMonster.com" wrote: Put the record source back in the form's property, not in the form's code. A lightweight form (a form with no VBA code) loads faster than a form with code behind the form. The more code in the module, the longer it takes to load. The db is way slow because of other db design factors, like leaving subdatasheets on "auto" on all tables instead of changing them to "none", not having indexes on the right columns in tables, bringing over the entire table across the network instead of only one or a few records when opening forms, etc. The user is getting a "file is already in use" message because the first user to open the db didn't have create permissions in the folder where the mdb file is, so no ldb file was created. No one else can share the file while he's in it. Chris Microsoft MVP learningaccess wrote: So I split my database and noticed performance was way slow so I took suggestions by removing record source from forms and adding to the On Load Event. Well now when a user tries to open a form from their front end they get an error message saying the BE file is already in use. I had the user hit debug and this is where it goes first. Private Sub Form_Load() Me.RecordSource = "tbl_parts" End Sub Have I misinterpreted the readings and suggestions? Thoughts on what I may have done to generate the error? Thank you. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200807/1 |
Thread Tools | |
Display Modes | |
|
|