Loosing data when entering data to backend.

[SpookiePower]

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 ?

 

[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.

 

[SpookiePower]

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 ??

 

[Sylvain Lafontaine]

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.

 

[SpookiePower]

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.

 

[SpookiePower]

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.

 

[Sylvain Lafontaine]

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.

 

[SpookiePower]

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 ?

 

[Sylvain Lafontaine]

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]

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

 

[SpookiePower]

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.

 

[Sylvain Lafontaine]

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?

 

[SpookiePower]

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.

 

[SpookiePower]

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.

 

[Sylvain Lafontaine]

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]

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

 

[SpookiePower]

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.

 

[SpookiePower]

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.

 

[Sylvain Lafontaine]

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?

 

[SpookiePower]

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 ?