By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Bug or Permissions problem in MS Access 2003?

P: 1
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
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,660
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
Expert Mod 10K+
P: 14,534
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

Post your reply

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