Citrix Server/MS Accesss

Here's the scenario.... A Microsoft Access 2003 Application is accessed via a Citrix Server. Now some references were broken by 2013 users. I've since created a 2013 front end for those users. Some of the 2003 clients can access the application no problem - and others get Broken reference errors like

your parallel inventory database for project contains a missing or broken reference to the file ABEDAO.DLL,

parallel inventory your database or project contains a missing or broken reference to file: ACEDAO.DLL,

Parallel Inventory Reports database or project contains a missing or broken reference to the file 'ACEDAO.DLL' version 12.0

I believe this is the result of the 2013 Access - but I have since fixed the frontend of the 2003 version (in 2003)

which makes me wonder if the reference has to be fixed on the clients local machine instead - even though it is accessing through Citrix? This is totally baffling whereas some can access it through both Citrix servers pointing to this, and some cannot

Any Ideas? This has been going on for days, and it appears to be the same people who keep having the issue.
dawber39Database Analyst / Application DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<which makes me wonder if the reference has to be fixed on the clients local machine instead - even though it is accessing through Citrix?>>

  No.   references must be valid for the machine where MSACCESS.EXE is running, which in this case is the Citrix server

<<I believe this is the result of the 2013 Access - but I have since fixed the frontend of the 2003 version (in 2003)>>

  What's the *exact* setup you have for the front ends?

Jim.
dawber39Database Analyst / Application DeveloperAuthor Commented:
I believe This is correct for references - if not please let me know.

PAIRef.png
dawber39Database Analyst / Application DeveloperAuthor Commented:
and Im not exactly sure what you mean by <Exactly what setup do you have for front ends?>
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

dawber39Database Analyst / Application DeveloperAuthor Commented:
front ends are on a shared drive. 2013 users are pointed to the new accdb front end. I know it is better for everyone to have there own front end - but that's not the way they do it here. Citrix 2013will be in operation soon they say but for now it is in 2003, and there are 2003 clients out there. When I first arrived on the job - I had said this is going to cause problems down the road.

I believe I have the correct references selected - its been awhile since 2003. Any advice you can give to resolve this issue is appreciated. This has to be working - workarounds - are not an option. They consider them bandaids.

Thank you so much for your help with this
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
So you've got both A2003 and A2013 installed on the Citrix server correct?

Jim.
dawber39Database Analyst / Application DeveloperAuthor Commented:
The 2013 version of Citrix Server and the application are not in operation at this time - however - there are people that have 2013 Access installed on their local machines - and are accessing the front end directly from its directory via shortcut - hence the broken references for the 2003 Citrix users, and the recent creation of the 2013 front end to point newer version users to until the 2013 Citrix environment is functioning
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not sure I understand the problem then.....if each has their own copy, you should not be having problems with references.

 But with that said, if the A2013 users are opening the FE directly, then their not using Citrix.  Your Citrix server is just acting as a file share server.

 What you should have no matter what however is two versions, and each user should have their own copy of the FE that is specific to their version.

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dawber39Database Analyst / Application DeveloperAuthor Commented:
Thank you Jim - the problem was with the references. I set up a 2003 test environment - which worked perfectly until I accessed the application through 2013, thereby stealing the references, and breaking functionality for two of the virtual machines I had connected when the Access 2013 connected. You pointed me in the right direction, and I appreciate that.
dawber39Database Analyst / Application DeveloperAuthor Commented:
Awesome - I can always count on an answer, or a push to the right direction.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Citrix

From novice to tech pro — start learning today.