Locking the database to a single user so that other user wont change it
0
votes
1
answer
86
views
I am using SQL Server CE 4.0. In office the database (
.sdf
) file are on a server. When I want to change design of the database I have to copy it to local PC and access it since n/w connection to a compact database not allowed.
But when I modify the design of tables I have to be sure that no other user in my office connects to that database and changes the same database. Because I have to again copy the changed database to my server PC and I don't want the design changes made by others. So how can I be sure that no one else connected to the database which I have been editing. Is there any method of locking the database to a single user when I edit the design of the database.
Asked by IT researcher
(3178 rep)
Jan 23, 2015, 02:37 PM
Last activity: Jan 26, 2015, 12:16 PM
Last activity: Jan 26, 2015, 12:16 PM