Hi there,
I've converted a .mdb 2003 database to vs. 2007. I'm getting a compile
error in the 2007 version, everything runs fine in the old version.
For example, in
With rec
.FindFirst "[Login] = '" & Me.Login & "'"

the Compile error "Method or data member not found" is generated when
execution hits the "Me.Login" part of the code.

Is there something else I need to do in order to convert to 2007?
Secondly, I intend to Publish this to Sharepoint, is there anything else I
should look out for, or known not to work in Sharepoint?

Thanks in advance!
Marty

Nevermind.... looks like I needed to change my "Dim db as Database"
declarations to "Dim db as DAO.Database", as well as the recordset ones too.
Now it works fine.
Thanks!
Marty

"MartyO" wrote:

> Hi there,
> I've converted a .mdb 2003 database to vs. 2007. I'm getting a compile
> error in the 2007 version, everything runs fine in the old version.
> For example, in
> With rec
> .FindFirst "[Login] = '" & Me.Login & "'"
>
> the Compile error "Method or data member not found" is generated when
> execution hits the "Me.Login" part of the code.
>
> Is there something else I need to do in order to convert to 2007?
> Secondly, I intend to Publish this to Sharepoint, is there anything else I
> should look out for, or known not to work in Sharepoint?
>
> Thanks in advance!
> Marty
>
>

Ah, the References issue again.

FWIW, MartyO, this might help avoid some of the more common issues:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MartyO" <(E-Mail Removed)> wrote in message
news:A434B129-4364-4A11-A636-(E-Mail Removed)...
> Nevermind.... looks like I needed to change my "Dim db as Database"
> declarations to "Dim db as DAO.Database", as well as the recordset ones
> too.
> Now it works fine.
> Thanks!
> Marty
>
> "MartyO" wrote:
>
>> Hi there,
>> I've converted a .mdb 2003 database to vs. 2007. I'm getting a compile
>> error in the 2007 version, everything runs fine in the old version.
>> For example, in
>> With rec
>> .FindFirst "[Login] = '" & Me.Login & "'"
>>
>> the Compile error "Method or data member not found" is generated when
>> execution hits the "Me.Login" part of the code.
>>
>> Is there something else I need to do in order to convert to 2007?
>> Secondly, I intend to Publish this to Sharepoint, is there anything else
>> I should look out for, or known not to work in Sharepoint?