Access linked table to SQL server 2000

M

Martin

Hi,

I've tried adding a column name "TicketsPrinted" with a
data type "bit" to an Orders table in SQL server 2000.

I relink the table in Access 2000 via the linked table
manager. When I go into the linked table and try to
change or update data it tells me that another user is
trying to access the database and do I want to drop the
changes or copy it to the clipboard.

When I remove the "TicketsPrinted" Column or change its
data type everything works OK.

What is going wrong?
There is another field in this table with a data type bit
and it works fine.

Any help would be greatly appreciated.

Martin
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top