Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

compatibility problem Win7 Expand / Collapse
Author
Message
Posted Friday, May 25, 2012 6:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 11:54 AM
Points: 48, Visits: 185
WendellB (5/25/2012)
I've tested several combinations of OS and Access, and with the ADP format I always get the 2.5 version. Unfortunately I don't have SQL Server 2000 to test against, so I can't exactly replicate your situation. Have you scrolled down the list of references so see if the 2.5 version shows there? It is alphabetical, so it will be pretty close to the top of the ones that start Microsoft....


Yes I have found 2.5 version , but always the same error...at weekend I will try to install SQL2005 and I will see if it help ...
Post #1306498
Posted Tuesday, May 29, 2012 11:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 11:54 AM
Points: 48, Visits: 185
I have not installed SQL2005 or higher ...but I find new think ...I have problem also with mdb files, that are not connected to SQL server. The same error message appiers, when I want to open a form.
Post #1308112
Posted Wednesday, May 30, 2012 4:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 11:54 AM
Points: 48, Visits: 185
Hello ,

I am posting you an example of problematic mdb file, with the same error like before.
This error message is on all my mdb, adp files, that I tried to run under win7 with ms access 2007.

Thanks for you help


  Post Attachments 
example.zip (6 views, 24.00 KB)
Post #1308236
Posted Wednesday, May 30, 2012 5:49 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 130, Visits: 801
Ok, got the same error as you described. I try to find some time to track it down.
Post #1308267
Posted Wednesday, May 30, 2012 9:19 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 130, Visits: 801
Have you checked this?
http://support.microsoft.com/kb/907337/en-us?fr=1

Compare the language settings on the system where you created the database with your Windows 7 system. Looking at some of the entries in the system tables this could be the reason. Example "Nesúvisiace objekty". This accented characters pointed me in this direction.
Post #1308438
Posted Wednesday, May 30, 2012 2:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 11:54 AM
Points: 48, Visits: 185
Not yet, tomorow Im going to check it.

Thank you for advice!


Post #1308616
Posted Friday, June 1, 2012 12:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 11:54 AM
Points: 48, Visits: 185
YES, the problem was just in Unicode settings in Win7, so easy!
It seems that it works fine without problem.
Thanks again for your advice!

Here is the guide:
Method 1: Verify the non-Unicode language
If you are running the VBA code on a Microsoft Windows XP-based computer or on a Windows 2000-based computer, you may be able to resolve this issue by changing the non-Unicode language setting on the computer where you are running the VBA code. To verify and to change the non-Unicode language setting, follow these steps.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Click Start, click Run, type Intl.cpl, and then click OK.Under Language for non-Unicode programs on the Advanced tab, verify that the language matches the language on the computer on which you created the event handler, the function, or the subroutine. If the language differs, click the language that you want, and then click OK.
Restart the computer.
Post #1309516
Posted Friday, June 1, 2012 1:43 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:44 PM
Points: 130, Visits: 801
Hi,
Great! Thanks for posting the final solution here! Just to complete this thread, find attached a screen shot showing how you get to the system tables in MS Access 2007.
Cheers René


  Post Attachments 
MSAccess_SystemTable.jpg (3 views, 135.78 KB)
Post #1309546
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse