Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 15th, 2010, 08:24 PM
Authorized User
 
Join Date: Nov 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

awesome...
your name proceeds you sir.....Thnx for sharing your valuable information with me...

cheers :)
 
Old November 15th, 2010, 09:15 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

You're welcome.

Glad I could assist.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
 
Old September 8th, 2011, 03:33 PM
Registered User
 
Join Date: Dec 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to ttitto
Default not a valid password

I have a slightly different question. I had a database that I split. Then I added passwords through exclusive access to the back end databases. When I tried to work normally with the front end database I had an error 3031 "Not a valid password". I found some solutions, that I am not sure how exactly I can implement in my case. The solutions were with connection string. I do not know which connection string to use and where should I write the connection string. Any help will be highly appreciated?
The database will be used in an network with windows XP and access 2010 from different computers. But before it is completely ready it will be develloped on a single computer with windows 7 and access 2010. i do not know if this information is usefull.
 
Old September 8th, 2011, 09:08 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

In the futior please do not hijack an old thread. Please start a new post.

Quote:
Originally Posted by ttitto View Post
I have a slightly different question. I had a database that I split. Then I added passwords through exclusive access to the back end databases. When I tried to work normally with the front end database I had an error 3031 "Not a valid password". I found some solutions, that I am not sure how exactly I can implement in my case. The solutions were with connection string. I do not know which connection string to use and where should I write the connection string. Any help will be highly appreciated?
If you add a password to a back end then you will have to delete all the linked tables and recreate them.


Quote:
Originally Posted by ttitto View Post
The database will be used in an network with windows XP and access 2010 from different computers. But before it is completely ready it will be develloped on a single computer with windows 7 and access 2010. i do not know if this information is usefull.
I do not believe that you can properly develop a multi user (split) database on a single computer. You must place the back end on a different computer/share. You also need to load test the back end.

There is just now way to properly test a multi user database that is not split or if the back end is on the same machine.

By developing and testing in an environment that closely matches the production environment then you will have a lot let things to redesign once in the production.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Last edited by HiTechCoach; September 8th, 2011 at 09:13 PM..
 
Old December 10th, 2012, 07:23 AM
Registered User
 
Join Date: Dec 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question User Permitions

Hi, I have trouble managing the permitions. When i click on the icon, it says "Property not found" how do i overcome this?





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 04: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 05:17 AM
user does not have permission (error 15247) hertendreef SQL Server 2005 1 April 1st, 2007 02:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.