Access 2000 Limited Record

Hi,

I have an application (currently 1300kb file size), built from Access2000.

Whenever I add New record, the last (added) ones will be 'gone' (missing from
table).

Anyone had similar experience ?

Regards & God Bless, Edison

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200906/1

If the new record is not being added when you enter it in a form and then
close the form, it might be this bug:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

If the tables are attached from another db, you may not be attached to the
place you believe you are.

Try a compact/repair at least, or perhaps this recovery sequence:
http://allenbrowne.com/recover.html

If you are still stuck tell us if you are actually using Access 2000 (or
just an A2000 format mdb), whether the tables are attached, and whether the
problem occurs even if you enter directly into the table (not a form or
query.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"edisonl via AccessMonster.com" u47544@uwe wrote in message
news:9707e48d2c5ff@uwe...
Hi,

I have an application (currently 1300kb file size), built from Access2000.

Whenever I add New record, the last (added) ones will be 'gone'
(missing from table).

Anyone had similar experience ?

Regards & God Bless, Edison

Hi Allen,

Thanks for replying. I notice that this special behaviour only occur to
particular pc.

Even though I tried to do a compact & repaired, Prompt on Close, Save, Delete.
. still persistence of similar symtoms.

Regards & God Bless, Edison



Allen Browne wrote:
If the new record is not being added when you enter it in a form and then
close the form, it might be this bug:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

If the tables are attached from another db, you may not be attached to the
place you believe you are.

Try a compact/repair at least, or perhaps this recovery sequence:
http://allenbrowne.com/recover.html

If you are still stuck tell us if you are actually using Access 2000 (or
just an A2000 format mdb), whether the tables are attached, and whether the
problem occurs even if you enter directly into the table (not a form or
query.)

Hi,

[quoted text clipped - 6 lines]

Regards & God Bless, Edison

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200906/1

If you want us to try to help, please answer the questions from the last
post, w.r.t. the problem computer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"edisonl via AccessMonster.com" u47544@uwe wrote in message
news:971304200838c@uwe...
Thanks for replying. I notice that this special behaviour only occur to
particular pc.

Even though I tried to do a compact & repaired, Prompt on Close,
Save, Delete. still persistence of similar symtoms.

Allen Browne wrote:
If the new record is not being added when you enter it in a form and
then close the form, it might be this bug:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

If the tables are attached from another db, you may not be attached to
the place you believe you are.

Try a compact/repair at least, or perhaps this recovery sequence:
http://allenbrowne.com/recover.html

If you are still stuck tell us if you are actually using Access 2000 (or
just an A2000 format mdb), whether the tables are attached, and whether
the problem occurs even if you enter directly into the table (not a form
or
query.)

Hi Allen,

Thanks for reminding [:-)],
QUOTE:
If you are still stuck tell us if you are actually using Access 2000 (or
just an A2000 format mdb), whether the tables are attached, and whether the
problem occurs even if you enter directly into the table (not a form or
query.)

Yes, I am using currently Access 2000. not sure if I understand tables are
attached ?
If you mean are the records link from mutltiple tables? no it is purely from
single individual tables.

Regards & God Bless, Edison


Allen Browne wrote:
If you want us to try to help, please answer the questions from the last
post, w.r.t. the problem computer.

Thanks for replying. I notice that this special behaviour only occur to
particular pc.
[quoted text clipped - 19 lines]
or
query.)

--
Message posted via http://www.accessmonster.com

Okay: you have Access 2000. On the problem computer, open Access and go to
Help | About. What service pack (SP) is installed, e.g.:
Office 2000 SP3

A linked table has a little shortcut icon on it when you view it on the
Tables tab of the Database window. You link a table via File | Get External,
or by using the Database Splitter wizard. If you don't know about linked
tables, then this is probably not the issue.

When you enter a new record, you say it disappears. How are you entering the
record? Directly into the table? Or via a form?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"edisonl via AccessMonster.com" u47544@uwe wrote in message
news:97146fb9f7ca8@uwe...
Hi Allen,

Thanks for reminding [:-)],
QUOTE:
If you are still stuck tell us if you are actually using Access 2000 (or
just an A2000 format mdb), whether the tables are attached, and whether
the
problem occurs even if you enter directly into the table (not a form or
query.)

Yes, I am using currently Access 2000. not sure if I understand tables are
attached ?
If you mean are the records link from mutltiple tables? no it is purely
from
single individual tables.

Regards & God Bless, Edison


Allen Browne wrote:
If you want us to try to help, please answer the questions from the last
post, w.r.t. the problem computer.

Thanks for replying. I notice that this special behaviour only occur to
particular pc.
[quoted text clipped - 19 lines]
or
query.)

--
Message posted via http://www.accessmonster.com

Hi Allen,

Right Thanks so much for quick response..
Q1. Version Access 2000 9.0.2720
Q2. No linked tables (I guess is when you view database view where you can
see all tables right?)
No Splitter, or Linked table of that sort is being used, its a pretty simple
application, even interface
is pretty plain.

Q3. Data input via form..

Regards & God Bless, Edison

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _

Allen Browne wrote:
Okay: you have Access 2000. On the problem computer, open Access and go to
Help | About. What service pack (SP) is installed, e.g.:
Office 2000 SP3

A linked table has a little shortcut icon on it when you view it on the
Tables tab of the Database window. You link a table via File | Get External,
or by using the Database Splitter wizard. If you don't know about linked
tables, then this is probably not the issue.

When you enter a new record, you say it disappears. How are you entering the
record? Directly into the table? Or via a form?

Hi Allen,

[quoted text clipped - 22 lines]
or
query.)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200906/1

RUN (don't walk) to:
http://support.microsoft.com/sp
and download Service Pack 3 for Office 2000 (under Office Proucts) *and*
Microsoft Jet 4.0 Database (under Developer Tools.)

You desparately need this SP. SP1 for Office 2000 fixed more than 200 bugs
in Access alone, and there's more fixes in SP2 and SP3. Similarly anything
less the SP8 for JET is just tempting fate to destroy your database. If your
database means anything to you, I can't stress these 2 updates enough.

We'll talk more about the form if the problem still occurs after installing
these updates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"edisonl via AccessMonster.com" u47544@uwe wrote in message
news:9716d0e6f401f@uwe...
Hi Allen,

Right Thanks so much for quick response..
Q1. Version Access 2000 9.0.2720
Q2. No linked tables (I guess is when you view database view where you can
see all tables right?)
No Splitter, or Linked table of that sort is being used, its a pretty
simple
application, even interface
is pretty plain.

Q3. Data input via form..

Regards & God Bless, Edison

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _
_ _ _ _ _ _ _ _ _ _

Allen Browne wrote:
Okay: you have Access 2000. On the problem computer, open Access and go to
Help | About. What service pack (SP) is installed, e.g.:
Office 2000 SP3

A linked table has a little shortcut icon on it when you view it on the
Tables tab of the Database window. You link a table via File | Get
External,
or by using the Database Splitter wizard. If you don't know about linked
tables, then this is probably not the issue.

When you enter a new record, you say it disappears. How are you entering
the
record? Directly into the table? Or via a form?

Hi Allen,

[quoted text clipped - 22 lines]
or
query.)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200906/1