Please any body help me. this ms access db taking long time to close what is the reason and how to solve this problem ? i am trying to attach the db but it is of 100 mb and not uploading. i compressed to rar and try to attach but rar file is not accepting by the forum so please solve this issue also thanks.
DB taking too much time to close
- Thread starter Rashid
- Start date
- Local time
- Today, 20:06
- Joined
- Feb 19, 2013
- Messages
- 17,371
to upload, compact/repair then zip the file.
You may also want to decompile/recompile, then compact again - see here how to do this
stackoverflow.com
You may also want to decompile/recompile, then compact again - see here how to do this
How does one decompile and recompile a database application?
I have an Access database application and I would like to know the proper way of decompiling and recompiling it.
stackoverflow.com
- Local time
- Today, 14:06
- Joined
- Feb 28, 2001
- Messages
- 29,905
@Rashid, the problem with closing a database is that you are closing files. Some files take longer to close than others.
Tell us about this database. Is that 100 MB in ONE file? Is that the back-end file? Is it a split database? Is the back-end an Access .MDB/.ACCDB or is it SQL Server or something else that uses ODBC connections? How many network connections do you have? (Like a shared back-end with lots of linked tables, for example.) Tell us about the infrastructure of the DB because that is what governs shutdown.
Tell us about this database. Is that 100 MB in ONE file? Is that the back-end file? Is it a split database? Is the back-end an Access .MDB/.ACCDB or is it SQL Server or something else that uses ODBC connections? How many network connections do you have? (Like a shared back-end with lots of linked tables, for example.) Tell us about the infrastructure of the DB because that is what governs shutdown.
tvanstiphout
Active member
- Local time
- Today, 12:06
- Joined
- Jan 22, 2016
- Messages
- 359
And while you answer TheDocMan's excellent questions, also please use precise language. "too much time" is not precise. How many seconds?
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 03:06
- Joined
- May 7, 2009
- Messages
- 20,176
try to Zip it, then attach it. BTW what version do you have.?
Gasman
Enthusiastic Amateur
- Local time
- Today, 20:06
- Joined
- Sep 21, 2011
- Messages
- 16,444
Not without reason to supply the file in a format the forum accepts?
Check what your database is doing.
If a lot of time is required, there may be a lot of work to be done at that point
- close open objects
- Unload data somewhere
- backups and exports to the outside world
=> open objects should be closed as quickly as possible, not just at the end
=> It's better to only load the data that you really need
You should also determine who the database is communicating with. Unnoticed queries from an Excel workbook or a missing or delayed answer from the internet can quickly trigger a wait.
What does the developer of the database say about the behavior in question?
