Re: Database last used?

From: Stringfellow Hawke (Stringfellow.Hawke-PleaseNoSpam_at_gmail.com.nospam)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 16:41:51 -0000

How about enabling AUTO_CLOSE with ALTER DATABASE. This will release all
resources held by the DB. If anybody tries to access the DB it will open it
causing them no disruption. SQL Errorlog will contain messages whenever the
DB is opened.

"Anceladux" <Anceladux@discussions.microsoft.com> wrote in message
news:F56F4735-DF9D-41A8-84CB-C48E600897BB@microsoft.com...
> Is there a way to check how long since a database has been last used?
>
> I have a database which I believe is redundant but I want to be sure
> before
> dropping it.
> Thanks
>
>

Relevant Pages

  • Re: Search efficiency - RDMS search versus free text search
    ... so for example a list of all resources relating to ... One way of doing this is with a SQL query against the database ... we are using the Google Search Appliance ... early 1980's that did fuzzy searching. ...
    (comp.databases.theory)
  • Re: Search efficiency - RDMS search versus free text search
    ... so for example a list of all resources relating to ... One way of doing this is with a SQL query against the database ... the engine itself will do full text indexing for ...
    (comp.databases.theory)
  • Re: Contact Info/ Phone Log for Families K -12
    ... If the OP wishes to get a database up and running as soon as ... Here's some links to free resources that may give you a start. ... Allen's tutorials should give you an overview of how to proceed. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.gettingstarted)
  • Re: My database is all messed up
    ... database off the help files alone. ... I fully agree with Jeff; you really need to step back, learn how Access works, ... Check out some of the resources at: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to auto fill information from a main form to 2 related for
    ... the link i posted has, in turn, a link to the Access Junkie's Resources ... >> sounds like your friend is going to depend on this database to deliver ... >>> advance for not knowing the correct terms. ... >>> forms within Access for a friend's business. ...
    (microsoft.public.access.gettingstarted)