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
..
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
..