I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.
When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.
When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):
Private Sub Command171_Clic k()
On Error GoTo Err_Command171_ Click
Dim strReportName As String
Dim strFilter As String
Me.Refresh
strReportName = "rptEstimat e"
strFilter = "EstimateID = Forms!frmestima te!EstimateID"
DoCmd.OpenRepor t strReportName, acViewPreview, , strFilter
Exit_Command171 _Click:
Exit Sub
Err_Command171_ Click:
MsgBox Err.Description
Resume Exit_Command171 _Click
End Sub
A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.
Any thoughts?
Thanks
Edward 1 1593
I like how you put upgraded in quotes... :)
I wonder if they're not responding to the security message that's disabling
all macors, etc.? Do you know if they added the folder as a trusted
location?
<te********@hot mail.comwrote in message
news:da******** *************** ***********@b1g 2000hsg.googleg roups.com...
>I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.
When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.
When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):
Private Sub Command171_Clic k()
On Error GoTo Err_Command171_ Click
Dim strReportName As String
Dim strFilter As String
Me.Refresh
strReportName = "rptEstimat e"
strFilter = "EstimateID = Forms!frmestima te!EstimateID"
DoCmd.OpenRepor t strReportName, acViewPreview, , strFilter
Exit_Command171 _Click:
Exit Sub
Err_Command171_ Click:
MsgBox Err.Description
Resume Exit_Command171 _Click
End Sub
A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.
Any thoughts?
Thanks
Edward
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Allen Browne |
last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new
article at:
http://allenbrowne.com/Access2007.html
Covers what's good (useful features), what's mixed (good and bad), what's
gone (features removed), what's fixed (old issues solved), what's broken
(new bugs), configuration, compatibility, should you buy, and links.
It is opinion, so you may disagree, but hopefully it's an informative
summary.
|
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...
|
by: Paul H |
last post by:
Why the heck was this dropped? All my dbs use ULS even the complex ones. It
aint perfect, it's too fiddly, but it works.
How will I be able to say "These users can run these reports and these users
can't." in Access 2007? Will I have to create my own tables
(tblSecurityGroups, tblSecurityUsers) and code the whole thing?
Thanks,
Paul
|
by: Ntl News Group |
last post by:
Is it possible to run Access 97 on Windows Vista? I have installed
Access 97 and Access 2000, when I run Access 2000, then try to open
Access 97 it says it cant find the windows registry entries?
Re-Installing Access 97 seems to fix it until I open Access 2000 again.
I have run both Access 97 and Access 2000 on all previous versions of
windows without any problems.
Any suggestions would be appreciated.
|
by: ARC |
last post by:
Hello All,
I have a major application for quoting and invoicing that is written in
Access 97 (both front and back ends). I have a user base of over 300
customers, and currently I don't require that they have Access 97, as I use
the access 97 runtime scripts from Sagekey software. The main problems I've
seen with Access 97 are the built in e-mail support for sending reports.
Unless a user uses the MS Outlook 2000/XP method, they have to...
| |
by: evancater |
last post by:
My client wants to make their Access 2007 database available to
offices around the country with multi-user permissions set to control
access to the tables and forms, etc. The easiest thing would be a
client/server app, but they are concerned that accessing the backend
on their VPN would be too slow.
We've discussed the possibility of publishing the forms to the
intranet with ASP, but I'm concerned that web development with Access
is a...
|
by: Peter |
last post by:
Hi,
i've got an older Access program, which is written in the version 2000
and i'd like to use it with my new office 2007, so access 2007.
In the program, there is an replication written with the Jet Replica
Library, and i read on a microsoft site, that replications in jet
schould still work in access 2007, if you still use the old
extension .mdb
|
by: Kiers |
last post by:
Hi,
I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated
TIA
Kiers
|
by: Don |
last post by:
I've continued to use Access 97 all these years because (1) it does
everything I need quickly and (2) most of what I've read online
indicates that it's still the most bug-free version of Access. But
now that Vista is gradually becoming the only Windows choice and Vista
doesn't exactly "cooperate" with Access 97, I'm afraid it may be time
to take the leap.
I haven't had any experience with later versions of Access so I'm
seeking...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
| |
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |