compatibility problem Win7

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Microsoft Access » Microsoft Access » compatibility problem Win7

28 posts, Page 1 of 3

1 2 3 »»»

compatibility problem Win7

Rate Topic

Display Mode

Topic Options

Author

Message

peter478

Posted Wednesday, May 23, 2012 12:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 7:31 AM
Points: 46, Visits: 174

Hello,

I have problem to run ms access application (.adp) under Win7
with MS office 2007.(or access runtime 2007)
Database is placed on SQL2000 server.

When I want to open some form, the same error message appier.
(see attachment)

Thank you.

Post Attachments

accessrt.jpg (49 views, 54.09 KB)

Post #1304710

robert.gerald.taylor

Posted Wednesday, May 23, 2012 6:19 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:31 AM
Points: 733, Visits: 781

Can you set a breakpoint in your OnLoad event and step through to see what line is causing problems?

Post #1304880

peter478

Posted Wednesday, May 23, 2012 11:33 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 7:31 AM
Points: 46, Visits: 174

Yes I have set up breakpoint, but I could not get to this point , always the first was mentioned error message. I dont have this problem with WinXP, everything works fine. I was testing the setting with SQL server2000, If the connection is okay, I got successfull response.

When I create completely new form, and set event procedure, then everything works fine.But I have a lot forms where is set event procedure.I dont use macro.

Post #1305530

WendellB

Posted Thursday, May 24, 2012 4:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:46 AM
Points: 106, Visits: 405

Exactly what do you have in the expression for the OnLoad event on the form? The error message you are getting indicates that it can't find anything in the VBA project that matches what you have in the property for the OnLoad event. This could be coming from a missing reference in your VBA project. Also, have you tested it with a later version of SQL Server? The OLE-DB driver for SQL Server in Win-7 is quite different from what you have in Win-XP.

Post #1305670

peter478

Posted Thursday, May 24, 2012 5:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 7:31 AM
Points: 46, Visits: 174

It doesn' t matter what is in expression, because this error appier always, I want to open a form.

1. If I delete OnLoad event in origin form then the form is opened without error message.
2. If I add OnLoad event to origin form for example: Msgbox "hallo" ...I got error message.
3. If I create completely new form it works fine.

No I didnt tested it with later version of sql server. Do you think that problem is in version sql?

btw...SQL2000 db server is installed on system W2003 server.

Post #1305713

liebesiech

Posted Thursday, May 24, 2012 5:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:55 AM
Points: 126, Visits: 751

Which version of Windows 7 do you have? Have you tried to run a debug on your code? What kind of controls do you use on that form? Have you checked the REFERENCES in the VBA IDE?

Post #1305724

WendellB

Posted Thursday, May 24, 2012 5:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:46 AM
Points: 106, Visits: 405

So what exactly do you want to happen with the OnLoad event on the form? Apparently it is working just fine on Win-XP, but not on Win-7. The OnLoad event must either contain the name of a macro, a VBA procedure, or an expression (which is rarely used ).

Post #1305728

peter478

Posted Thursday, May 24, 2012 5:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 7:31 AM
Points: 46, Visits: 174

Which version of Windows 7 do you have? Windows7 enterprise service pack 1
Have you tried to run a debug on your code? yes
What kind of controls do you use on that form? e.g. open form, close form etc...general controls
Have you checked the REFERENCES in the VBA IDE? no ...what do you think ?

Post #1305729

peter478

Posted Thursday, May 24, 2012 5:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 7:31 AM
Points: 46, Visits: 174

This is general problem, I have more access db(.adp) , and every show this error when I want open form....

Post #1305732

robert.gerald.taylor

Posted Thursday, May 24, 2012 6:13 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:31 AM
Points: 733, Visits: 781

Are you switching/upgrading from an earlier version of MS Access? I have a vague memory that Access tightened down some security constraints (that could be undone in Settings) to warn if code was going to run.

Rob

Post #1305758

« Prev Topic | Next Topic »

28 posts, Page 1 of 3

1 2 3 »»»

Permissions