473,322 Members | 1,401 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,322 software developers and data experts.

Bug or Permissions problem in MS Access 2003?

Dear All,
Yesterday, one of my students had a problem using MS Access 2003. Whilst editing a report in design view, using the Sorting and Grouping option, if they changed the Group Footer option to Yes, it locked out all the other options, which simply did not respond when clicked on. If the same person open the same database in MS Access 2000, on the same machine, it allowed the changes straight away. On then opening the same file back in Access 2003, it worked fully allowing changes to be made.

We have also had another problem on Access 2003, when a student created a table, and then saves and closes it (not Access complelety) and then trys to reopen it, they get the message that the Table is locked and can only be opened as Read Only. Essenialty they have to make changes and save it under a different name each time.

We use Windows XP Pro, and all students have Power User status.

Any help and ideas are greatly appreciated!
All the best,
Alex Gwinn
Worcester College of Technology
Nov 22 '06 #1
2 2948
NeoPa
32,556 Expert Mod 16PB
Access is prone to glitches and crashes which often don't reproduce when repeated.
Your first problem sounds like one of them.

With your second problem, I don't really know the answer, but try looking at the Open Mode and Locking options on the Advanced tab of Options (from Tools menu).
Nov 22 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
At a guess, from what you've said, I would say they are opening applications designed in 2000 in a 2003 version without fully converting them.

The problem is that although Access will allow you to do this it will lock certain things to read only.

Solution: Have two versions, one in 2000 and one fully converted to 2003 and recompiled. This should stop these problems. They can always convert back to a previous version if they want to use that.

Mary

Dear All,
Yesterday, one of my students had a problem using MS Access 2003. Whilst editing a report in design view, using the Sorting and Grouping option, if they changed the Group Footer option to Yes, it locked out all the other options, which simply did not respond when clicked on. If the same person open the same database in MS Access 2000, on the same machine, it allowed the changes straight away. On then opening the same file back in Access 2003, it worked fully allowing changes to be made.

We have also had another problem on Access 2003, when a student created a table, and then saves and closes it (not Access complelety) and then trys to reopen it, they get the message that the Table is locked and can only be opened as Read Only. Essenialty they have to make changes and save it under a different name each time.

We use Windows XP Pro, and all students have Power User status.

Any help and ideas are greatly appreciated!
All the best,
Alex Gwinn
Worcester College of Technology
Nov 22 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Howard | last post by:
Hello all. On a file or folder object in Windows 2000/2003, it is possible to edit the standard Change, RW etc permissions and give "special" permissions. These special permissions do things...
0
by: Fran Tirimo | last post by:
I am developing a small website using ASP scripts to format data retrieved from an Access database. It will run on a Windows 2003 server supporting FrontPage extensions 2002 hosted by the company...
2
by: Fran Tirimo | last post by:
I am developing a small website using ASP scripts to format data retrieved from an Access database. It will run on a Windows 2003 server supporting FrontPage extensions 2002 hosted by the company...
1
by: fripper | last post by:
I have just installed Visual Studio .Net Academic 2003 and MSDN Academic 2003. In testing a program that I had written in the 2002 version I find that when I use fileopen to access a file I get: ...
1
by: NB | last post by:
Hi This has been tickling my mind for quite some time. Can someone tell me if Access 2003 has a solution for it. After a period of development, your front end will definitely bloat despite...
2
by: Brian Cooper | last post by:
I am trying to determine a permission problem trying to write a text file from one web server to another. Here is the situation: We have two domains in place one is Active Directory and the...
5
by: JR | last post by:
Here's the scenerio: HAD: Entire Windows 2000 domain multiple servers Internal Web Server - Windows 2000 NAS Server - Windows 2000 Internal Web Application (On Web server) utilizing .ASP...
0
by: JR | last post by:
Here's the scenerio: HAD: Entire Windows 2000 domain multiple servers Internal Web Server - Windows 2000 NAS Server - Windows 2000 Internal Web Application (On Web server) utilizing .ASP...
2
by: Fox1977 | last post by:
Hi folks, Just wondering if anyone can help me out with this problem I'm having getting a particular .net web application to run on a windows 2003 r2 x64 platform running as a domain account. ...
3
by: palepimp | last post by:
Hello all, I have searched far and wide for a solution to my issue. In short, here is the problem: 1. 3 PC's enter data into an Access 2003 database (PC's are running Vista w/ Office 2007...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.