Access Denied problem.

[Perry]

I have developed an appliccation using Access 2003 on my notebook and it was
running fine. I installed a trial version of Access 2007 and the app was
running fine too on my notebook. Access 2007 is new to me. Now we're going to
the second phase of letting users try it. Users could not open the main form
of the database, getting "Access denied" "xxxx you are not allowed to access
this application" message. I checked the "Users and Permissions" settings in
Access 2007 and they looked identical on both machines. I tried a few things
and it did not help. Google did not review any hits. I am lost and need help.

Thanks.

 

[golfinray]

Have you split the database? If not, that is the next thing you need to do.

 

[Stefan Hoffmann]

hi Perry,

Users could not open the main form
of the database, getting "Access denied" "xxxx you are not allowed to access
this application" message.

The "Access denied" sound like file system permission (NTFS) problem.
Does the user has the appropriate permissions on the folder where the
database file resides? These include read, write, delete file and create
file.

The other error message may be the same. Does only one user testing it
or do you have multiple users? In the last case Milton is right: You
need to split your application into a front-end for each single user and
back-end:

http://allenbrowne.com/ser-01.html
http://support.microsoft.com/kb/304932



mfG
--> stefan <--

 

[Perry]

Thank you. Can you explain to me why that will fix my problem?

 

[Perry]

The user has full NTFS access to the folder. There will be a limited users
access to the appication. I am aware the DB eventually will be split and I
plan to do so later on. We are trying to get a server to hold the BE-DB. I
like to get this resolved first.

Thanks.

 

[a a r o n . k e m p f]

moving to Acess Data Projects will fix your problem

jet is too buggy for most people to use for more than a single record
or user

 

[golfinray]

When you split the database, you make an FE (front end) and BE (backend) and
you move your tables (data containers) into the BE. The BE is on your server.
The FE containing the queries, forms, and reports are on each user's machine.
This allows for multiple users to use the tables at one time as long as two
users are not actually in the same RECORD at the same time. Under
tools/options/advanced, set your default open mode to shared and default
record locking to none.

 

[Perry]

Sorry and Thank you ALL.

I implemented some security into the Apps and the message was from the
security routine. I did not realize until I webex into the user's computer.