473,322 Members | 1,714 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.

Report will only open in design view

I am using Access 2003 at work and had created a summary report showing the financial information for year to date. As of last week the report ran great. Today I was asked to make a change in the report and to show the percentage now with 2 decimal points. I made the change and now I can't get the report to open. It will only open in design view. The error message I get states to exclusive rights to the database. I have checked in the query and nothing has really changed. This database is linked to Sharepoint.

I can see all the information for the report in the query but when I try to run the report it won't let me open the report up. I can get the report to run for just one client at a time but not for all the clients and I was able to run a report with all clients just last week. I can get the percentage to work fine with the 2 decimal points. So not sure what is causing the problem. I have also tried creating another database with the same information and it still won't let me open the report up using the same information.

Also I should mention that my boss unknowingly showed another dept head the calculation formula used in share point to get this percentage rate. The database is linked to share point if that helps with the answer. The fear is that this dept head has done something or had someone else create another database and has now locked me out of the database to run this specific report. If anyone can help I will greatly appreciate it.
Oct 13 '08 #1
1 2063
NeoPa
32,556 Expert Mod 16PB
I'm sorry. I can't see anything in what you've told us that might explain the change in behaviour.

Have you tried reverting to the earlier version in order to determine whether the change is in any way related to the new behaviour?
Oct 14 '08 #2

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

Similar topics

1
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
3
by: manning_news | last post by:
Using A2K. I've been asked to modify a report currently requiring only one date parameter to now accept a date range. The main report has 2 subreports and is not bound to a table or query. The...
1
by: Randy | last post by:
I built and employment report from the employment table. I then had to add a field to the table. I now need to add that field to the report. I can't seem to be able to do that by clicking on...
6
by: thomas.jacobs | last post by:
I have reports formated and now need to use that format on another table name with the same field names as formated in the report. I belive it is in the properties but I can't seem to find it....
3
by: Regnab | last post by:
I've made an access report which shows the number of people in 5 activities. As you can imagine, it only takes up about a quater of the page. I have to give a copy of this report to two people, and...
6
by: Salad | last post by:
Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
1
by: Tudor | last post by:
Hi All. I'm new to this forum (as a registree) although I do come by here to find answers which I do always find. I thought I'd post a question and see if anyone can help! I'm developing a DB in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.