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
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).
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
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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:
...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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
|
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...
|
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...
| |