Error accessing the system registry

Cogito

I installed Office 2000 Professional onto a Windows Vista laptop and when I tried to compile the code the following error message appears:

'User-Defined type not defined'

I went to check the registry and the following message appears:

'Error accessing the system registry'.

I have tied to repair Access using the Office 2000 repair facility but no luck.

Do you have any suggestions on this problem.

Thank you

May 19 '07 #1

ADezii

I installed Office 2000 Professional onto a Windows Vista laptop and when I tried to compile the code the following error message appears:

'User-Defined type not defined'

I went to check the registry and the following message appears:

'Error accessing the system registry'.

I have tied to repair Access using the Office 2000 repair facility but no luck.

Do you have any suggestions on this problem.

Thank you

Post the code that you were attempting to compile.

May 19 '07 #2

Cogito

I forgot to mention that error occurs when I try to look at the references in the Visual Basic window.

Here is a sample of the code. There is no problem with it on an XP laptop.
Thank you for your help in this matter. I am not a experienced programmer, I try an learn as I go along.

May 21 '07 #3

Denburt

The code appears to be o.k. from what I can see. When you get the error message is there a button called "debug" if so click this and tell us what line it is on.
'User-Defined type not defined'

FYI, I know your version is 2000 but have heard that MS Access 2007 is much more restrictive in the syntax department than previous versions. Although many people disagree for one reason or another the correct way to refer to a control is Me!ControlName. Me.Controlname can be quite quirky I have found this to be an issue for me in the past with older versions of Access. Just an idea.

According to Microsoft one thing MS Access will not like in Access 2007 is if you use a boolean as such.

If myBool then

Microsoft states that in 2007 you will need the complete statement.

If myBool = True then

May 21 '07 #4

ADezii

I installed Office 2000 Professional onto a Windows Vista laptop and when I tried to compile the code the following error message appears:

'User-Defined type not defined'

I went to check the registry and the following message appears:

'Error accessing the system registry'.

I have tied to repair Access using the Office 2000 repair facility but no luck.

Do you have any suggestions on this problem.

Thank you

1. The Style and Response Variables are Declared as String which is incorrect, they shoud be declared as Integers, namely:
   
   Expand|Select|Wrap|Line Numbers

   1. Dim Msg As String, Msg2 As String, Response As String, Style As String
   2.                                'SHOULD BE
   3. Dim Msg As String, Msg2 As String, Response As Integer, Style As Integer
   4.  
2. GoTo Line Number, except in Error Trapping, is usually never a good idea to use. It is only supported for backward compatibility and may not even be supported in 2007. Check on this.

May 22 '07 #5

Cogito

Thank you for your prompt reply,

The problem is on a friend's laptop and I do not have access to it this week. From memory when I ran compile the error starts on the first DIM statement.

When I select Tools/References in the Microsoft Visual Basic window the

"Error accessing the system registry" message appears.

The database runs fine on my XP laptop.

I hope this is of help.

May 22 '07 #6

Denburt

It is als nevera goog idea to use a single word for variables you might find yourself bumpininto keywords especially since they can change from version to version.

instead of:
Dim Msg As String, Msg2 As String, Response As Integer, Style As Integer

I would use:
Dim Msg As String, Msg2 As String, intResponse As Integer, strStyle As Integer

May 29 '07 #7

missinglinq

You might want to look at this forum's posting regarding Vista and Access databases!

http://www.thescripts.com/forum/thread653390.html

May 29 '07 #8