Results 1 to 6 of 6
  1. #1
    ChobeyGuddu is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2016
    Posts
    29

    Split Database Backend table delete records automatically

    HI All,



    I have a Split database with a MDE frontend -which is used by 25-30 planners in our org.

    the problem is when they all are into the Front end & trying to enter data (data entry form) - by some reason (i am not able to figure it out what is that) after some time the backend deletes all the records from the table (30K rows)

    I am not sure what is triggering the issue here...
    I have certain rules in the data entry form - which is purely based on If-else statement of the fields nothing else.


    Any help - to prevent deleting backend issues-
    I need to restore previous copy in backend and because of that all the work data entry is done after is lost ...

    Hope someone can help me with a solution to this.
    Thanks
    Guddu.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do *all* of your users have their own copy of the MDE on their own PC's? If not, they need it.

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    this should not happen, unless you are using a delete query anyone can run.

  4. #4
    ChobeyGuddu is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2016
    Posts
    29

    Reply

    Quote Originally Posted by RuralGuy View Post
    Do *all* of your users have their own copy of the MDE on their own PC's? If not, they need it.
    HI
    We have the database in the Virtual PC- Online Server - backend and Front end is on the same location.

    Planners have access to it from one folder Database (MDE) & there is a folder called "BACKEND" in this folder- where we have backend (_be and MDB).

    So everyone is using the same MDE file from this folder.

    Thanks,
    Guddu.

  5. #5
    ChobeyGuddu is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2016
    Posts
    29
    Quote Originally Posted by ranman256 View Post
    this should not happen, unless you are using a delete query anyone can run.

    There is no delete query on the MDB or _be.
    So no one can run delete query.

    Thanks
    Guddu.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'll just supply this link and let you make up your own mind. http://www.accessmvp.com/TWickerath/.../multiuser.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Link split database backend to another?
    By Cratebug in forum Access
    Replies: 5
    Last Post: 02-11-2016, 04:02 PM
  2. Replies: 4
    Last Post: 11-23-2015, 06:21 PM
  3. Multi Users on backend of split database
    By Tammy in forum Database Design
    Replies: 10
    Last Post: 12-16-2014, 01:56 PM
  4. Problems accessing split database backend
    By DG2012 in forum Access
    Replies: 7
    Last Post: 11-20-2014, 06:22 PM
  5. Automatically delete access database
    By gstylianou in forum Access
    Replies: 2
    Last Post: 06-25-2014, 02:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums