Attaching a checkbox to an SQL Server 2000 field (bit or binary)

  • Thread starter Rick in Savannah
  • Start date
R

Rick in Savannah

Hi. I've searched the kb and the groups, and I haven't found an answer to
this question. I apologize if I've overlooked it.

I have a table in SQL Server 2000, and a bound form in Access 2000. I
simply want to add a field in the table, and a bound checkbox on the form.
Can someone instruct me on this?

Thanks,
Rick
 
J

JohnFol

Adding the field in SQL is either done using Enterprise Manager, finding the
db, finding the table and doing a right click choose Design, or you do it
with QueryAnalyser and Alter Table.

When it's added, reattach the table to the MDB. Your queries / reports /
forms then have access to the value, allowing you to bind to it.
 
Top