Results 1 to 10 of 10
  1. 07-25-2009, 06:58 AM #1
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15

    Access Database Duplication problem

    Hi! There,
    Can any one help me with the below problem.


    I am using access 2002 . I have created a database in access , whenever i open this database.A temp file gets created in the same folder in which the database is stored.This temp file after closing the database converts into a duplicate database named db1,db2,.... please can any one provide an expert assistance to get rid of the additional duplicate files
    please help!!!!!!

    Thank you
    Reply With Quote Reply With Quote
  2. 07-25-2009, 07:16 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like your db is crashing. Open the db while holding down a <SHIFT> key and try and compile it and see if you have any errors.
    Reply With Quote Reply With Quote
  3. 09-06-2009, 01:50 AM #3
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15
    please ignore
    Last edited by Tempuser; 09-06-2009 at 01:55 AM. Reason: quoted to self
    Reply With Quote Reply With Quote
  4. 09-06-2009, 01:56 AM #4
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15
    Quote Originally Posted by RuralGuy View Post
    It sounds like your db is crashing. Open the db while holding down a <SHIFT> key and try and compile it and see if you have any errors.
    no access hasnt crashed it is perfectly fine
    there is someother problem
    i am using my database on a network if i move to some other drive the duplication is not there however in that particular drive when i open the database a temp file is created with a locked logo after closing the database the file creates into a new dbase file named db1,db2,.... everytime i open the dbase , if access would have crashed then it would be for all drives and not a single one
    ne ways many thanks for your help...
    Brgd's..
    Reply With Quote Reply With Quote
  5. 09-06-2009, 09:51 AM #5
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you have "Compact on Close" turned on and inadequate permissions on that network machine.
    Reply With Quote Reply With Quote
  6. 09-07-2009, 11:12 AM #6
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15
    Quote Originally Posted by RuralGuy View Post
    It sounds like you have "Compact on Close" turned on and inadequate permissions on that network machine.
    Thanx Dear!

    what does "Compact on Close" means is it the option available in tools -->database utilities--> compact and repair database option. if yes how do i use it

    many thanks for ur assistance
    rgds
    Reply With Quote Reply With Quote
  7. 09-07-2009, 02:25 PM #7
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Look at Tools>Options...>General tab - checkbox on the bottom left. Uncheck it for now if it is checked (which I think it is).
    Reply With Quote Reply With Quote
  8. 09-08-2009, 07:18 AM #8
    thhui
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    It is recommended you turn off compact on close when your access file is located in network drive.
    Reply With Quote Reply With Quote
  9. 09-10-2009, 05:52 AM #9
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15
    thank you for your help dear

    i will do a check and will inform you.

    Brgds



    Quote Originally Posted by RuralGuy View Post
    Look at Tools>Options...>General tab - checkbox on the bottom left. Uncheck it for now if it is checked (which I think it is).
    Reply With Quote Reply With Quote
  10. 09-10-2009, 05:53 AM #10
    Tempuser
    Tempuser is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2009
    Posts
    15
    Many thanks for your support dear

    will check if it works

    Quote Originally Posted by thhui View Post
    It is recommended you turn off compact on close when your access file is located in network drive.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Access security problem
    By ShadowFox in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:23 PM
  2. database problem
    By lukifer in forum Access
    Replies: 3
    Last Post: 07-17-2009, 07:39 AM
  3. database problem
    By st3ven_J in forum Access
    Replies: 0
    Last Post: 02-12-2009, 07:27 AM
  4. Database Design Problem
    By Kurth in forum Access
    Replies: 0
    Last Post: 08-14-2008, 04:09 AM
  5. problem with my database
    By skylinekiller in forum Access
    Replies: 1
    Last Post: 01-25-2008, 02:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums