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.

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

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

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