[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

Ideas on how to allow accdb and accdr

I am building an application for a company where 1 person, who has some access knowledge, needs access to the full accdb version, or the accde, so that they can make changes to the database records as needed and such.  However all the other users will need to login and only have access to the application via the runtime mode.

I am having a hard to acheiving this, does anyone have som suggestions??
0
deanna2010
Asked:
deanna2010
2 Solutions
 
als315Commented:
It was discussed many times. Search for frontend-backend and frontend update. But are you wanted limit access to records or to db design? Runtime is not limiting access to records.
0
 
peter57rCommented:
I'm not clear what you are asking .

The use of the runtime or full version of Access controls whether users can change the design of the database or not.  It has nothing to do with whether they can enter or change data values.

And if you are using accdb format how are getting users to login anyway.  There is nothing built-in to Access to do that.?

0
 
Jeffrey CoachmanCommented:
In all three of your scenarios, all users will be able to add, view and edit records by default:
Accdb, accde, accdr.
So I am not sure why one user "needs" the accdb or accde file...?

Why not either let everyone use the Runtime, ...or everyone use an accde?
Keep It Simple...

Perhaps I am missing something though...

Can you explain the "Why" behind this?


JeffCoachman
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
deanna2010Author Commented:
The 'super user' needs to see the tables in datasheet view and make changes to the database that way if needed.  For everyone else I have created a log in page and they only need to see data and make changes in runtime mode, so all forms are in FormView and all Reports in ReportView.  I have navigational buttons to allow those users to move around the application.
What is tricky is that both users, the 'super user' and the regular users need access to the same database and data but the regular users are NOT allowed to see the database in design view at all.  

Does this clear things up?
0
 
peter57rCommented:
Have you split the database (as required for a multi-user application) .  If not then you must do that first.
Then you can set different startup settings for the superuser's copy to those you use for the regular users.
0
 
deanna2010Author Commented:
how do you split the database?? will this work if the database is being stored on a network drive, not a file server??  How do you set the different start up settings as well?  

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

Just to clarify a bit: only difference between a MBD and a MDE is that with a MDE all source code is stripped out.  That means you cannot make design changes to objects that rely on code even if you have the full version of Access or not.

The difference between the Full version and the 'runtime' version of Access is that in the runtime *all* design capabilities are disabled regard less of the DB format.  Even if it is a MDB, you still won't be able to do anything with objects.

HTH
JimD.

0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now