Results 1 to 6 of 6
  1. 07-30-2009, 02:02 PM #1
    chiru_ongole
    chiru_ongole is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    3

    MS Access compact problem

    Hi

    We have MS Access database on shared server and accessing this database thru shortcut from desktop. All my users are doing the same.
    I had problem while compacting the database. When ever i compact, it creates db1.mdb and next time db2.mdb ..so on ...

    For my users also same proble. Can any one help me to find out the reason why it is happening. We verified the below also.

    1. We have all necessary read/write/execute/ delete permissions to that folder.


    2. I tried when no other users logged in

    It is working fine in my local. ie the db.mdb renamed with original file name after compact and original file also deleted. The same should happen in the server but not ...
    Reply With Quote Reply With Quote
  2. 07-30-2009, 03:44 PM #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
    The application should be split into FrontEnd and BackEnd and everyone should have their own copy of the FrontEnd.
    Reply With Quote Reply With Quote
  3. 07-31-2009, 07:25 AM #3
    chiru_ongole
    chiru_ongole is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    The application should be split into FrontEnd and BackEnd and everyone should have their own copy of the FrontEnd.

    We had already FE and BE databases. All users access FE and only 1 user access BE. Compact problem occuring in both cases. If multiple users are accessing it wont compact. When the last user closing, it will compact ..and the problem occurs
    Reply With Quote Reply With Quote
  4. 07-31-2009, 08:54 AM #4
    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
    Everyone needs their *own* copy of the FrontEnd on their own PC.
    Reply With Quote Reply With Quote
  5. 07-31-2009, 12:38 PM #5
    chiru_ongole
    chiru_ongole is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    Everyone needs their *own* copy of the FrontEnd on their own PC.
    All my users having FE shortcuts in their pc's. Here I am trying to compact BE where no other usrs are using currently. I created shortcut in my desktop and opened it. When I compact it it created db1.mdb. I tried same files in another server and followed the same process, there it was compacted fin with out this issue. My server team conformed that i am having full access.

    If the process working in one server, then it should work here also. Even it is working when I copied database files in local and created shortcut and tried.
    Reply With Quote Reply With Quote
  6. 08-01-2009, 06:53 AM #6
    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
    A shortcut on a PC desktop is not the same as having the entire FrontEnd on that machine. Why do you keep talking about shortcuts?
    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. Automate Compact and Repair process
    By tracerbullet in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:12 PM
  3. excel to access problem
    By sahi0002 in forum Import/Export Data
    Replies: 0
    Last Post: 03-08-2009, 11:40 PM
  4. MS-Access 2007 - Compact & Repair how?
    By techexpressinc in forum Access
    Replies: 2
    Last Post: 03-05-2009, 02:12 PM
  5. Access Data PAge problem
    By csoft in forum Access
    Replies: 0
    Last Post: 04-24-2008, 03:59 AM

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