Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-05-2018, 08:49 AM   #1
TraceSL
Newly Registered User
 
Join Date: Sep 2017
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
TraceSL is on a distinguished road
Read only ACCDB and writing to linked tables

Hello
I wanted to lock down my code base in the ACCDB access database but I need the user to be able to hit the linked tables however when I change the ACCDB to ready only the "import" functions are disabled.

What is the recommended practice to lock down the front end code base while maintaining functionality to hit and process data in the linked tables.
All suggestions appreciated. Tracy

TraceSL is offline   Reply With Quote
Old 12-05-2018, 09:20 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,439
Thanks: 92
Thanked 1,831 Times in 1,701 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Read only ACCDB and writing to linked tables

Quote:
hit the linked tables
Quote:
lock down the front end code base while maintaining functionality to hit and process data in the linked tables.
Sorry but could you explain that again...

If you want your code to be compiled and so not available for end users, convert the FE into an ACCDE file
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
TraceSL (12-05-2018)
Old 12-07-2018, 01:53 PM   #3
TraceSL
Newly Registered User
 
Join Date: Sep 2017
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
TraceSL is on a distinguished road
Re: Read only ACCDB and writing to linked tables

Hello:
I forgot about this option for ACCDE I use to use MDE's back in the day. However this option does not protect changes to queries or tables.
Is there way to lock down these items as well?
Thanks for the help. Tracy

TraceSL is offline   Reply With Quote
Old 12-07-2018, 02:16 PM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,439
Thanks: 92
Thanked 1,831 Times in 1,701 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Read only ACCDB and writing to linked tables

Its not clear to me whether you mean protect the design or the data from being changed

As the tables are in the BE, users will not be able to change their design.

In the FE, do not allow end users an direct access to tables or queries. All interaction should only be via forms and reports.
So hide the navigation pane and possibly the ribbon, disable Access special keys including the shift bypass and disable full menus.
You can also remove Access options from the file menu so users can't just switch everything back on.
There's more you can do but that may be more than enough for your needs.

If you meant prevent users changing data, restrict access to most forms so the data is locked. At the most extreme, you could make your database read only....but is that what you actually meant?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 12-10-2018, 07:32 AM   #5
TraceSL
Newly Registered User
 
Join Date: Sep 2017
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
TraceSL is on a distinguished road
Re: Read only ACCDB and writing to linked tables

My designs include access to temp tables and queries for manipulating data and pulling data from queries to excel. I'll have to work on some redesign. I do use some of the items you noted remove full menu and other abilities. read only is not an option since the user not able to modify the data when needed. I need to work on my designs more. My fulltime work is accounting I do the development on side but trying to make more time for improved designs. Thank you, Tracy


Quote:
Originally Posted by isladogs View Post
Its not clear to me whether you mean protect the design or the data from being changed

As the tables are in the BE, users will not be able to change their design.

In the FE, do not allow end users an direct access to tables or queries. All interaction should only be via forms and reports.
So hide the navigation pane and possibly the ribbon, disable Access special keys including the shift bypass and disable full menus.
You can also remove Access options from the file menu so users can't just switch everything back on.
There's more you can do but that may be more than enough for your needs.

If you meant prevent users changing data, restrict access to most forms so the data is locked. At the most extreme, you could make your database read only....but is that what you actually meant?
TraceSL is offline   Reply With Quote
Old 12-10-2018, 07:44 AM   #6
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,439
Thanks: 92
Thanked 1,831 Times in 1,701 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Read only ACCDB and writing to linked tables

OK. Good luck
Come back to us when you have specific questions about your design

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Tables read-only bizarre@telenet.be General 2 10-12-2015 03:35 AM
Read/only problem with linked MySQL tables mihabaki General 5 04-17-2009 02:50 AM
Linked SQL Server tables become read-only ErikSnoek Modules & VBA 3 02-20-2008 03:41 PM
Linked Tables Across Network Are Read Only Tsango General 5 05-23-2006 01:27 AM
Linked tables - can they be read only? yippie_ky_yay Tables 3 01-08-2004 07:13 PM




All times are GMT -8. The time now is 11:22 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World