You have helped a lot actually. It was tru these discussions that i am talking to my self and realizing the best approach.

Anyways, i will continue to use this thread to post and I go along

so a few problems i encountered so far:

1. Bit field and boolean value ... work around, if you want to use a check box in an access form bound to a bit field in sql server...make sure that the bit field is set to yes/no.

2. all my data shows #deleted..fix...open linked table manager and refresh all tables...the connection was lost.

3. running my stored procedure...pass through queries work...but i dont think pass through queries like the DECLARE statement with the @ before the parameters...so what do you do..simple...do a pass through query with the statement being:

exec stored-procedure-name

set the ODBC Connect to the connection of the database.

if you are running an action query...set the "Return Records" property to No.

Yep, every day is one problem or another but at the end of the day, i learn...Thank goodness for google!