NotSoKlear
asked on
Access 2003 Database error 3207 when trying to export
Hi experts:
I am receiving an error all a sudden when I try to run a report from a front end GUI in Access 2003.
This just started happening, yesterday afternoon, and has been running with no issues until now.
The error is:
Error 3207: Cannot update Database or object is read only.
After backing up the database, I tried:
Researching on my own.... no luck
Compact/Repair
Assigning a different name to the file when attempting to export
Rebooting the server and the workstation
Disabling the A/V
Ensuring I am logged on as administrator
Please let me know if I can give any more information. Thanks for help in advance.
Bob
I am receiving an error all a sudden when I try to run a report from a front end GUI in Access 2003.
This just started happening, yesterday afternoon, and has been running with no issues until now.
The error is:
Error 3207: Cannot update Database or object is read only.
After backing up the database, I tried:
Researching on my own.... no luck
Compact/Repair
Assigning a different name to the file when attempting to export
Rebooting the server and the workstation
Disabling the A/V
Ensuring I am logged on as administrator
Please let me know if I can give any more information. Thanks for help in advance.
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solution:
Database is corrupt, but there was a user field that needed to be filled on the report, so, the resolution was to place an export location into the user field and export.
In other words,
When clicking on 'export' items (on the gui)
There are four places a user needs to enter data
The first, the location of where the exported files are going to need to go
The second, the names of the (in this case) three files.
One of those user fields was blank - so I got the error because Access couldnt complete the function because it is a required field.
Hope that makes sense.
-Bob
Database is corrupt, but there was a user field that needed to be filled on the report, so, the resolution was to place an export location into the user field and export.
In other words,
When clicking on 'export' items (on the gui)
There are four places a user needs to enter data
The first, the location of where the exported files are going to need to go
The second, the names of the (in this case) three files.
One of those user fields was blank - so I got the error because Access couldnt complete the function because it is a required field.
Hope that makes sense.
-Bob
Any chance the file permissions on the folder that the mdb file is in might have changed, to Read Only? How about the file properties. Check to make sure that it is not setup as read-only.