473,394 Members | 1,845 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Access 2002 cannot view code...

sea
I have a database in Access 2002 but I am unable to view code or write
any modules when logged in with a limited user account using Windows
XP, service pack 2 -- no problems when logging in as administrator, --
any ideas on how a limited user on Windows XP can access code and
modules in Access 2002? Thank you very much.
Nov 13 '05 #1
4 1836
Are we talking Windows logins here? (when you restart the PC)
Or Access security? (when you start Access)

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I have a database in Access 2002 but I am unable to view code or write
any modules when logged in with a limited user account using Windows
XP, service pack 2 -- no problems when logging in as administrator, --
any ideas on how a limited user on Windows XP can access code and
modules in Access 2002? Thank you very much.

Nov 13 '05 #2
sea
Yes, Windows login, if logging in using Windows administrative access
all works fine, otherwise cannot access code...

"MacDermott" <ma********@nospam.com> wrote in message news:<51****************@newsread2.news.atl.earthl ink.net>...
Are we talking Windows logins here? (when you restart the PC)
Or Access security? (when you start Access)

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I have a database in Access 2002 but I am unable to view code or write
any modules when logged in with a limited user account using Windows
XP, service pack 2 -- no problems when logging in as administrator, --
any ideas on how a limited user on Windows XP can access code and
modules in Access 2002? Thank you very much.

Nov 13 '05 #3
I'm no expert on SP2, so there may be more than I'm seeing here.
I have heard that it tends to tighten security down "too far" in some
cases.

One of the main problems with file permissions for Access is that in order
to share an Access database, you must have read, write, create and delete
permissions on the folder where the database resides.
I've not heard of that producing the problems you're reporting, but it's a
place to start.

My guess is that you'll have to work with your network administrator to sort
this one out...

- Turtle

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
Yes, Windows login, if logging in using Windows administrative access
all works fine, otherwise cannot access code...

"MacDermott" <ma********@nospam.com> wrote in message

news:<51****************@newsread2.news.atl.earthl ink.net>...
Are we talking Windows logins here? (when you restart the PC)
Or Access security? (when you start Access)

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
I have a database in Access 2002 but I am unable to view code or write
any modules when logged in with a limited user account using Windows
XP, service pack 2 -- no problems when logging in as administrator, --
any ideas on how a limited user on Windows XP can access code and
modules in Access 2002? Thank you very much.

Nov 13 '05 #4
sea
Thank you very much, -- I followed your advice in your first reply and
checked the user and group features. This is Windows XP professional
and my login was listed simply as an "user". I changed this to "power
users" and now all is ok. Now I don't have to be logged in with
Windows Administrative access inorder to be able to edit code, problem
solved! Thank you again for helping.


"MacDermott" <ma********@nospam.com> wrote in message news:<8x****************@newsread3.news.atl.earthl ink.net>...
I'm no expert on SP2, so there may be more than I'm seeing here.
I have heard that it tends to tighten security down "too far" in some
cases.

One of the main problems with file permissions for Access is that in order
to share an Access database, you must have read, write, create and delete
permissions on the folder where the database resides.
I've not heard of that producing the problems you're reporting, but it's a
place to start.

My guess is that you'll have to work with your network administrator to sort
this one out...

- Turtle

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
Yes, Windows login, if logging in using Windows administrative access
all works fine, otherwise cannot access code...

"MacDermott" <ma********@nospam.com> wrote in message

news:<51****************@newsread2.news.atl.earthl ink.net>...
Are we talking Windows logins here? (when you restart the PC)
Or Access security? (when you start Access)

"sea" <se*****@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...
> I have a database in Access 2002 but I am unable to view code or write
> any modules when logged in with a limited user account using Windows
> XP, service pack 2 -- no problems when logging in as administrator, --
> any ideas on how a limited user on Windows XP can access code and
> modules in Access 2002? Thank you very much.

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Mark | last post by:
hope you can help. I need to get my access db backend to sql. I have tried the upsizing wizard but the get message "overflow" and cannot get any further. I also use queries that reference two...
20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
28
by: deko | last post by:
After doing a lot of vba work, I've noticed the size of my mdb has grown, even though no data or objects have been added. I've read that the following procedure will remedy this and improve...
2
by: Bruce Dodds | last post by:
I will be doing an app for a nonprofit. It would be useful for them to have a good entry-level book on Access so that they don't have to pay someone to design all their queries and reports. I'm not...
5
by: mr_mach7 | last post by:
I have an Access database that needs to be compacted and repaired almost on a daily basis. It is the front end that needs to be fixed, so other users cannot get into it when the problem happens....
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
2
by: Frav | last post by:
The Reps team have been experiencing that Access 2002 unexpectedly quits while working and also lots of Corruption Failures and "Record lock can not update" messages since the upgrade from...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
0
by: Sebastian | last post by:
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.