Change Properties Of Field Through ASP !

[Lovely Angel For You]

Dear Friends
Hope you all doing great.

I have this databse uploaded to a server. I want to know is there any
way I can change the property of a field from running an ASP script.

There is a field which stores a date and lesson no. I want that these
should not repeat. So want to set Repeat Property to No.

Any help on that will be great.

Thanks.

Love
Lovely

--------------------------------------------

[John Beschler]

Angel,

I assume what you mean is you want the field(s) to not
allow duplicate values. If so, this is possible; however,
the correct method will depend on which database you are
using. Let us know which database you are using and
someone will be able to post the relevant syntax.

HTH,
John

>-----Original Message-----
>Dear Friends
>Hope you all doing great.
>
>I have this databse uploaded to a server. I want to know

is there any

>way I can change the property of a field from running an

ASP script.

>
>There is a field which stores a date and lesson no. I

want that these

>should not repeat. So want to set Repeat Property to No.
>
>Any help on that will be great.
>
>Thanks.
>
>Love
>Lovely
>
>--------------------------------------------
>.
>

[Lovely Angel For You]

Hello To All

I am using MS Access 2000.

And one more thing is it possible to add a field to already created table.

Waiting for your lovely replies.

Love
Lovely

__________________________________________________ _____

"John Beschler" <giles@geewhiz.com> wrote in message news:<0a4001c36331$8901cdd0$a401280a@phx.gbl>...

> Angel,
>
> I assume what you mean is you want the field(s) to not
> allow duplicate values. If so, this is possible; however,
> the correct method will depend on which database you are
> using. Let us know which database you are using and
> someone will be able to post the relevant syntax.
>
> HTH,
> John
>
>
>
>
>

> >-----Original Message-----
> >Dear Friends
> >Hope you all doing great.
> >
> >I have this databse uploaded to a server. I want to know

> is there any

> >way I can change the property of a field from running an

> ASP script.

> >
> >There is a field which stores a date and lesson no. I

> want that these

> >should not repeat. So want to set Repeat Property to No.
> >
> >Any help on that will be great.
> >
> >Thanks.
> >
> >Love
> >Lovely
> >
> >--------------------------------------------
> >.
> >