f



Access database table security - read only

I need to deliver an Access accdb, tables for viewing data only, no front end. Is it possible to make the tables read-only so the user can only look at data but not edit?
0
3/15/2013 3:22:16 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

9 Replies
570 Views

Similar Articles

[PageSpeed] 49

On Friday, March 15, 2013 10:22:16 AM UTC-5, bededo...@gmail.com wrote:
> I need to deliver an Access accdb, tables for viewing data only, no front end. Is it possible to make the tables read-only so the user can only look at data but not edit?

Send it as a PDF, lock it down, is an option.  Maybe export to Excel and lock it down.  Have it installed in an ReadOnly folder.  Have your users open the database using a desktop icon with the command line setting it to read only
0
3/15/2013 3:59:48 PM
On Friday, March 15, 2013 10:59:48 AM UTC-5, Patrick Finucane wrote:
> On Friday, March 15, 2013 10:22:16 AM UTC-5, bededo...@gmail.com wrote:
>=20
> > I need to deliver an Access accdb, tables for viewing data only, no fro=
nt end. Is it possible to make the tables read-only so the user can only lo=
ok at data but not edit?
>=20
>=20
>=20
> Send it as a PDF, lock it down, is an option.  Maybe export to Excel and =
lock it down.  Have it installed in an ReadOnly folder.  Have your users op=
en the database using a desktop icon with the command line setting it to re=
ad only

Thank you.  I was afraid of as much.  I know we can do tricks through a UI =
to make data seem secure, but that does not help me in this case.  The end =
user will need to look at the data and query the data.  We just do not want=
 them to be able to edit the data.
0
3/15/2013 4:41:51 PM

<bededobedado@gmail.com> wrote in message 
news:aeda6e81-478c-404f-a3c2-4cbd40d4eff8@googlegroups.com...
> On Friday, March 15, 2013 10:59:48 AM UTC-5, Patrick Finucane wrote:
>> On Friday, March 15, 2013 10:22:16 AM UTC-5, bededo...@gmail.com wrote:
>>
>> > I need to deliver an Access accdb, tables for viewing data only, no 
>> > front end. Is it possible to make the tables read-only so the user can 
>> > only look at data but not edit?
>>
>>
>>
>> Send it as a PDF, lock it down, is an option.  Maybe export to Excel and 
>> lock it down.  Have it installed in an ReadOnly folder.  Have your users 
>> open the database using a desktop icon with the command line setting it 
>> to read only
>
> Thank you.  I was afraid of as much.  I know we can do tricks through a UI 
> to make data seem secure, but that does not help me in this case.  The end 
> user will need to look at the data and query the data.  We just do not 
> want them to be able to edit the data.

You could set the accdb file to read-only in Windows, but all they would 
need to do is right click and change the property. There is no way to make 
an Access file secure. 

0
none10 (4038)
3/15/2013 9:04:40 PM
bededobedado@gmail.com wrote:
> I need to deliver an Access accdb, tables for viewing data only, no
> front end. Is it possible to make the tables read-only so the user
> can only look at data but not edit?  

Create an MDB instead of an ACCDB and install user level security.  

David
0
secret1 (215)
3/15/2013 9:35:12 PM
Put it on read only media.

-- 
Cheers

The Frog
0
3/15/2013 11:17:09 PM
bededobedado@gmail.com wrote:
> On Friday, March 15, 2013 10:59:48 AM UTC-5, Patrick Finucane wrote:
>> On Friday, March 15, 2013 10:22:16 AM UTC-5, bededo...@gmail.com
>> wrote: 
>> 
>>> I need to deliver an Access accdb, tables for viewing data only, no
>>> front end. Is it possible to make the tables read-only so the user
>>> can only look at data but not edit?  
>> 
>> 
>> 
>> Send it as a PDF, lock it down, is an option.  Maybe export to Excel
>> and lock it down.  Have it installed in an ReadOnly folder.  Have
>> your users open the database using a desktop icon with the command
>> line setting it to read only   
> 
> Thank you.  I was afraid of as much.  I know we can do tricks through
> a UI to make data seem secure, but that does not help me in this
> case.  The end user will need to look at the data and query the data.
> We just do not want them to be able to edit the data.   

Why?

David
0
secret1 (215)
3/15/2013 11:28:16 PM
The Frog wrote:
> Put it on read only media.

That would be slower access but once in memory performance might be OK.  RO 
media like a CD can of course be copied to a HDD and made writable but that 
won't make any difference to the original.  I guess it depends on why you 
don't want it edited, which the OP has carefully not revealed.

David 

0
secret1 (215)
3/15/2013 11:28:21 PM
bededobedado@gmail.com wrote:
> On Friday, March 15, 2013 10:59:48 AM UTC-5, Patrick Finucane wrote:
>> On Friday, March 15, 2013 10:22:16 AM UTC-5, bededo...@gmail.com
>> wrote:
>>
>>> I need to deliver an Access accdb, tables for viewing data only, no
>>> front end. Is it possible to make the tables read-only so the user
>>> can only look at data but not edit?
>>
>>
>>
>> Send it as a PDF, lock it down, is an option.  Maybe export to Excel
>> and lock it down.  Have it installed in an ReadOnly folder.  Have
>> your users open the database using a desktop icon with the command
>> line setting it to read only
>
> Thank you.  I was afraid of as much.  I know we can do tricks through
> a UI to make data seem secure, but that does not help me in this
> case.  The end user will need to look at the data and query the data.
> We just do not want them to be able to edit the data.

It could also be put on a network drive that the user doesn't have write 
permission for.  This runs into trouble if more than one wants to use it 
concurrently as they will not be able to maintain a locking file but for 
single use it will be fine.  In the extreme case you could give every user 
their own copy RO on a network drive or directory.

David 

0
secret1 (215)
3/15/2013 11:32:46 PM
bededobedado@gmail.com wrote:

> I need to deliver an Access accdb, tables for viewing data only, no
> front end. Is it possible to make the tables read-only so the user
> can only look at data but not edit?

There isn't a reliable way.  I'd consider putting the master copy of
the db on a server.  Have it copied to the person's computer when they
login to the network.  They can edit/mess up the data all they want,
but next time they log in, they'll get a pristine copy from the server.
0
jwild1 (46)
3/17/2013 6:16:12 PM
Reply:

Similar Artilces:

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

Accessing linked tables in MS Access database using JDBC ODBC Bridge
Does anyone know if JDBC can access linked tables in a Microsoft Access? We have a Mictosoft Access database that contains linked tables that are physically on a network drive. On a windows machine, We set up a java servlet that uses JDBC to connect to a microsoft access database using a DSN name set up in the ODBC administrator. We are able to run a query using a table that is physically on the database but not on tables linked into the database. The linked tables are comng from another Microsoft Access database on a mapped network drive. The java servlet and the database containing the linked tables are on the same computer drive. > Does anyone know if JDBC can access linked tables in a Microsoft > Access? HXTT Access( http://www.hxtt.net/access.html ), a pure Java JDBC package, supports Linked Table and View of MS Access. Yonghong Zhao System Analyst www.hxtt.net ...

Accessing linked tables in MS Access database using JDBC ODBC Bridge #2
Does anyone know if JDBC can access linked tables in a Microsoft Access? We have a Mictosoft Access database that contains linked tables that are physically on a network drive. On a windows machine, We set up a java servlet that uses JDBC to connect to a microsoft access database using a DSN name set up in the ODBC administrator. We are able to run a query using a table that is physically on the database but not on tables linked into the database. The linked tables are comng from another Microsoft Access database on a mapped network drive. The java servlet and the database containing the linked tables are on the same computer drive. ...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

access to MS Access password-protected database?
Can anyone direct me towards a code snippet showing how to use Python to insert data into a password-protected MS Access database? My google searches have been uninformative for dbs that are password-protected. Thanks, Ken On Feb 11, 10:43=A0am, Ken McDonald <kmmcdon...@medicine.wisc.edu> wrote: > Can anyone direct me towards a code snippet showing how to use Python =A0 > to insert data into a password-protected MS Access database? My google = =A0 > searches have been uninformative for dbs that are password-protected. > > Thanks, > Ken You post is a little vague...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net////...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a d...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

MS Access VBA making multiple tables in database from a main table.
I have a database table called "tbl_personal" and struggling to VBA program a bit of code to create multiple tables in a database from the main "tbl_personal" table. In this case the 'color' column is the field I would like to look at. 1. Identify the number of unique records in column 'color' 2. For each color record that is label as red in the "tbl_personal" table, create a table called 'red' and populate with all red records in from the "tbl_personal" table. 3.Then move onto the next unique color and repeat the whole process...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Excel database query does not work after securing an Access database
Hi all, I'd appreciate if someone could give me a hint to this little annoying problem: I have a simple database that I want to be able to query from Excel. When I use the "new database query" wizard on an unsecured version of my database, everything works fine. I am able to read the tables and queries, I can build customized queries in Excel from the Access tables/queries. Now, the moment I secure my database I loose all connectiviity between Excel and Access. The wizard won't even connect to the database. When I add permission to "open/read database" object thr...

Identifying Access Databases with tables linked from other Databases/Files
Hi, Have a number of Access Databases that I inherited and want to zip a few of them. My concern is that other active Microsoft Applications may be linking to the database or its tables. Is there a method of searching that will allow me to identify those MS Access files that are linked to. I am not really concerned with itemizing the which files link to which, but just that a link exists. Thanks in advance for any help. Bill It is easy to find the files which it links to but I don't know of any way to find the files which link to it. If you want to find the ones it links to look ...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Sin...

access MS-Access database in C# Windows Application
Hi, I am trying to access the MS Access database on my local machine in C# Windows Application in Visual Studio.NET. But it seems that it does not work. I use the Microsoft Application Blocks to access the database. I have tried 2 possible connection strings. ----------------------------------------- str_1 = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + DBFilePath; str_2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBFilePath; //SqlHelper is the class in the Microsoft Application Blocks SqlHelper.ExecuteNonQuery( str_1, CommandType.Text, SQL_str); --------...

Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check here to see if there is a better way. Any suggestions? Thanks Do you mean remotely controlling an Access database, or linking tables over the internet? The first is doable, the second is a recipe for disaster. Remote Control: If your remote OS is Windows XP, you can use Remote Desktop (although only 1 person can access the PC at a time; this will change in the upcoming Service Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers similar services, as does Terminal Server (a component of a Windows Server machine), PCAnywhere, et al. Linking to remote tables: You will almost certainly encounter severe problems with corruption, and your performance will almost certainly be so poor as to be unworkable. I attempted this once, with a web server in Canada and my machine in Augusta, GA. Even tiny data requests on a very well optimized data structure took waaaay too long to process ... it's simply not workable, IMO. Other alternatives would be covert the app to a web-based and place your data on a web server. Access/Jet isn't really designed for those workloads, but running a small site with minimal transactions and users can be done. Otherwsie, consider switching to a more robust data platform like MySQL, SQL Server, etc. -- Scott McDaniel CS Computer Software Visual Bas...

Redhat Apache to access MS-Access Database through PHP
Hi, I am wondering if anyone knows how to make this work. I have Redhat Liux ES v2.1 Server Apache 1.3 PHP 4.0 a MS-Access MDB file (just the file, already created) The MS-Access file is already in the Redhat Linux server. Is there a way I can make Apache & PHP to access this MS-Access MDB file? Thank you. ...

To enter and access database of MS access or any DBMS usibg C.
hello people, Can any body give me the code or the basic logic to enter and also access data from a Database management system using C?...also tell me the actuall syntax to run an .exe file using C along with the headers to be included.I want to do it in Windows environment only....using turboC In article <1134648270.423831.13110@g14g2000cwa.googlegroups.com>, Sree <gisripa@gmail.com> wrote: >hello people, > Can any body give me the code or the basic logic to >enter and also access data from a Database management system using >C?.....

Accessing a passworded MS Access 2000 database in Crystal Reports
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

multiple users' simultaneous access to a MS Access database
When my end user clicks on the icon for her MS Access database (the icon is on her Novell NAL menu) she is successful in opening the database. However, when another staff member is using the database she receives the message that someone is using it and she cannot access it at that time. Any suggestions as to what I need to do to resolve this? I guess it would be a fix to allow multiple users simultaneous access to a MS Access database? Thanks in advance, Zuf Per zufie: >When my end user clicks on the icon for her MS Access database (the >icon is on her Novell NAL menu...

HXTT Access v1.0 Released for MS Access database
HXTT Access provides a type 4 JDBC driver for Table, System Table, View(Query), and Linked Table of Microsoft Access (MS Access) version from 2.0, 95, 97, 2000, XP, 2002, to 2003. It supports JDBC1.2, JDBC2.0, and JDBC3.0. It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X and JDK1.5.X. It supports JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, and DbEdit Database Utilites for Eclipse Platform. It supports transaction, XOPEN SQLState, RMI, Jini, JNDI, and serialization. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. The current version of the HXTT Access packages are available at http://www.hxtt.net/en/software/download.jsp?product=Access . ...

How to reset or disconnect all conections to an MS Access database if the database is hung up?
Hi, All: &nbsp; Sometime I do not knwo why my database in local C drive is locked. If I restart the LabVIEW software, it works fine. Is there a way to disconnect all connections before you make a new connection? I remember I used this function a couple of years ago but I could not find the function in new LabVIEW database connectivity tool kit. I am using LabVIEW 8.0.1. Thanks. &nbsp; Jim Is it DB Close Connection? You VI should contain one of these. <img src="http://forums.ni.com/attachments/ni/170/194552/1/DB%20Close%20Connection.jpg"> DavidMessage Edited by David C...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

accessing MS Access database fila via ODBC problem
Hi! I'm trying to connect to a MDB file via ODBC like this: char *DSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\dev-cpp\\test\\1.mdb"; SQLAllocEnv(&env); SQLAllocConnect(env, &hdbc); SQLBrowseConnect(hdbc, (UCHAR*)DSN, strlen(DSN), (UCHAR*)buf, BUF_SIZE, (SQLSMALLINT*)&rcvlen); The function SQLBrowseConnect fails and SQLGetDiagRec returns "IM001 Driver does not support this function" Can anyone help me? Thanks! David On S...

Connect to Security DataBase (MS Access 2000)
Hello, How can i make a connection to MS Access DB ( Security DB )? I make a new workgroupinformationfile (mdw file ), a new MS Access DB that can working with the workgroupfile. Now, i want make a connection with VBA code + DAO 3.6 from a MS Excell VBA project? How can i do that? On Sun, 8 Feb 2004 16:59:23 +0100, "Gilbert Van Hauwe" <Gilbert.VanHauwe@pi.be> wrote: Check this out: http://www.connectionstrings.com/ -Tom. >Hello, > >How can i make a connection to MS Access DB ( Security DB )? >I make a new workgroupinformationfile (mdw file ), a new MS Acc...

Web resources about - Access database table security - read only - comp.databases.ms-access

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Open source database improves protection and performance
Most enterprises rely on databases in some form or another, but they can be vulnerable to attack from people looking to steal information. They ...

NTTC's Liquid Products Database making steady progress
NTTC's Liquid Products Database making steady progress Modern Bulk Transporter NTTC is asking carriers to suggest “proprietary blends” for ...

TransGrid Switches Oracle Database Support to Rimini Street
TransGrid Switches Oracle Database Support to Rimini Street

Herbalife sinks on database error report
Herbalife said it had overstated growth in the number of "active new members" in some instances in the past three quarters due to database errors. ...

Microsoft's SQL database software now runs on Linux
Remember when Steve Ballmer likened Linux to cancer, and the notion of Microsoft courting the open source crowd was virtually unimaginable? The ...

Microsoft's SQL Server Database Is Heading to Linux
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.

How Postgres and Open Source Are Disrupting The Market for Database Management Systems
Open source database management systems (OSDBMSs) have matured into viable alternatives to proprietary, commercial solutions. It comes as no ...

Resources last updated: 3/10/2016 7:37:57 AM