Making field read only

Goodday all

I have a details view on a vb form .

Now that i have been working on the program , i realise that i would like to make some fields " read only '

Is that possible , and if so how?

Thanks

Rob

You could:

1 - Set permissions in SQL Server for SELECT only.
2. -Set the form properties to 'Read Only' (Enabled = False) for that textbox.

sql

make the database unavailable while loading it

Hi All:

I need to make my database unavailable when i am loading the db. This
happens daily and the db is not connected to any online app, to make
the app unavailable. It is queried thru an Access and hence available
all the time.
The load happens daily for an hour in the morning.
Is there anyway to make it inaccessible to users while loading data
and then make it accessible

Thank you
RS(rshivaraman@.gmail.com) writes:

Quote:

Originally Posted by

I need to make my database unavailable when i am loading the db. This
happens daily and the db is not connected to any online app, to make
the app unavailable. It is queried thru an Access and hence available
all the time.
The load happens daily for an hour in the morning.
Is there anyway to make it inaccessible to users while loading data
and then make it accessible

The process that runs the load could issue ALTER DATABASE SET SINGLE_USER
when it starts and ALTER DATABASE SET MULTI_USER when it's done. You may
be interested in adding WITH ROLLBACK IMMEDIATE to the single-user command.

See Books Online for details.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

make the database unavailable while loading it

Hi All:
I need to make my database unavailable when i am loading the db. This
happens daily and the db is not connected to any online app, to make
the app unavailable. It is queried thru an Access and hence available
all the time.
The load happens daily for an hour in the morning.
Is there anyway to make it inaccessible to users while loading data
and then make it accessible
Thank you
RS
Check "ALTER DATABASE" in BOL.
Example:
use master
go
alter database northwind
set RESTRICTED_USER -- you can also use SINGLE_USER
with ROLLBACK IMMEDIATE
go
-- do db loading
...
go
alter database northwind
set MULTI_USER
go
AMB
"rshivaraman@.gmail.com" wrote:

> Hi All:
> I need to make my database unavailable when i am loading the db. This
> happens daily and the db is not connected to any online app, to make
> the app unavailable. It is queried thru an Access and hence available
> all the time.
> The load happens daily for an hour in the morning.
> Is there anyway to make it inaccessible to users while loading data
> and then make it accessible
> Thank you
> RS
>
|||You could try setting the database into SINGLE_USER or RESTRICTED_USER mode.
PS Please don't try to hijack a thread into comp.* heirarchy by setting the
follow-up to a single newsgroup. Not all of us post to a news server with
access to comp.*
A
<rshivaraman@.gmail.com> wrote in message
news:1184605005.617566.220470@.k79g2000hse.googlegr oups.com...
> Hi All:
> I need to make my database unavailable when i am loading the db. This
> happens daily and the db is not connected to any online app, to make
> the app unavailable. It is queried thru an Access and hence available
> all the time.
> The load happens daily for an hour in the morning.
> Is there anyway to make it inaccessible to users while loading data
> and then make it accessible
> Thank you
> RS
>
|||Hi Mesa and Bertrand :
Thanks a bunch for your replies. I am not sure you meant by replying,
i did post this question to 3 newsgroups and quite surprised, why your
answers didnt come up in those. I did click the followup button, but
didnt know what to do with it, so left it empty. From next time, will
not click the followup button
Thanks again
Apologize for any trouble
RS

make the database unavailable while loading it

Hi All:
I need to make my database unavailable when i am loading the db. This
happens daily and the db is not connected to any online app, to make
the app unavailable. It is queried thru an Access and hence available
all the time.
The load happens daily for an hour in the morning.
Is there anyway to make it inaccessible to users while loading data
and then make it accessible
Thank you
RSCheck "ALTER DATABASE" in BOL.
Example:
use master
go
alter database northwind
set RESTRICTED_USER -- you can also use SINGLE_USER
with ROLLBACK IMMEDIATE
go
-- do db loading
...
go
alter database northwind
set MULTI_USER
go
AMB
"rshivaraman@.gmail.com" wrote:

> Hi All:
> I need to make my database unavailable when i am loading the db. This
> happens daily and the db is not connected to any online app, to make
> the app unavailable. It is queried thru an Access and hence available
> all the time.
> The load happens daily for an hour in the morning.
> Is there anyway to make it inaccessible to users while loading data
> and then make it accessible
> Thank you
> RS
>|||You could try setting the database into SINGLE_USER or RESTRICTED_USER mode.
PS Please don't try to hijack a thread into comp.* heirarchy by setting the
follow-up to a single newsgroup. Not all of us post to a news server with
access to comp.*
A
<rshivaraman@.gmail.com> wrote in message
news:1184605005.617566.220470@.k79g2000hse.googlegroups.com...
> Hi All:
> I need to make my database unavailable when i am loading the db. This
> happens daily and the db is not connected to any online app, to make
> the app unavailable. It is queried thru an Access and hence available
> all the time.
> The load happens daily for an hour in the morning.
> Is there anyway to make it inaccessible to users while loading data
> and then make it accessible
> Thank you
> RS
>|||Hi Mesa and Bertrand :
Thanks a bunch for your replies. I am not sure you meant by replying,
i did post this question to 3 newsgroups and quite surprised, why your
answers didnt come up in those. I did click the followup button, but
didnt know what to do with it, so left it empty. From next time, will
not click the followup button
Thanks again
Apologize for any trouble
RS