Re: Access linked table to SQL server 2000

#1 (**permalink**) 02-27-2008, 07:14 PM

"Martin" <martin4nospam@yahoo.co.uk> wrote in message
news:0d6601c3505a$96d92dc0$a301280a@phx.gbl...
> 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.

I would try adding a column of type timestamp, and if you don't have one,
create a primary key (unique index) to help jet with the locking/update of
rows.

Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode