I think that you'd have to limit the windows remote access somehow. Other than that I can't offer much help on this topic.

How are you querying that table??

Can we see the ddl?

I'm sure there's a way, but sql server is mean to give access to multiple users at the same time... I don't see why you'd what to limit this to...

Can't you create more??

Err, why can there be only one person at the time using the system?

You can net send on the network and warn everyone that the server is shutting down.

Have you checked openrowset/openquery?

Actually it's RG, but I see the confusion with the underlining in the forum... problem solved now .

hycoos?? Care to give an exemple?

That one I didn't test. You'll have to check it out and report back. I assume that the view can update only one table at the time... ...

Seems logical... Access usually uses sp_help* to get the tables definition. If this info is not in the view, I don't see how it could use it. Maybe...

Plese post :

-DDL

-Sample data

-expected results

Sorry for the unforseen problem, I had never experienced it (using mostly sps here). Anyways I was able to recreate the problem like this.

1 - Create a...

Sorry I hadn't understood the user defined datatype part. As Noeld said, you have to unlink the UDD, drop it, recreate it and then rebind it the the columns....

That can't really cause problems... why aren't you just altering the tables?

Also why aren't you using varchar()?