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. 18 2667
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]
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]
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.
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.
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.
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.
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?
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?
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.
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.
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
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
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 :)
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 :) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Neil Benn |
last post by:
Hello,
I'm looking at a small app which would need a very quick
startup time for the Python interpreter. It doesn't do much (copying
and caching of files, no GUI) but I need the Python...
|
by: Bill |
last post by:
I created a very simple DB with several forms and tables in chinese version
of Access XP running in Chinese Win XP. Now I try to run the same DB in
English version of Access XP running in English...
|
by: Steve |
last post by:
Recently due to viruses I had to wipe my harddrive and reload everything. Now,
in AccessXP(2000 and XP mode) all new reports and all reports in existing
databases open in Fit to Page rather than...
|
by: Dennis |
last post by:
If I create a database in AccessXP-2000mode, can someone with Access2003 run it?
Do either of us have to do anything special?
Thanks!
Dennis
|
by: Bob Hynes |
last post by:
Hi All,
In one of my Access97 db applications I created a report which I
output to a RichTextFormat file attach it to an Email and send it out,
that has worked just fine for a couple of years now....
|
by: bobh |
last post by:
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...
|
by: Salad |
last post by:
I designed a small app and I wanted to do a BrowseFolder (see
http://www.mvps.org/access/api/api0002.htm), basically do a file open
diaglog and select a directory/folder. The problem is that you...
|
by: Sudhesh |
last post by:
Hi,
In an ASP.Net project file, is there a setting/indicator that
indicates which page is set as the startup page? When I switch the
startup page in Visual Studio, its not reflected in the IIS,...
|
by: bobh |
last post by:
Hi All,
Is there a way to generate an AccessXP report and combine that with an
external text file and then pass that to Outlook as one attachment?
thanks
bobh.
|
by: bobh |
last post by:
HI,
I understand AccessXP file size has a 2 gig limit but I trying to
understand the following
I have a tab delimited data file that is 1.3 gigs big and I try to
import it into an empty...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |