Using Form Query to Load Multiple Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry - 14 May 2007 14:17 GMT

My Database has a main table with 24 linked tables to it.
A form is used to add the base information alonh with updating each table
with a reference number. (Donor is automatic as it is the key) So when user
presses the Add Key an completed entry is made to the main table as well as
an entry, in each of the linked tables, for the donor and reference numbers.
Main table consists of 9 fields that relate to a donor.
Form uses a query to load the data in the main table and load the reference
number in each of the linked tables. Form worked fine when updating the main
and 15 linked tables. I have the need to add more tables and when I do the
database locks up. I have looked to see it ther is a limit as to number of
entries allowed in a query but have not found the information I need.
Can someone tell me where to look or give me a clue of how I can resolve
this opportunity? This has been bugging me for the last several days.

Reply to this Message

M Skabialka - 14 May 2007 17:03 GMT

The maximum length of an SQL statement using RunSQL is 255 characters. You
may have the same limitation depending on how you are defining the control
source.

You can shorten the number of characters in a query using code similar to
these:

SELECT tblEmployee.EmployeeID, tblEmployee.LastName,
tblEmployee.FirstName,tblEmployee.MiddleName
FROM tblEmployee;

SELECT e.EmployeeID, e.LastName, e.FirstName, e.MiddleName
FROM tblEmployee AS e;

SELECT emp.*
FROM tblEmployee as emp;

Mich

> My Database has a main table with 24 linked tables to it.
> A form is used to add the base information alonh with updating each table
[quoted text clipped - 14 lines]
> Can someone tell me where to look or give me a clue of how I can resolve
> this opportunity? This has been bugging me for the last several days.

Reply to this Message

Larry - 15 May 2007 14:37 GMT

Mich,

Opportunity resolved.
Thanks

> The maximum length of an SQL statement using RunSQL is 255 characters. You
> may have the same limitation depending on how you are defining the control
[quoted text clipped - 33 lines]
> > Can someone tell me where to look or give me a clue of how I can resolve
> > this opportunity? This has been bugging me for the last several days.

Reply to this Message