Losing data in a table.

[Vivian Kelly]

I have a question regarding data that is entered on a table that would
contain budget amounts. When I check the data a few days later there
might be some of the data but other data is missing but there is no
consistency. There is a form that updates this table (called bills)
but I would have thought that I did not have open this form and enter
the information in the table directly. Am i wrong and have to use the
form when updating the budget data. I have tried loooking up this
but all solutions refer to network access and concurrent use but there
is only one individual using this database also if this was to be used
for multiple access the setting are set to the appropriate setting.

Thanks,

Viv

 

[Joseph Meehan]

I have a question regarding data that is entered on a table that would
contain budget amounts. When I check the data a few days later there
might be some of the data but other data is missing but there is no
consistency. There is a form that updates this table (called bills)
but I would have thought that I did not have open this form and enter
the information in the table directly. Am i wrong and have to use the
form when updating the budget data. I have tried loooking up this
but all solutions refer to network access and concurrent use but there
is only one individual using this database also if this was to be used
for multiple access the setting are set to the appropriate setting.

Thanks,

Viv

Normally you would be right, however since we have no way of knowing all
the design features of your database and what features the form may have,
there could be some issues.

I should note that tables are not really there to view or enter data
into. While it should normally work, using queries and forms usually is
less troublesome.

It is also possible you are experiencing some sort of corruption of the
database. It might be a good idea to do a compact and repair.

I can't tell from your message, but if this is a shared database where
more than one person may be using it at the same time, you could be having a
record locking issue and you really need to split the database so there is
one back end and a front end for each user. There are also possible issues
with some networks.

As you can see there are a lot of possible issues.