Using Citrix for my database and corruption error occurs

[Brandon Cheal]

I am using Citrix server to post a database on. When I
open the MDE file on the Citrix server, I get an error
message, "The Visual Basic for Applications project in the
database is corrupt."
If I point the shortcut to open the MDB file, no such
error occurs. I have compiled the code in the mdb and
recreated an mde several times, but to no avail. What
could be causing this error? Thanks!
Brandon

 

[Arvin Meyer]

There is only one 100% successful method of using Terminal Services. Split
the data and put a copy of the front-end in a folder for EACH user. No
exceptions! I also like to compile any databases on the same server to make
sure all the references are properly set. I have 4 users using MDE's on a
Terminal Server, and haven't had a problem yet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Brandon cheal]

But I get this message when I have only one user (myself)
logging into the database, so I'm not sure it's a problem
of multiple user conflicts yet. Currently myself and one
other person are mapped to the same front end mde (which
is already split and pointed to a back end).
I am relaying all this info to my Citrix admin because I
know minimal info about it and he knows minimal info about
Access. We're trying!
You talk about compiling on the same server...
can you explain this better to me, because I want to
report this info to my Citrix admin. Does this mean that
I should not compile the mdb and create an mde from my
machine? Also, from what I understand, the way we are
accessing the file through Citrix is he points to the file
on my network drive (letter S. So I still work on the
database through my local computer which is mapped to the
S: drive. Is this acceptable, or do we actually need to
move the database to the Citrix computer/server? Thanks
for your help, it is greatly appreciated!

 

[david epsom dot com dot au]

First, you need to decide if the VBA project is really
corrupt. Is it still 'corrupt' if you copy the file
back to your PC?

If the file is not corrupt, you have some sort of
installation or access problem on the server.

If the file is corrupt, you need to work out when it
became corrupt. If you create a new MDE, is it already
corrupt? Is it corrupt in the copy you sent to the
server? Is it corrupt when installed on the server,
before it has been used? Is it corrupted when first
used? Is it corrupted after it has been used for
a little while?

This information will guide us to possible solutions
for your problem.

(david)

 

[Brandon Cheal]

-----Original Message-----
First, you need to decide if the VBA project is really
corrupt. Is it still 'corrupt' if you copy the file
back to your PC?

No, if I open the MDE file from the network, it is not
corrupt and works perfectly. It is only when I open the
file through Citrix that I get that error message. Also,
the database opens to the main switchboard fine, but when
I choose a command button, I get the message again each
time I click on the command button. It's like the error
only happens when code tries to run. I can hold shift as
I open the scorecard to bypass the startup and just open
the database window, and I don't get the error. It's only
when I open a form or report with code in it.
I am wondering if it has to do with references in the
code. I know that you can get an error when working from
one PC to another with a database when the code references
show up "MISSING." Could this possibly be the problem? I
will check the installation on the Citrix server, but what
in particular could be wrong with the 'installation' of
Access that would cause that error?

Thanks
Brandon

 

[Arvin Meyer]

I read David's post and he made some valid points. I am convinced that you
need to compile and create the MDE on the Citrix server. Let me go over the
process I use.

First, I log into the Terminal Server (we use Microsoft Terminal Server
instead of Citrix because it does what we need and is less expensive) as an
Administrator because I don't have permissions to look beyond my personal
folder any other way. We have 3 system admins with full admin rights (the VP
of finance, myself, and an IT vendor) I obtain a copy of the front-end from
the server and connect it to the back-end which is running on a dedicated
database server That server only runs the database back-end and our
corporate intranet which connect to it.

As the admin, I compile the database front-end from the Terminal Server and
make sure it is working properly. Certain of my forms are read only and I
lock the controls on those forms in real time, I do need to check that is
working properly. Then I make the MDE and place it in the specific user
folder. I usually delete the copy of the front-end MDB that I just put on
the Terminal Server so that there won't be any problems with duplicate
copies, and there won't be any chance of a hacker getting what isn't there.

I now log in to the Terminal Server as the user. Users have all rights,
except "Full Control" on their own folders. Of course they can't do too much
damage because they can't get past their own folder, and the file is an MDE
which they don't own nor can they do anything more than I've let them
because it is an MDE.

Try all of that and see if it helps. It should. BTW, Even if the Admin
doesn't want to give you admin rights, the tasks are simple enough that he
should be able to do them himself, or with you at his side.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[david epsom dot com dot au]

Yes, that sounds like a references problem. Reference
problems may be caused by Access installation problems -
the VB, DAO or ADO libraries may not be installed correctly.
Or they may be caused by use of some other object which
is (a) not installed on the server, (b) installed, but
with a different version, (c) installed, but in a different
folder.

Doing the compilation on the server, as explained by
Arvin in this thread, will either solve the problem, or
help you to find the problem.

(david)

 

[Tony Toews]

I am using Citrix server to post a database on. When I
open the MDE file on the Citrix server, I get an error
message, "The Visual Basic for Applications project in the
database is corrupt."

I suspect you are creating the MDE in A2003 on your system. But the
Citrix server has A2002 which will give you the message you describe.

You must create the MDE in A2002 if that is what is installed on the
Citrix server.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm