Tables being created by opening form

[Rob]

I'm using Access 2003 with a sql server back-end. One form I've
designed, when opened, creates a local table called "Admin - 00", with
the number incrementing each time the form is opened. I assume Admin
is the username.
The table has 1 column named "ODBC" of type memo. The table is filled
with 302 rows of the following string:
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right
truncation

If I open the form into design mode directly, 2 tables with 151 rows
of the above are created.

The form itself is a 'single form' view with no recordset. It's
extremely full, primarily made up with a tabcontrol with 13 tabs. On
one tab, I am on the edge of overloading the form - if I add more than
a few controls to the page the entire form fails and I'm unable to
open in normal or design mode anymore. This is not a problem (yet),
but I am very worried about these tables that keep being generated.
Does anyone know what's going on?

 

[George Nicholson]

I can't answer your question about the table, but I may be able to offer you
a workaround vis-a-vis the form.

There is a limit of how many controls you can add to a form a report over
its lifetime (754). Deleted controls count against the total. A control on a
tab control counts against the form holding the tab. Afaik, compacting won't
change the "lifetime" count as it would for deleted fields vs the "255
fields in a table" limitation. (If you've done a lot of deleting, you can
"fix" the count by creating a new form and copy existing controls to it).

If you are running up against this constraint, consider changing your form
setup a bit. Put a subform control on each (or some) of your tabs and then
create a subform laid out with the controls that used to be directly on the
tab. You might even get a performance boost from this if you wait until the
tab is selected before loading the form (i.e., assigning the source object).

HTH,

 

[John W. Vinson]

I'm using Access 2003 with a sql server back-end. One form I've
designed, when opened, creates a local table called "Admin - 00", with
the number incrementing each time the form is opened. I assume Admin
is the username.
The table has 1 column named "ODBC" of type memo. The table is filled
with 302 rows of the following string:
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right
truncation

Have you Compacted and Repaired the database? Do you get these tables under
any other circumstances, or just with this form?

John W. Vinson [MVP]

 

[Rob]

I'm using Access 2003 with asqlserverback-end. One form I've
designed, when opened, creates a local table called "Admin - 00", with
the number incrementing each time the form is opened. I assume Admin
is the username.
The table has 1 column named "ODBC" of type memo. The table is filled
with 302 rows of the followingstring:
01004-0- [Microsoft][ODBCSQLServerDriver]Stringdata,right
truncation

Have you Compacted and Repaired the database? Do you get these tables under
any other circumstances, or just with this form?

John W. Vinson [MVP]

Compacting and repairing doesn't help. This seems to be the only form
with the issue - it's possible other forms could cause the same
problem, but most don't.

 

[Rob]

Ok, don't worry about it. I've tested it some more, the tables are
labelled "username - ##". However after the 100th table being made,
it doesn't add anymore. It's a problem we can live with.

 

[John W. Vinson]

Ok, don't worry about it. I've tested it some more, the tables are
labelled "username - ##". However after the 100th table being made,
it doesn't add anymore. It's a problem we can live with.

That's sure got me baffled! I've never seen or heard of this happening.

John W. Vinson [MVP]