Known Issues between Access 2000 and Win XP

[Tee]

I am specifically running into a problem with the "me"
extension in the VB 6.0 backend of my Access db in XP.
Are there any known patches or fixes? Also are there any
other known issues that I might need to look out for
between Access 2000 and XP? Thanks for any help that
anyone might be able to provide.


Tee

 

[Douglas J. Steele]

Not sure what you're asking, because your terminology is confusing.

Typically, the term "backend" refers to the data. When you split an Access
application, the frontend contains the queries, forms, reports, macros and
modules, and the backend contains the tables. That means you can't have VB
6.0 as a backend, as it isn't a DBMS.

I'm also unsure of what you mean by 'the "me" extension'. Are you saying
you're trying to use the Me keyword?

Please post back with more details.

 

[Guest]

My apologies, yes I was talking about the "me" keyword
with the Vb 6.0 modules that are running behind the
tables. I was drawing a blank at the time. Are there any
known patches or fixes? Also are there any other known
issues that I might need to look out for
between Access 2000 and XP? Thanks for any help

I keep getting the error message "Function is not
available in expressions in query expression "UCase
([forms]![formCopyWorkOrder]![txtCopyTo])". I found that I
was missing a reference to the AcPreview ActiveX Control
Module in Access 2000 on my Windows XP box. This could
very well be my problem. Does anyone know where I would
find that file or what the file name is?
Thanks for the help and sorry for the confusing
terminology

 

[Douglas J. Steele]

On a machine where it's working, try running the following code:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next refCurr

End Sub

That'll tell you each file it's using, and where it's supposed to exist.
Once you know the file in question, if it's from Microsoft, you can go to
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dll
info.asp and see whether it'll tell you where the file came from.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

My apologies, yes I was talking about the "me" keyword
with the Vb 6.0 modules that are running behind the
tables. I was drawing a blank at the time. Are there any
known patches or fixes? Also are there any other known
issues that I might need to look out for
between Access 2000 and XP? Thanks for any help

I keep getting the error message "Function is not
available in expressions in query expression "UCase
([forms]![formCopyWorkOrder]![txtCopyTo])". I found that I
was missing a reference to the AcPreview ActiveX Control
Module in Access 2000 on my Windows XP box. This could
very well be my problem. Does anyone know where I would
find that file or what the file name is?
Thanks for the help and sorry for the confusing
terminology

-----Original Message-----
Not sure what you're asking, because your terminology is confusing.

Typically, the term "backend" refers to the data. When you split an Access
application, the frontend contains the queries, forms, reports, macros and
modules, and the backend contains the tables. That means you can't have VB
6.0 as a backend, as it isn't a DBMS.

I'm also unsure of what you mean by 'the "me" extension'. Are you saying
you're trying to use the Me keyword?

Please post back with more details.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)






.

 

[Guest]

Thanks, that really helped. I was able to find the file
it was missing.

Tee

-----Original Message-----

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next refCurr

End Sub

That'll tell you each file it's using, and where it's supposed to exist.
Once you know the file in question, if it's from Microsoft, you can go to
http://support.microsoft.com/default.aspx? scid=/servicedesks/fileversion/dll
info.asp and see whether it'll tell you where the file came from.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

My apologies, yes I was talking about the "me" keyword
with the Vb 6.0 modules that are running behind the
tables. I was drawing a blank at the time. Are there any
known patches or fixes? Also are there any other known
issues that I might need to look out for
between Access 2000 and XP? Thanks for any help

I keep getting the error message "Function is not
available in expressions in query expression "UCase
([forms]![formCopyWorkOrder]![txtCopyTo])". I found that I
was missing a reference to the AcPreview ActiveX Control
Module in Access 2000 on my Windows XP box. This could
very well be my problem. Does anyone know where I would
find that file or what the file name is?
Thanks for the help and sorry for the confusing
terminology

-----Original Message-----
Not sure what you're asking, because your terminology

is
confusing.

Typically, the term "backend" refers to the data. When you split an Access
application, the frontend contains the queries, forms, reports, macros and
modules, and the backend contains the tables. That

means
you can't have VB

6.0 as a backend, as it isn't a DBMS.

I'm also unsure of what you mean by 'the "me"

extension'.
Are you saying

you're trying to use the Me keyword?

Please post back with more details.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



I am specifically running into a problem with the "me"
extension in the VB 6.0 backend of my Access db in XP.
Are there any known patches or fixes? Also are there any
other known issues that I might need to look out for
between Access 2000 and XP? Thanks for any help that
anyone might be able to provide.


Tee


.

.