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 3 1675
"Terry" <Te***@supradat a.net> wrote in
news:11******** **************@ l41g2000cwc.goo glegroups.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.
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
"Terry" <Te***@supradat a.net> wrote in
news:11******** *************@l 41g2000cwc.goog legroups.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jim Geissman |
last post by:
I have function that returns a table of information about properties. The
data comes from three different tables -- addresses (called PropertyID),
property characteristics, and events concerning those properties (sales,
appraisals, etc.), plus a table that maps one representation of property
types into another. The records are selected on...
|
by: Max |
last post by:
Hi,
I have SqlServer 2000 as back end and Access 2000 as front-end. All
tables from Sqlserver are linked to Access 2000. I am having write
conflict problem with one of my form which is bound to a query which
consist of let say tableA , TableB and TableC (all are linked tables
from SqlServer. While the form is open I am modifying TableA...
|
by: Devonish |
last post by:
I have a form designed as a Continuous form which displays one record
per
line. Taking account of the header and footer and the size of the
screen, I
can display 30 records at a time. I can see other records by scrolling
up or
down with either the scroll bar on the right of the screen, or the up
and down
arrows which are above and below...
|
by: shaun palmer |
last post by:
When doing certain Data entries in a Database, the statement "you
can't go to the specified record "comes up in a message box. Yet in
other Data entries using the same procedure, this statement does not
occurr. Why is that and what can be done to solve the problem?
We have approximately 19,000 records. The relationships are set as...
|
by: Me |
last post by:
Hi all...
I have a duly annoying ODBC problem:
I make a new, blank Access 2k database, and add a single ODBC link to
an MS SQL Server, using a DSN which has full access to the data. If
I remain in the same session, everything works. If I exit the MDB and
return to it,
the table is suddenly not allowing record addition! (I try to add a...
| |
by: AnandaSim |
last post by:
I just had a google through this NG but have not seen mention of Erik
Rucker's blog entry and the new Jet:
http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx
mentioned by Mike Gunderloy
http://www.larkware.com/dg4/TheDailyGrind726.html
Aside from the Sharepoint feature extension, amazing news.
|
by: Dennis |
last post by:
I have created an access database table in code with the field "KeyId" as a
GUID type. What is the SQL syntax for updating a record matching this GUID,
i.e.,
Dim myGUid as New GUID(....)
mySQL = "UPDATE ITEMS SET Title="New Record No. 1", WHERE KeyID = myGUID)
The above of course tries to match the KeyID field value with the value...
|
by: jojoba |
last post by:
Hi,
I hope this post is ok for this group.
Here's my deal:
I have two computers on my LAN at home.
One desktop. One laptop.
Both computers are wireless enabled (and wired enabled too).
I have running a fairly simple HTTP server (written in python) that i
|
by: Donn Ingle |
last post by:
In an unusual twist of code I have a subclass which overrides a method but
it also needs to call the original method:
class One:
def add (self, stuff):
self.stuff.append(stuff)
class Two(One):
def __init__(self, otherstuff):
<MYSTERY>(otherstuff) #otherstuff must go into list within the parent.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |