Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Loosing data when entering data to backend.

Discussion in 'Information Technology' started by SpookiePower, Jul 28, 2006.

  1. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    I have made a database for my work. This database I have
    spilt in a front and backend. The backend are placed on a
    server and the frontend are placed on two different computers.
    My problem is that some times, and only some times, when
    you enter data into the frontend, the data never gets to the
    backend. Yesterday one of my users was entering data into
    the frontend for four hours, but nothing was never saved into
    the backend, it was all lost. My user could see the data in
    his frontend when he turned off the computer. But later that
    day, when he turned it on again, the data was gone. But the
    wierd thing is that is only happens sometime.

    All I have done is to split the database into a front/back-end, and
    then link them together to the backend again from different computers.
    But my users, are mostly using my database at the same time. But
    have I missed something when I created this database ?

    Can some one guide me with this problem ?
     
  2. Loading...

    Similar Threads Forum Date
    General Loosing our way? Perhaps?? Hard Talk Sep 28, 2009
    Loosing battle of Punjabi Speaking - need help Sikh Youth Aug 7, 2007
    General Are we loosing our identity? Hard Talk Apr 6, 2007
    Datawind's Sunseet Singh Introduces Ubislate: Aimed at the Cost-Conscious World Sikh Personalities Jan 12, 2014
    SciTech No Secrets! Metadata reveals the secrets of social position, company hierarchy, terrorist cells Breaking News Jun 17, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Not sure if it's what you are looking but one of the best jobs I ever had (3
    days pay for 2 hours work) was just this type of problem. The client was
    entering data on to a selfmade d base and "sometimes" it disapeared. The
    contact I had was for 3 days so I could have spent weeks sorting it out but
    the only problem was that they were using casscading combos for many forms
    and non of them had a requery afterupdate. As I said not sure if this could
    be applicable but when this problem is reported it's the 1st thing I check.


    --
    Wayne
    Manchester, England.



    "SpookiePower" wrote:

    > I have made a database for my work. This database I have
    > spilt in a front and backend. The backend are placed on a
    > server and the frontend are placed on two different computers.
    > My problem is that some times, and only some times, when
    > you enter data into the frontend, the data never gets to the
    > backend. Yesterday one of my users was entering data into
    > the frontend for four hours, but nothing was never saved into
    > the backend, it was all lost. My user could see the data in
    > his frontend when he turned off the computer. But later that
    > day, when he turned it on again, the data was gone. But the
    > wierd thing is that is only happens sometime.
    >
    > All I have done is to split the database into a front/back-end, and
    > then link them together to the backend again from different computers.
    > But my users, are mostly using my database at the same time. But
    > have I missed something when I created this database ?
    >
    > Can some one guide me with this problem ?
    >
    >
     
  4. SpookiePower

    SpookiePower
    Expand Collapse
    Guest


    > Not sure if it's what you are looking but one of the best jobs I ever had (3
    > days pay for 2 hours work) was just this type of problem. The client was
    > entering data on to a selfmade d base and "sometimes" it disapeared. The
    > contact I had was for 3 days so I could have spent weeks sorting it out but
    > the only problem was that they were using casscading combos for many forms
    > and non of them had a requery afterupdate. As I said not sure if this could
    > be applicable but when this problem is reported it's the 1st thing I check.


    I have made both the front and back-end myself, but I don't know what
    a casscading combobox and a requery afterupdate is. Where can I see
    this on my forms ??
     
  5. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Some possibilities here:

    When he did close his computer, did he make sure to close Access before?
    (However, I don't think that a corruption problem could erase four hours of
    work without touching anything else.)

    Maybe some process has restored the previous version of the database from a
    backup.

    Maybe he was connected to another backend (could happen if you are using a
    drive letter instead of UNC convention and that he logged under a different
    account) or that he used the wrong version of the frontend.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1152363442.434465.17710@p79g2000cwp.googlegroups.com...
    >I have made a database for my work. This database I have
    > spilt in a front and backend. The backend are placed on a
    > server and the frontend are placed on two different computers.
    > My problem is that some times, and only some times, when
    > you enter data into the frontend, the data never gets to the
    > backend. Yesterday one of my users was entering data into
    > the frontend for four hours, but nothing was never saved into
    > the backend, it was all lost. My user could see the data in
    > his frontend when he turned off the computer. But later that
    > day, when he turned it on again, the data was gone. But the
    > wierd thing is that is only happens sometime.
    >
    > All I have done is to split the database into a front/back-end, and
    > then link them together to the backend again from different computers.
    > But my users, are mostly using my database at the same time. But
    > have I missed something when I created this database ?
    >
    > Can some one guide me with this problem ?
    >
     
  6. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    Sylvain Lafontaine fill the blanks, no spam please skrev:

    > Some possibilities here:
    >
    > When he did close his computer, did he make sure to close Access before?
    > (However, I don't think that a corruption problem could erase four hours of
    > work without touching anything else.)


    Yes he did closed Access before turning off the computer.

    > Maybe some process has restored the previous version of the database from a
    > backup.


    That should not happen in the daytimes, only at night.

    > Maybe he was connected to another backend (could happen if you are using a
    > drive letter instead of UNC convention and that he logged under a different
    > account) or that he used the wrong version of the frontend.


    There is only one version of the front end and only one version
    of the backend. But I use the drive letter to connect to the backend.
    Our server have a drive letter for it self.
     
  7. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    I just found out about the cascading comboboxes.
    Yes I use them on one of my forms, but this form
    have not been in use at any time, when data was lost.

    But I have nothing in my Afterupdate. Don't know if this
    could be the problem and if it is the problem, I'm not sure
    what to write in the afterupdate event.
     
  8. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Are you using any transaction in your VBA code? Any opened transaction that
    you would have forgotten to close could have suck away all the following
    data.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1152373669.653053.132280@35g2000cwc.googlegroups.com...
    >
    > Sylvain Lafontaine fill the blanks, no spam please skrev:
    >
    >> Some possibilities here:
    >>
    >> When he did close his computer, did he make sure to close Access before?
    >> (However, I don't think that a corruption problem could erase four hours
    >> of
    >> work without touching anything else.)

    >
    > Yes he did closed Access before turning off the computer.
    >
    >> Maybe some process has restored the previous version of the database from
    >> a
    >> backup.

    >
    > That should not happen in the daytimes, only at night.
    >
    >> Maybe he was connected to another backend (could happen if you are using
    >> a
    >> drive letter instead of UNC convention and that he logged under a
    >> different
    >> account) or that he used the wrong version of the frontend.

    >
    > There is only one version of the front end and only one version
    > of the backend. But I use the drive letter to connect to the backend.
    > Our server have a drive letter for it self.
    >
     
  9. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    Sylvain Lafontaine (fill the blanks, no spam please) skrev:

    > Are you using any transaction in your VBA code? Any opened transaction that
    > you would have forgotten to close could have suck away all the following
    > data.


    No, I dont use any transaction and have never done. I don't know
    how to use them.

    I have tryed to put the backend on the same computer as the frontends,
    and it seems to work well. But the problems start again if the backend
    is on the server. Could it be something with the connection between
    the frontend-computers and the server ??

    Do I have to tell the backend that it can be accessed by more
    than one frontend at the same time, or is it possible as a default ?
     
  10. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    You have said that the problem was happening from time to time but now, you
    seem to be affected by it as soon as you are putting the backend on a remote
    machine?

    What's the real situation here: does the backup works sometime when it's
    placed on the server or if it never work?

    When your fellow was entering data, could you see these data from your
    machine? After a refresh or a requery?

    What are the version that you are using, what kind of connection are you
    using and what kind of server this is?

    You should have any problem after the database has been splitting; however,
    if you have some problems then you should be specific on whether these
    problems occur all the times or only infrequently and what it's the exact
    configuration that you are using.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1152381741.225491.151720@s13g2000cwa.googlegroups.com...
    >
    > Sylvain Lafontaine (fill the blanks, no spam please) skrev:
    >
    >> Are you using any transaction in your VBA code? Any opened transaction
    >> that
    >> you would have forgotten to close could have suck away all the following
    >> data.

    >
    > No, I dont use any transaction and have never done. I don't know
    > how to use them.
    >
    > I have tryed to put the backend on the same computer as the frontends,
    > and it seems to work well. But the problems start again if the backend
    > is on the server. Could it be something with the connection between
    > the frontend-computers and the server ??
    >
    > Do I have to tell the backend that it can be accessed by more
    > than one frontend at the same time, or is it possible as a default ?
    >
     
  11. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Also, make sure that your friend don't use any filter that would hide any
    past data.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1152381741.225491.151720@s13g2000cwa.googlegroups.com...
    >
    > Sylvain Lafontaine (fill the blanks, no spam please) skrev:
    >
    >> Are you using any transaction in your VBA code? Any opened transaction
    >> that
    >> you would have forgotten to close could have suck away all the following
    >> data.

    >
    > No, I dont use any transaction and have never done. I don't know
    > how to use them.
    >
    > I have tryed to put the backend on the same computer as the frontends,
    > and it seems to work well. But the problems start again if the backend
    > is on the server. Could it be something with the connection between
    > the frontend-computers and the server ??
    >
    > Do I have to tell the backend that it can be accessed by more
    > than one frontend at the same time, or is it possible as a default ?
    >
     
  12. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    Sylvain Lafontaine (fill the blanks, no spam please) skrev:

    > You have said that the problem was happening from time to time but now, you
    > seem to be affected by it as soon as you are putting the backend on a remote
    > machine?


    I have never had this problem, but I run the frontend and backend on
    my own computer, on which I also have made the database. The problem
    only seems to happen when then front- and backend are placed on
    to different machines.

    > When your fellow was entering data, could you see these data from your
    > machine? After a refresh or a requery?


    I was watching my frontend and the backend when he was entering data
    into his frontend. When it works, it showed up on my frontend after 5
    minuttes,
    so I guess that there must be some kind of delay between the front- and
    backend.
    When it works, it only shows up when I close and opens the frontend.

    > What are the version that you are using, what kind of connection are you
    > using and what kind of server this is?


    I'm using Access 2000. I don't know about the connection, and I don't
    know
    about the server, but all the computers runs on windows XP.
     
  13. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    The five minute of delay is the ODBC refresh interval (sec) that you will
    find under the Advanced tab in the Options menu. Of course, if you make an
    explicit refresh or requery, you should see the new values immediately.

    Did you change the structure of any of the tables in the backend without
    making a refreshing of the linked tables using the Linked Table Manager on
    your friend's computer?

    Are you using autoincrement numbers for the primary keys of your tables?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1152389419.481490.324170@m73g2000cwd.googlegroups.com...
    >
    > Sylvain Lafontaine (fill the blanks, no spam please) skrev:
    >
    >> You have said that the problem was happening from time to time but now,
    >> you
    >> seem to be affected by it as soon as you are putting the backend on a
    >> remote
    >> machine?

    >
    > I have never had this problem, but I run the frontend and backend on
    > my own computer, on which I also have made the database. The problem
    > only seems to happen when then front- and backend are placed on
    > to different machines.
    >
    >> When your fellow was entering data, could you see these data from your
    >> machine? After a refresh or a requery?

    >
    > I was watching my frontend and the backend when he was entering data
    > into his frontend. When it works, it showed up on my frontend after 5
    > minuttes,
    > so I guess that there must be some kind of delay between the front- and
    > backend.
    > When it works, it only shows up when I close and opens the frontend.
    >
    >> What are the version that you are using, what kind of connection are you
    >> using and what kind of server this is?

    >
    > I'm using Access 2000. I don't know about the connection, and I don't
    > know
    > about the server, but all the computers runs on windows XP.
    >
     
  14. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> skrev i en meddelelse
    news:%23H0bc4roGHA.3808@TK2MSFTNGP03.phx.gbl...
    > Also, make sure that your friend don't use any filter that would hide any past data.


    I dont know anything about a filter, so I can not answer that
    question. But maybe I should go ask our Network-guy that
    question.
     
  15. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> skrev i en meddelelse
    news:eWoReutoGHA.3288@TK2MSFTNGP03.phx.gbl...
    > The five minute of delay is the ODBC refresh interval (sec) that you will find under the Advanced tab in the Options menu. Of
    > course, if you make an explicit refresh or requery, you should see the new values immediately.


    I dont have access to changed anything that options.

    > Did you change the structure of any of the tables in the backend without making a refreshing of the linked tables using the Linked
    > Table Manager on your friend's computer?


    I have never used the refreshing function in the Linked table manager.
    Could that maybe be the problem ? I only use the "Compact and repair
    database" function.


    > Are you using autoincrement numbers for the primary keys of your tables?


    Yes, most of my tables have autoincrement numbers for primary key.
     
  16. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    No, this has nothing to do with the network. A filter is simply a property
    of a form that you can set to filter the recordset returned by the source.

    When you add new records to a filtered form, these new records will always
    show up on the form even if their values should have been filtered out by
    the filter because they are new. However, the next time you make a requery,
    a refresh or that you close/reopened the form, they are no longer considered
    new and will be filtered out.

    Another similar possibility would be that the Data Entry property of the
    form has been set to Yes.

    You should check the property Filter, Allow Filters and Data Entry and that
    your friend did not make use the Filter by Form function of Access to make
    sure that there are not the source of your problem.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:Oj8N3kyoGHA.2360@TK2MSFTNGP05.phx.gbl...
    > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    > skrev i en meddelelse news:%23H0bc4roGHA.3808@TK2MSFTNGP03.phx.gbl...
    >> Also, make sure that your friend don't use any filter that would hide any
    >> past data.

    >
    > I dont know anything about a filter, so I can not answer that
    > question. But maybe I should go ask our Network-guy that
    > question.
    >
     
  17. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    I don't understand why you cannot make use of the Linked tables manager.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:uqyBanyoGHA.3812@TK2MSFTNGP03.phx.gbl...
    > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    > skrev i en meddelelse news:eWoReutoGHA.3288@TK2MSFTNGP03.phx.gbl...
    >> The five minute of delay is the ODBC refresh interval (sec) that you will
    >> find under the Advanced tab in the Options menu. Of course, if you make
    >> an explicit refresh or requery, you should see the new values
    >> immediately.

    >
    > I dont have access to changed anything that options.
    >
    >> Did you change the structure of any of the tables in the backend without
    >> making a refreshing of the linked tables using the Linked Table Manager
    >> on your friend's computer?

    >
    > I have never used the refreshing function in the Linked table manager.
    > Could that maybe be the problem ? I only use the "Compact and repair
    > database" function.
    >
    >
    >> Are you using autoincrement numbers for the primary keys of your tables?

    >
    > Yes, most of my tables have autoincrement numbers for primary key.
    >
     
  18. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> skrev i en meddelelse
    news:umjbZP2oGHA.4848@TK2MSFTNGP03.phx.gbl...

    >I don't understand why you cannot make use of the Linked tables manager.


    I never said that I could not use it, but that I never have tryed it.
    I just found out that there was a function like that when you mention it.
     
  19. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> skrev i en meddelelse
    news:ea5Xzv1oGHA.4996@TK2MSFTNGP05.phx.gbl...
    > No, this has nothing to do with the network. A filter is simply a property of a form that you can set to filter the recordset
    > returned by the source.


    Ok.

    > When you add new records to a filtered form, these new records will always show up on the form even if their values should have
    > been filtered out by the filter because they are new. However, the next time you make a requery, a refresh or that you
    > close/reopened the form, they are no longer considered new and will be filtered out.


    I have never tryed to use filters and know nothing about them, so I find it hard
    to belive that I have set up a filter without knowing about it.

    > Another similar possibility would be that the Data Entry property of the form has been set to Yes.


    In all my forntends they are set to no.

    > You should check the property Filter, Allow Filters and Data Entry and that your friend did not make use the Filter by Form
    > function of Access to make sure that there are not the source of your problem.


    The rest of my filters are set to Yes.
     
  20. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Another possibility would be that your friend is not using the same version
    of Windows and Service Pack as you.

    Did you try to use the /decompile switch on your friend's machine?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:evmJgF4oGHA.4848@TK2MSFTNGP03.phx.gbl...
    > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    > skrev i en meddelelse news:ea5Xzv1oGHA.4996@TK2MSFTNGP05.phx.gbl...
    >> No, this has nothing to do with the network. A filter is simply a
    >> property of a form that you can set to filter the recordset returned by
    >> the source.

    >
    > Ok.
    >
    >> When you add new records to a filtered form, these new records will
    >> always show up on the form even if their values should have been filtered
    >> out by the filter because they are new. However, the next time you make
    >> a requery, a refresh or that you close/reopened the form, they are no
    >> longer considered new and will be filtered out.

    >
    > I have never tryed to use filters and know nothing about them, so I find
    > it hard
    > to belive that I have set up a filter without knowing about it.
    >
    >> Another similar possibility would be that the Data Entry property of the
    >> form has been set to Yes.

    >
    > In all my forntends they are set to no.
    >
    >> You should check the property Filter, Allow Filters and Data Entry and
    >> that your friend did not make use the Filter by Form function of Access
    >> to make sure that there are not the source of your problem.

    >
    > The rest of my filters are set to Yes.
    >
     
  21. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> skrev i en meddelelse
    news:OHELcO4oGHA.4988@TK2MSFTNGP04.phx.gbl...
    > Another possibility would be that your friend is not using the same version of Windows and Service Pack as you.


    When I start up my access file, I get a pop up windows, that says something
    about a newer Service pack version than the one on the machine. I do not
    have access to install this newer version, but I will try to talk to our adminstartors
    to get this on installed.

    > Did you try to use the /decompile switch on your friend's machine?


    Decompile switch ?? In access ?
     

Share This Page