[AccessD] Unrecognized Database Format problem

By default the login name and password for getting into access is ADMIN and []
(ie blank password.  If you use access security, and change the ADMIN password,
then you will be prompted for a username and password everytime you login to the
access mdb.

So by ADMIN it is referring to the login name into access, not the login name on
your PC.  That is why it keeps saying ADMIN.

As to the specific cause of the corruption, it is most commonly caused by
connections/objects not being closed correctly.

So when you use
  dim db as database
  set db = [some connection to the back end on the server]

You need to also add
  set db = nothing
  (I've not needed to use db.close)
When you have finished with the object.  The same applies to any other objects
that connect to the backend.  Eg recordsets.

Hope that helps

Stuart



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Liam Meadows
> Sent: Monday, 20 October, 2003 6:36 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Unrecognized Database Format problem
>
>
> Well it looks like my system has the Monday morning blues.
> The MDB BE Keeps getting corrupted and the culprit seems to be my
> machine.
> When I try and repair the BE it says that it is in use by admin on
> OFFICE2 which is wrong because I am logged in as LIAM on OFFICE2.
> Even if I shut the machine down and all the others then goto
> the server
> and try and repair it syill tells me that ADMIN on OFFICE2 is still
> connected. It won't let me delete the ldb due to share violations and
> the only way to get rid of it is to reboot the server and delete the
> ldb.
>
> Has anyone come across this problem ?
> Has anyone a solution ?
>
> Regards
>
> Liam
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>