473,387 Members | 1,303 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Open as Read-Only

Hello,

I have a database that is on my company's network that everyone needs
to be able to see, but I only want certain people to change any data
in the database. Is there a way (like there is in Excel, why can't
Microsoft make products of the same family have the same advanced
functions) to set an option so that the database opens in read-only
mode unless a specific password is entered?

Thanks,
Jun 27 '08 #1
3 2172
On Apr 21, 10:50*am, colemanj4 <colema...@gmail.comwrote:
why can't
Microsoft make products of the same family have the same advanced
functions?
It's because they are adopted.
Jun 27 '08 #2
Any real help pertaining to my question?

On Apr 21, 11:01*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:
On Apr 21, 10:50*am, colemanj4 <colema...@gmail.comwrote:
why can't
Microsoft make products of the same family have the same advanced
functions?

It's because they are adopted.
Jun 27 '08 #3
On Apr 24, 7:35*pm, colemanj4 <colema...@gmail.comwrote:
Any real help pertaining to my question?

On Apr 21, 11:01*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:
On Apr 21, 10:50*am, colemanj4 <colema...@gmail.comwrote:
why can't
Microsoft make products of the same family have the same advanced
functions?
It's because they are adopted.
I guess it's not real help for you to understand that these "products
of the same family" have very different antecedents, were not created
by the same entities, and largely, are totally different in concept
and form. If I adopt a rock and George W Bush I shouldn't expect them
to be similar (except in intelligence, I suppose), just because they
are now part of the Fairfield family.

If I had to do what I think you want to do I would try:
displaying the Access/Jet data in an Excel sheet with linking or
simply a static load on open,
using Access security to control who may edit,
developing a reports-only Access application linked to the tables of
the first,
transferring the data to a database engine such as MS-SQL Server
capable of seeting and using discrete permissions
or
displaying the data in some sort of html-hta-asp application.

Probably the second last option is better than the others as it can be
implemented at a very low level and will be difficult to circumvent.


Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Alex | last post by:
Rossum's tutorial on Python states: "open() returns a file object, and is most commonly used with two arguments: 'open(filename, mode)' mode 'r+' opens the file for both reading and writing." ...
6
by: Rolf Schroedter | last post by:
(Sorry for cross-posting). I need to access large files > 2GByte (Linux, WinXP/NTFS) using the standard C-library calls. Till today I thought I know how to do it, namely for Win32: Use open(),...
13
by: Blue | last post by:
Hi , Can any one please let me explain me the diffrences between "open"/ "fopen" or "read"/"fread" or "write/fwrite". I know that "open" /"read" / "write" are system calls and "fopen"...
9
by: ferbar | last post by:
Hi all, I'm trying to read from the txt file 'ip.packets.2.txt' using the read function. It seems everything ok, but I get a -1 when executing >>bytesr = read(fdo1, bufread, 2); The 'open'...
1
by: Doug Wyatt | last post by:
So I have a log file that I'm writing with one C# program and want to open and read it in another one. I open it via : StreamWriter log = File.AppendText(logPath); log.AutoFlush = true; but...
3
by: trellow | last post by:
Hello, I am writing an application that needs to read a file that is already open by another process for writing. When I do the following: FileStream fs = new FileStream(fileName,...
3
by: red | last post by:
I have this: using System; using System.Runtime.InteropServices; using System.Text; class FileReader { const uint GENERIC_READ = 0x80000000; const uint OPEN_EXISTING = 3;
14
by: Rochester | last post by:
Hi, I just found out that the general open file mechanism doesn't work for named pipes (fifo). Say I wrote something like this and it simply hangs python: #!/usr/bin/python import os
10
by: jimmy | last post by:
Hi again, sorry for posting two questions so close together but im working on a school project which is due in soon and running into some difficulties implementing the database parts. I have the...
5
by: bvidinli | last post by:
is there a way to find out if file open in system ? - please write if you know a way other than lsof. because lsof if slow for me. i need a faster way. i deal with thousands of files... so, i...
0
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,...
0
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...
0
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...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
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...
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.