Solved xxxx.ACCDBL File On & Off (1 Viewer)

Weekleyba

Registered User.
Local time
Yesterday, 23:45
Joined
Oct 10, 2013
Messages
586
I have a split database, with the FEs on each users computer and the BE on a networked server.
I've noticed that sometimes the .accdbl file for the BE will appear and disappear over and over, with a frequency of every 3 seconds or so.
I would expect for it to appear when some has opened their FE and then disappear when all the FEs are closed.
But why would it be coming on and off and on and off.....etc.
 

isladogs

MVP / VIP
Local time
Today, 04:45
Joined
Jan 14, 2017
Messages
18,186
Sounds like your FE doesn't have a persistent connection to the BE.
If there are no objects currently using BE tables from FE queries, forms, reports etc, the connection will be dropped and recreated as needed.

To improve performance create a persistent connection with an always open but hidden form which has as its record source a small BE table.
Ideally use a single field, single record BE table for this purpose.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:45
Joined
May 7, 2009
Messages
19,169
note that "persistent" connection is not about maintaining an Open Linked table/tables,
it is about Opening the Whole External database.
 
Last edited:

Weekleyba

Registered User.
Local time
Yesterday, 23:45
Joined
Oct 10, 2013
Messages
586
note that "persistent" connection is not about maintaining an Open Linked table/tables,
it is about Opening the Whole Eternal database.
Can you elaborate on how to have this 'Opening the Whole Eternal database'?
I tried searching for this but did find anything.
 

isladogs

MVP / VIP
Local time
Today, 04:45
Joined
Jan 14, 2017
Messages
18,186
Doing what I described in post #2 ensures a connection remains open to the BE database.
In my opinion, what @arnelgp wrote is just another way of making the same point.

The FMS link he provided explains the purpose clearly.
 

Weekleyba

Registered User.
Local time
Yesterday, 23:45
Joined
Oct 10, 2013
Messages
586
Isladogs,
I did as you suggested and it worked great! Totally resolved the issue.
Arnelgp,
I'm going to dig into the link you sent because it may improve the performance of the database as a whole.

Thanks to both of you!
 

Users who are viewing this thread

Top Bottom