The answers to both of your questions could be very simple, but I'm afraid you havent given us enough information.

How are you connecting to the database? (eg: ADO code, DAO code, Data Control).

What code are you using (or if you are using a Data Control, what properties have you set)?