473,698 Members | 2,471 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access With MS Vista Reports Not Working

3 New Member
Hello, help please.
I have been pulling my hair out for a few weeks now and been looking on the web for answers but not managed to find anything!!

I'm currently operating a small (2mb - approx 4500 records) MS Access database on my new laptop that has MS Vista. I'm also using MS Office (with MS Access) 2003. I'm the only user on the laptop.

The database was design and still is in MS Access 2000 version because it needs to be used on another machine that only has MS Access 2000.

However on my laptop, the Access Reports functionality does not work. I cannot create any new ones, amend, open or delete any current ones. Even if I try and use the wizard functionality to create a new report it allows me to pick the table/query but then does nothing.

I have deleted and re-loaded MS Office (including Access). I (think) I have ensured the my MS Access profile is set as Administrator correctly.

I know the database is not corrupt because I can still use the report functionality on other machines that do not have MS Vista.

Many thanks in advance for help and advice.
Nov 8 '07 #1
4 2001
wvmitchell
42 New Member
It may be necessary to download and install updated printer drivers from the manufacturer's site.

There are two notable symptoms:

1) From the database window, you click the Reports tab, then click New; select a report type and click OK -- nothing happens.
2) From VBA code that uses DoCmd.OpenRepor t -- report does not open, but receive error 2501 Action Cancelled.

I had seen this happen when upgrading from Access 2000-2002 to 2003 on Windows XP, maybe Vista has the same problem.

Bill Mitchell
Nov 11 '07 #2
missinglinq
3,532 Recognized Expert Specialist
Have you tried to do anything else, design-wise, such as create a new form? A simple and often overlooked thing to do, when databases become non-modifiable, is to see if they're Read-only. Transferring the files from one machine to another by use of CDs often make the files Read-only, depending on the CD burning program. Go into Windows Explorer and check the file's Properties.

Welcome to Thecripts!

Linq ;0)>
Nov 11 '07 #3
PabsBath
3 New Member
It may be necessary to download and install updated printer drivers from the manufacturer's site.

There are two notable symptoms:

1) From the database window, you click the Reports tab, then click New; select a report type and click OK -- nothing happens.
2) From VBA code that uses DoCmd.OpenRepor t -- report does not open, but receive error 2501 Action Cancelled.

I had seen this happen when upgrading from Access 2000-2002 to 2003 on Windows XP, maybe Vista has the same problem.

Bill Mitchell
Bill
Many thanks for your advice. This is exactly the symptoms I have been getting. I better find out what my printer drivers are on my Acer laptop!
Once again thank you.
Regards
Paul
Nov 13 '07 #4
PabsBath
3 New Member
Have you tried to do anything else, design-wise, such as create a new form? A simple and often overlooked thing to do, when databases become non-modifiable, is to see if they're Read-only. Transferring the files from one machine to another by use of CDs often make the files Read-only, depending on the CD burning program. Go into Windows Explorer and check the file's Properties.

Welcome to Thecripts!

Linq ;0)>
Linq
Many thanks. I have been able to create new tables, queries and forms etc. It would appear that I have to install new print drivers. Oh the fun and joy of computers!
Regards
Paul
Nov 13 '07 #5

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

Similar topics

3
5152
by: Brad | last post by:
In a Vista/IIS7 asp.net app, a coded crystal report export is crashing IIS7....but it works just fine in visual studio's cassini web server. And if I create a web form and use the crystal reports web viewer, view the report and then export from the viewer it also works fine (IIS7 and cassini). And I should note this all works fine in IIS6 on win2003 or in xp. So my thought with all this is that something is going on with IIS7, so...
37
3733
by: Allen Browne | last post by:
If you develop for others, you probably have multiple versions of Access installed so you can edit and create MDEs for clients in different versions. This works fine under Windows XP, even with Access 2007 installed. It does *not* work under Windows Vista Ultimate. After running Access 2007, when you open an earlier version of Access, no code works, because the references are fouled up. And Access 97 does not work at all. Access should...
2
4422
by: Wayne | last post by:
Does anybody know why my Office 2003 apps including Access have taken on a blue theme when running under Windows Vista irrespective of which "Window Color and Appearance" I choose in Control Panel? It doesn't seem to matter if I'm running Aero or Vista Basic. Access 2000 is not affected and has the bog standard grey toolbars etc. Under XP the blue theme only appeared in Office apps if the blue XP theme was chosen. If another theme...
13
13246
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine company. They presently have about 4 networked computers, all running Windows XP (w/SP2) and Microsoft Office 2000 (specifically Access 2000) - and a plain jane p3 server also running Windows XP (w/sp2) with Office 2000 loaded onto it. These...
0
1290
by: tommaso.paxia | last post by:
hi guys, I have an application on .net framework 1.1 that uses crystal reports .net (version 9)... now I wanted to install it on windows vista... No way! First problem I can't install MSDE... ok I use sql express (even if I have to install framework 2.0 too)... secondo huge problem... Even if I added merge modules for CR.net and my deployment package is working on xp and 2000 when I try to open a report it says... "...
2
4404
by: Wayne | last post by:
I'm experiencing the following intermittent problem with Access 2003 (Access 2000 file format) under Vista. Sometimes when I close a database by closing the database window I get the following unhelpful generic message: "Microsoft Access has stopped working. A problem caused the program to stop working correctly. Please close the program. The problem sometimes occurs when doing a compact and repair also. One particular database gives...
10
4569
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the opportunity to test some new features of Access2007 before actually 'stepping over'. First thing that troubles me of course is 'the ribbon', but my question now is about speed. I opened one of my Access 2000-apps in Access 2007. Speed and...
2
2631
by: PW | last post by:
Hi, We have a new client who says he can not preview or print an Access 2003 report on his Vista machine. They print on his XP machine. He says the screen just flashes. Other users using Vista have no problem previewing or printing our reports. Any ideas?
0
2334
by: Mark Gold | last post by:
Hi! We have a VB application using Crystal Reports 6 that has worked successfully on hundreds of systems for over 10 years. Now, on one network, the application and access database does not close. It seems to hang on the command. When we open the application an peruse the screens without opening up a report (using crystal reports), the application and access db closes fine. But as soon as we run a report and then close the report and...
0
8683
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9170
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9031
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8871
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4371
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3052
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2336
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.