Re: Locate Table

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 08/30/04 

Date: Mon, 30 Aug 2004 05:32:36 -0700

Thanks Jeff
No user will have direct access to the Id generating
function. The results from this function will be used to
assign a unique key to a new entry in the data base.
I have choosen not to use the auto number generator.
I have just stated using access 2000 and VB5 seriously
and am still finding my feet in this environment. Once I
am profecient I will move on to the newer versions.
Thanks for the input.

>-----Original Message-----
>Vaughn
>
>Not all objects are available. An unopened form isn't,
for example.
>
>A table and it's fields would be accessible via a
recordset. You can refer
>to this table in your procedure by defining a recordset
based on that table.
>Or you could create a query that appends a new record to
the table, plus a
>procedure that generates your ID number.
>
>Out of curiosity, are you planning to have users see or
otherwise work with
>that ID number? If not, have you considered using the
already-available,
>automatically-incrementing unique identification number
that Access
>provides?
>
>--
>Good luck
>
>Jeff Boyce
><Access MVP>
>
>.
>

Relevant Pages

  • Re: Rs.AddNew fails with error 3219 invalid operation
    ... > I am running the folowing code to open a DAO Recordset against and ... > Dim Ary() As String ... If your recordset doesn't include a unique key (maybe event the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sql error Message
    ... most likely you dont have a unique key in your recordset so that ... the db engine cant tell for sure which row you want to update. ...
    (borland.public.delphi.database.ado)
  • Re: supports(adIndex) = False
    ... You have to use for your recordset ... adOpenKeyset, Your Lock Options, adCmdTableDirect ... You may also have to use a client side cursor ... >applied to that unique key. ...
    (microsoft.public.access.modulesdaovba)