I have a program entitled "Club Administration Software". When I try to call up the database, it replies with runtime error 91. Any suggestions? I am using win7 and have it in compatibility mode. It worked great in XP. Thank you for your help.

Hi tatarpy,
What type of database you are using? I think its becoz of Operating system as you have mentioned. Windows 7 has more features but old hardware and softwares are less compatible with OS Windows 7. I have also encountered the same problem with VB6 in compatibility mode. So I have to re-install my XP OS.
Thankx

Okay, it is helpful if you also include the description of the error that you recieve as most of us do not remember the number but the statement...

In this case it is Object variable or with block variable not set...

Which means, you have an undeclared variable somewhere or have not set it correctly. Meaning...

Dim adoRs As ADODB.Recordset
Set adoRs As New ADODB.Recordset 'missing this somewhere...

or you are missing something like that...

Good Luck