How do I close a database

  • Thread starter Thread starter Reehka
  • Start date Start date
R

Reehka

I want to compact my backend from my frontend - but that
requires me to close the backend.

What is the procedure for doing that?

How do I disconnect linked tables in the frontend?

How do I establish a connection to the backend afterwards?

I can e.g. re-link all my tables.
 
Reehka said:
I want to compact my backend from my frontend - but that
requires me to close the backend.

What is the procedure for doing that?

How do I disconnect linked tables in the frontend?

How do I establish a connection to the backend afterwards?

I can e.g. re-link all my tables.
Click to expand...

You don't need to delete the links, you just have to not be using any of
them. If all bound forms and reports are closed and you are not accessing
any data in code, then all connections to the back end are also closed.

One strategy is to test for the existence of the LDB file for the back end.
If it's there then you (or someone else) is still connected. If it's not
there then you are free to run a compact on the file.
 
Back
Top