SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


compatibility problem Win7


compatibility problem Win7

Author
Message
peter478
peter478
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 313
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.
Attachments
accessrt.jpg (56 views, 54.00 KB)
Rob Taylor
Rob Taylor
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3798 Visits: 1616
Can you set a breakpoint in your OnLoad event and step through to see what line is causing problems?
peter478
peter478
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 313
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.
WendellB
WendellB
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2090 Visits: 1831
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.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
peter478
peter478
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 313
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.
liebesiech
liebesiech
Mr or Mrs. 500
Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)Mr or Mrs. 500 (570 reputation)

Group: General Forum Members
Points: 570 Visits: 863
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?
WendellB
WendellB
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2090 Visits: 1831
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 ).

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
peter478
peter478
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 313
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 ?
peter478
peter478
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 313
This is general problem, I have more access db(.adp) , and every show this error when I want open form....
Rob Taylor
Rob Taylor
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3798 Visits: 1616
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search