Access 97 Mystery New Record

[Terry]

Hello,

I would appreciate any advice or help with a number of bugs I have in
Access 97 front end/SQL 2000 database.

Just a little background information to get started. I have just
converted using the MS Upsize wizard an Access 97 database to SQL 2000.
Nearly everything seems to be working, however there are a number of
bugs still to be resolved.

When a Business form is loaded to create a new business record another
sub form Owner is also loaded but is at first blank. Then as soon as
the first (any?) field in this sub form is clicked on and any character
typed the BusinessID is shown at the top of the Owner form. Then if I
close the Business form down and check the database tables I find that
a table linking the Business and Owner tables (e.g. BusinessRel) has a
new record.

(1) My first questions is how does this new record get automatically
created? I have checked the code for both Business and Owner forms and
cannot find any Insert statements. The only other information that my
be relevant is there is a cascading update relationship between the
Business and Owner tables. However, I thought that this would only keep
existing records updated not create new ones!

(2) The second question is - how could the Upsize process have stopped
this working?

I appreciate your time and help in answering these questions.

Kind regards

Terry

[Bob Quintal]

"Terry" <Te***@supradata.net> wrote in
news:11**********************@l41g2000cwc.googlegr oups.com:

Hello,

I would appreciate any advice or help with a number of bugs I
have in Access 97 front end/SQL 2000 database.

Just a little background information to get started. I have
just converted using the MS Upsize wizard an Access 97
database to SQL 2000. Nearly everything seems to be working,
however there are a number of bugs still to be resolved.

When a Business form is loaded to create a new business record
another sub form Owner is also loaded but is at first blank.
Then as soon as the first (any?) field in this sub form is
clicked on and any character typed the BusinessID is shown at
the top of the Owner form. Then if I close the Business form
down and check the database tables I find that a table linking
the Business and Owner tables (e.g. BusinessRel) has a new
record.

(1) My first questions is how does this new record get
automatically created? I have checked the code for both
Business and Owner forms and cannot find any Insert
statements. The only other information that my be relevant is
there is a cascading update relationship between the Business
and Owner tables. However, I thought that this would only keep
existing records updated not create new ones!

(2) The second question is - how could the Upsize process have
stopped this working?

I appreciate your time and help in answering these questions.

Kind regards

Terry

Answer (1) the subform control creates the necessary records
internally. You cannot see the insert statement because it is
internal to the subform control on your form.

Answer (2), I don't know, but you can check that the parent-child
links in the subform control survived the migration correctly.
--
Bob Quintal

PA is y I've altered my email address.

[Terry]

Hello,

Thanks very much Bob for the answers to my questions. I can easily
access the controls on the form or subform using the design option.
However, how do I get to the internal controls within Access? Also, how
can I check the parent child links within Access on my upsized
database?

Thanks very much for your help.

Kind regards

Terry

[Bob Quintal]

"Terry" <Te***@supradata.net> wrote in
news:11*********************@l41g2000cwc.googlegro ups.com:

Hello,

Thanks very much Bob for the answers to my questions. I can
easily access the controls on the form or subform using the
design option. However, how do I get to the internal controls
within Access? Also, how can I check the parent child links
within Access on my upsized database?

Thanks very much for your help.

Kind regards

Terry

You can never get to the internal code within Access. It's
precompiled and part of the .exe or a .dll

You can check the parent link fields and child link fields
properties of the subform control.

If you need to check the relationships in the MDSE database, you
will need to use some tool for SQL Server, which is beyond the
scope of this newsgroup.

--
Bob Quintal

PA is y I've altered my email address.