Re: Table Defaults

Yes, I understand what you are saying, but wouldn't that make the property
DISPLAY DEFAULTS????

This following definition is from Microsoft

http://www.microsoft.com/mspress/books/sampchap/5600b.aspx

Fetch Defaults Choose Yes (the default) to have the form fetch the default
values from the field definitions when you move to a new row. Set this
property to No to use only the Default Value settings you have specified for
controls.

My problem really has to do with the call to sp_Mshelpcolumns procedure is
getting in the way of user entry. As the user types and the form becomes
dirty, the keystrokes get lost / jumbled. Franklin becomes nklinFa. Not
exactly user friendly. On most forms it is not a problem but on those more
complex forms with an underlying table with many columns it becomes an issue.
One workaround is to redesign those lengthy tables but then that gets in the
way bound forms / User interface which is the benefit of using Access as a
front end.

I have tested against a table that has no defaults and it doesn't seem to
matter.

I think I know where this is headed eventually. aka .Net

For some tables it actually inhibits

"Tom van Stiphout" wrote:

On Tue, 6 Nov 2007 05:27:00 -0800, RJ <RJ@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

It appears you assume FetchDefaults prevents the server call. However,
the help file says "Returns or sets a Boolean indicating whether
Microsoft Access SHOWS default values for new rows on the specified
form before the row is saved."

I'm reading this such that the call is always made, but the results
are optionally shown on the form.

-Tom.



Is it normal???

When adding a new record, via a form, as soon as the form goes dirty (user
keystroke) ADP/SQL Server goes out the underlying table to retrieve all
defaults defined for any column. It does this by calling the
sp_Mshelpcolumns procedure which is very costly.

For some tables it actually inhibits / interferes with the user entry. I
rarely use control default values however I assumed (or is that hope) that
table defaults would be applied at the server level and not the client level.
Is there anything I can do to eliminate/reduce this problem?

The form property has Fetch defaults as False. ADP 2003 (now SP2) Sql
Server 2k sp4.

I have looked online but have found little on the topic. Help me please!

.

Relevant Pages

  • SecurityFocus Microsoft Newsletter #49
    ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
    (Focus-Microsoft)
  • Re: AD management snap in cannot find DC (netdiag /v workstation)
    ... The name.local entries are used by my apache server to implement ... Attr: subschemaSubentry ... Owner of the binding path: ... Component Name: Client for Microsoft Networks ...
    (microsoft.public.windows.server.active_directory)
  • Re: IIS Start up errors
    ... provide the detailed steps to reinstall the IIS server in SBS 2003 server. ... For example, programs such as Microsoft ... In the Currently installed programs list, click Windows Small Business ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant see performance report, etc. SBS2003
    ... Windows Performance monitor component changes the ... However, for "OpenSSH Server", you need to ensure it started, or set ... click to check the "Hide All Microsoft ... Reinstall Monitoring component: ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant send or receive e-mail to POP3 users on same domain--HELP!
    ... Policies on the Exchange Server: ... Consider your current condition, certainly, we can use the POP3 Connector ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)