Database/Queries Running Very Slow???

[Mohsin Malik]

Hi friends! I am making an Ms-Access database for Real Estate Management?
I have succeeded in doing all that which is enlisted below, the problem is that the database is running very slow? I don’t know what can I do now? The queries is running very slow that makes me to wait too much, I want to make the database run very fast?

The attached database contain the following tables and queries:

TABLES

• tblBuilding (having building name and group)
• tblUnit (multiple units of a building, hence it is a sub table of tblBuilding)
• tblTenant (for the tenants of my buildings and units)
• tblLease (the agreement table where I’ll decide what, when and how rent increases and agreement ended)
• tblBank (for accounting system)
• tblDebit (for accounting system)
• tblCredit (for accounting system)
• tblCount (used for calculation of rent amount due)

QUERIES

• QryLease (Basically a setting in tblLease)
• Query-Success (will be used for Appending/Insertion of Record in tblLease)
• Append-Success (will be used for renewing lease agreement when going to expire)
• qryEventCartesian (Query used for calculating rent receivable)
• qryEventDates (Query which is final and showing the current rent due and all history of rent receivable)
• Ledger (will be used for Accounting system)
• Ledger-Success (A Union Query which will be used for accounting system for debit, credit and balance)
• L-calc (A query which will be shown on database startup that will show me the current rent amount due with balance of each building unit and tenant – where I want to use Total Query option)

The basic features of this database are:
• To calculate the rent automatically
• To show the rent due for the current month
• Automatically increase the rent after specific period of time
• Automatically renew the contract when it is going to expire
• Maintain an Accounting system which show the rent receivable – rent received and balance

Please review the database for better understandings and help me in this matter of running very slow. Thank you

 

[Alansidman]

I suspect that your database is corrupted. Each time I open it and try to view the form in design view it crashes. Try running a compact and repair. If that does not solve the issue, then create a new database and import all of the objects into the new database.

Alan

 

[Mohsin Malik]

I've remove the form which is crashing the database, now you can recheck the attached database, Run the query name as "L-cal" which is the main concern that make database to run very slowly.