Re: Howto get Rowsource property in Access 2k db?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 12/05/04 

Date: Sun, 5 Dec 2004 08:32:28 -0500

Irena wrote:
> Hi all again,
>
> Maybe, I'd better try to do this:
>
> How can it programmatically get/return the "Row source" or Rowsource
> property of a generic Table in a generic Access 2K database???
>
> I found an example in VB:
> me!combobox.RowSource
>
> where "me" is the loaded form, but I am unable to apply it in ASP.
> Any idea?
>

As Allen mentioned, the only way to get at the RowSource property of a Field
is through the use of DAO (Data Access Objects), which is the data access
technology which pre-dated ADO (ActiveX Data Objects), the only data access
technology which is recommended to be used in ASP. While DAO has more
functionality and can outperform ADO when working with Jet databases*, you
should not use DAO in ASP because it is single-threaded and its use will
severely impair the performance of your website.

"RowSource" is not an inherent property of Jet database columns (fields). It
is a property that is added on by Access (you must remember that Access is
not the database: Access is a front-end tool for working with many
databases, including Jet and MSDE databases). While some of the
Access-defined properties (such as Description) have been exposed by the Jet
OLEDB provider and are accessible using ADOX (ActiveX Data Objects
eXtensions for DDL and Security), Rowsource has not been exposed, and
probably will not be, given the deprecation of the Jet components
(http://msdn.microsoft.com/library/en-us/mdacsdk/htm/mdac_deprecated_components.asp?frame=true)

Bottom line: you will need to write your own code in ASP to replace the
"hand-holding" that was done by the Access development environment.

Bob Barrows

*DAO was designed specifically to work with Jet databases, and as such, is
more efficient in some operations than ADO, which is really a universal data
access technology. 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: OOP in database programming - Newbie question
    ... > of switching data access components generally at all. ... very difficult to switch databases ... don't use data-aware components - they are for little tots ... answer with "If one uses ADO with OLE DB providers you can easily...". ...
    (borland.public.delphi.non-technical)
  • missing lines when opening from outside access
    ... While editing/using the data access page from within access all is ... But when I open this page in my browser I´m missing a lot of entries. ... When opening from within Access I get 545 line items. ... links and databases. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: MS Access rated Number 3
    ... Microsoft SQL Server is still ... Database and Data Access, Integration ... and Reporting Study, ... All other databases had ...
    (comp.databases.ms-access)
  • Re: MS Access rated Number 3
    ... Microsoft SQL Server is still ... Database and Data Access, Integration ... and Reporting Study, ... All other databases had ...
    (comp.databases.ms-access)
  • MS Access rated Number 3
    ... Microsoft SQL Server is still ... Database and Data Access, Integration ... and Reporting Study, ... All other databases had ...
    (comp.databases.ms-access)