Discussion:
Losing functionality after compiling to mde with MS Acess 2003
(too old to reply)
GIP
2009-07-15 13:03:03 UTC
Permalink
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
2009-07-16 13:20:55 UTC
Permalink
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
Post by 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
unknown
2009-10-10 13:40:36 UTC
Permalink
Post by 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
Post by 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
Tony Toews [MVP]
2009-07-18 18:37:46 UTC
Permalink
Post by GIP
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
--
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/
GIP via AccessMonster.com
2009-07-19 09:16:50 UTC
Permalink
Thanks to both of you,

Next week I am at the user's e and I will test it and post the results back.
Post by GIP
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]
Post by GIP
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200907/1
unknown
2009-10-10 13:40:44 UTC
Permalink
Post by 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.
Post by GIP
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]
Post by GIP
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200907/1
unknown
2009-10-10 13:40:38 UTC
Permalink
Post by Tony Toews [MVP]
Post by GIP
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
--
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/
unknown
2009-10-10 13:33:45 UTC
Permalink
Post by 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
unknown
2009-10-10 13:40:48 UTC
Permalink
Post by 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
Loading...