By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

AccessXP Startup switch /ro

P: n/a
Hi All,
In the desktop shortcut I added the /ro switch to the command line

\\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro

and the db opens but I can still change data that is displayed on a
form.

So, what am I missing?? If the "/ro" switch is suppose to open the db
as read-only then why is it letting me change data thru a opened form.
thanks
bobh.

Nov 13 '05 #1
Share this Question
Share on Google+
18 Replies


P: n/a
bobh wrote:
Hi All,
In the desktop shortcut I added the /ro switch to the command line

\\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro

and the db opens but I can still change data that is displayed on a
form.

So, what am I missing?? If the "/ro" switch is suppose to open the db
as read-only then why is it letting me change data thru a opened form.
thanks
bobh.


Is it bound data on the form?

--
[OO=00=OO]
Nov 13 '05 #2

P: n/a
bobh wrote:
Hi All,
In the desktop shortcut I added the /ro switch to the command line

\\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro

and the db opens but I can still change data that is displayed on a
form.

So, what am I missing?? If the "/ro" switch is suppose to open the db
as read-only then why is it letting me change data thru a opened form.
thanks
bobh.


Is it bound data on the form?

--
[OO=00=OO]
Nov 13 '05 #3

P: n/a
Yes it is......

Nov 13 '05 #4

P: n/a
Yes it is......

Nov 13 '05 #5

P: n/a
I think I read something about modifying your shortcuts to point to the
actual Access program (not the database file) and have the database
file location as the parameter, and the command line options.

Nov 13 '05 #6

P: n/a
I think I read something about modifying your shortcuts to point to the
actual Access program (not the database file) and have the database
file location as the parameter, and the command line options.

Nov 13 '05 #7

P: n/a

http://office.microsoft.com/en-us/as...888101033.aspx

Yep. I knew I had seen it soemwhere.

Nov 13 '05 #8

P: n/a

http://office.microsoft.com/en-us/as...888101033.aspx

Yep. I knew I had seen it soemwhere.

Nov 13 '05 #9

P: n/a

Yep...

I did that

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
\\Homf6\Vol2\LifeComp\ComonDbs*\AVA\Apps\AvaXP.mdb /ro

and even thou I get the message saying the 'database is read-only' I
can still change data that's displayed in a bound form.
I'm wondering if it has something to do with the fact that it's a split
database(front-end/back-end)
bobh.

Nov 13 '05 #10

P: n/a

Yep...

I did that

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
\\Homf6\Vol2\LifeComp\ComonDbs*\AVA\Apps\AvaXP.mdb /ro

and even thou I get the message saying the 'database is read-only' I
can still change data that's displayed in a bound form.
I'm wondering if it has something to do with the fact that it's a split
database(front-end/back-end)
bobh.

Nov 13 '05 #11

P: n/a
Is it actually changing the underlying data in the AvaXP.mdb database?
Or are you saying the data is from a different source than AvaXP.mdb?

Nov 13 '05 #12

P: n/a
Is it actually changing the underlying data in the AvaXP.mdb database?
Or are you saying the data is from a different source than AvaXP.mdb?

Nov 13 '05 #13

P: n/a
Yes it is......
I load the form, select a policy nbr, change a value, close the form.

go to database window view, tables tab, directly open the table, find
the polcy nbr, check the field I changed via the form and it's changed
to the value I entered on the form.

bobh.

Nov 13 '05 #14

P: n/a
Yes it is......
I load the form, select a policy nbr, change a value, close the form.

go to database window view, tables tab, directly open the table, find
the polcy nbr, check the field I changed via the form and it's changed
to the value I entered on the form.

bobh.

Nov 13 '05 #15

P: n/a
Bri
Bobh,

The RO will apply to the objects in the FE only. Since the data is in a
different db it can be changed. Now try and change the design of a form
and you won't be able to. Or if there is a local table...

--
Bri

Nov 13 '05 #16

P: n/a
Bri
Bobh,

The RO will apply to the objects in the FE only. Since the data is in a
different db it can be changed. Now try and change the design of a form
and you won't be able to. Or if there is a local table...

--
Bri

Nov 13 '05 #17

P: n/a
and I was hoping that would not be the answer but, I'll just have to go
and change all the forms to open as read-only in the front-end........
thanks
bobh :)

Nov 13 '05 #18

P: n/a
and I was hoping that would not be the answer but, I'll just have to go
and change all the forms to open as read-only in the front-end........
thanks
bobh :)

Nov 13 '05 #19

This discussion thread is closed

Replies have been disabled for this discussion.