Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 11th, 2010, 11:40 PM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default user permission in access 2010??

hi again...

i am trying to set a user premission in access 2010 so the user cant mess with my design, just edit the data.... but i cant find that option... all i find is encrypt data base which it will set the whole database with a password...and i dont want it


any help please!!
Reply With Quote
  #2 (permalink)  
Old November 12th, 2010, 12:27 AM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

First you will need to split your databases into an application (front end) and data (back end).

See: Splitting your Access database into application and data

You can then compile the frond end in the a .ACCDE. To lock it down even more you can rename the file from a .ACCDE to a .ACCDR
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
  #3 (permalink)  
Old November 12th, 2010, 01:12 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by HiTechCoach View Post
First you will need to split your databases into an application (front end) and data (back end).

See: Splitting your Access database into application and data

You can then compile the frond end in the a .ACCDE. To lock it down even more you can rename the file from a .ACCDE to a .ACCDR
nice...
but i got question...
how do i retrieve the database from .ACCDE?
if i want to add more features and the client doesn't want to retype the data all over again....
how do i open his database from .ACCDE and edit it??
Reply With Quote
  #4 (permalink)  
Old November 12th, 2010, 01:33 AM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
how do i retrieve the database from .ACCDE?
There should not be any need to do that.

You do not edit the ACCDE. You compile the "master application " ACCDB into a new ACCDE. The data is all in the back end.

The data is store in the back end. The application or front end hold not data only the application objects. The front end is linked to back end.


I would suggest that you read the article I linked to plus all the other links at the bottom of that article. Then I would make a copy of your database and then split it. Do some experimenting on the copy that you split. Hopefully then things will start to make a whole to more sense.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
  #5 (permalink)  
Old November 12th, 2010, 09:01 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hmmm
looks good but i read one of the ms office disadvantages

Microsoft Access MDE/ADE/ACCDE files
Databases that have had their source code removed (such as .mde, .ade, and .accde files) cannot be moved between 32-bit and 64-bit editions of Office 2010. Such databases that are created by using 32-bit Office (any version) can be used only with 32-bit Office, and a database that is created on 64-bit Office can be used only on 64-bit Office.

so what if my client has x64 office.... the .ACCDE .ACCDR. WONT WORK....

any suggestions?
Reply With Quote
  #6 (permalink)  
Old November 12th, 2010, 09:31 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

as for the ACCDE and ACCDB has to be togther in user pc which has no network connection between me and him???
if thats true then if i want to make any new change in ACCDB i have to get it from his hard drive?

help plz
Reply With Quote
  #7 (permalink)  
Old November 12th, 2010, 12:49 PM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by DivX View Post
hmmm
looks good but i read one of the ms office disadvantages

Microsoft Access MDE/ADE/ACCDE files
Databases that have had their source code removed (such as .mde, .ade, and .accde files) cannot be moved between 32-bit and 64-bit editions of Office 2010. Such databases that are created by using 32-bit Office (any version) can be used only with 32-bit Office, and a database that is created on 64-bit Office can be used only on 64-bit Office.

so what if my client has x64 office.... the .ACCDE .ACCDR. WONT WORK....

any suggestions?
The 64 bit version of Office is still really buggy and has lots of issues. At this time I will not support any clients that use the 64 bit versions.

I also thing of the 64 bit version just like having another version of Office. I have all the version of Office installed that I support. I create an MDE/ACCDE in every version of Access so that I can hmtach the version of Access installed.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
  #8 (permalink)  
Old November 12th, 2010, 01:01 PM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by DivX View Post
as for the ACCDE and ACCDB has to be togther in user pc which has no network connection between me and him???
if thats true then if i want to make any new change in ACCDB i have to get it from his hard drive?

help plz
When you deploy a database, not just Access, you will have to create an update app that you send to the remote location that does the database updates. I have formation about this in the first link I gave you.

This is a common problem with deployed database applications. Even software like Quicken and Quickbooks have to deal with this issue.

IMHO, If the database is properly designed and normalized from the start you should not need to make many changes to the tables.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
  #9 (permalink)  
Old November 13th, 2010, 06:23 PM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

need to practice this.....

thnx for the info..... your name is David ... right?
Reply With Quote
  #10 (permalink)  
Old November 14th, 2010, 04:40 PM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

My name is actually Boyd. I am also known as HiTechCoach on many Access support sites. My site can be found http://www.hitechcoach.com
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Access 2010 and Access Services with SP 2010 kmaford BOOK: Professional SharePoint 2010 Development 0 September 14th, 2010 05:25 PM
Visual Studio 2010 in Focus at Great Indian Developer Summit 2010 shaguf5575 ASP.NET 1.x and 2.0 Application Design 0 February 24th, 2010 07:03 AM
Visual Studio 2010 in Focus at Great Indian Developer Summit 2010 shaguf5575 ASP.NET 1.x and 2.0 Application Design 0 February 24th, 2010 07:02 AM
How to change user permission in SharePoint 2007. somesh_bhalerao C# 0 October 5th, 2007 06:17 AM
user does not have permission (error 15247) hertendreef SQL Server 2005 1 April 1st, 2007 03:23 PM



All times are GMT -4. The time now is 11:32 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.