Losing functionality after compiling to mde with MS Acess 2003

[GIP]

Hi Guys,

I am new to this forum and I have strange problem with MS Access 2003..
I have a database which is splitted in a front- and a backend. The back-end
is located on a network drive. So far nothing new.

However I have tested the mde on my own pc and everything works fine.
However when I use the same mde on another environment I lose functionality
(e.g. A form won't open). When I compile I did not get any error messages.

Does anybody have the same experience and maybe a solution?

Best Regards,

GIP

 

[Alex Dybenko]

Hi,
could be that you have some references in you database, which are not
present on "another environment". Check all your references and make sure
that any not-built-in (which are access, VBA, DAO/ADO (ado - version should
match!), office), present there. You can also try to compile MDB there, and
access tell you what is missing

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tony Toews [MVP]]

I am new to this forum and I have strange problem with MS Access 2003..
I have a database which is splitted in a front- and a backend. The back-end
is located on a network drive. So far nothing new.

However I have tested the mde on my own pc and everything works fine.
However when I use the same mde on another environment I lose functionality
(e.g. A form won't open). When I compile I did not get any error messages.

To add to Alex's posting. Try running the following code and post the
results back.

Sub ViewReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." &
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

 

[GIP via AccessMonster.com]

Thanks to both of you,

Next week I am at the user's e and I will test it and post the results back.

I am new to this forum and I have strange problem with MS Access 2003..
I have a database which is splitted in a front- and a backend. The back-end

[quoted text clipped - 3 lines]

However when I use the same mde on another environment I lose functionality
(e.g. A form won't open). When I compile I did not get any error messages.

To add to Alex's posting. Try running the following code and post the
results back.

Sub ViewReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." &
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

 

[o;;]

Hi Guys,

I am new to this forum and I have strange problem with MS Access 2003..
I have a database which is splitted in a front- and a backend. The
back-end
is located on a network drive. So far nothing new.

However I have tested the mde on my own pc and everything works fine.
However when I use the same mde on another environment I lose
functionality
(e.g. A form won't open). When I compile I did not get any error messages.

Does anybody have the same experience and maybe a solution?

Best Regards,

GIP

 

[o;;]

Hi,
could be that you have some references in you database, which are not
present on "another environment". Check all your references and make sure
that any not-built-in (which are access, VBA, DAO/ADO (ado - version
should match!), office), present there. You can also try to compile MDB
there, and access tell you what is missing

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[o;;]

To add to Alex's posting. Try running the following code and post the
results back.

Sub ViewReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." &
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

 

[o;;]

Thanks to both of you,

Next week I am at the user's e and I will test it and post the results
back.

I am new to this forum and I have strange problem with MS Access 2003..
I have a database which is splitted in a front- and a backend. The
back-end

[quoted text clipped - 3 lines]

However when I use the same mde on another environment I lose
functionality
(e.g. A form won't open). When I compile I did not get any error
messages.

To add to Alex's posting. Try running the following code and post the
results back.

Sub ViewReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." &
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

 

[o;;]