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 2666
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: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: 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:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |