Windows Forum

Ask something
Question Locked

Problem with Access on Vista

0 helpful
9 replies

by edlockett

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have developed a (fairly simple) application in Microsoft Access 2003 that is to be deployed to client computers using the Access 2007 Runtime. It has been thoroughly tested and works fine with the Runtime on Windows XP. However, it causes problems when used on a computer with Windows Vista.
First it complained about not being able to find a required DLL, FPDTC.DLL - this appears to be related to FrontPage and I'm not sure what part of the application would use something from this library. I copied the file in question from a Windows XP computer, which made the error go away.
Now this is the funny part - the application falls over (runtime error) whenever it encounters the Date function. The function Now, which returns date and time, does not cause a problem. How could this be?
Any advice on this issue would be most appreciated!

9 replies

by shasca

In Programs and Features in the Control Panel of the Vista PC. Click on the Microsoft Office 2003 in the list click on Change/Add or Remove Features Choose advanced customization of applications. When you get to the list of installed applications make sure run all from my computer is checked for Access, and all the other installable options. I'm guessing that the install on the Vista PC is missing an Office feature/component that is installed on the XP PC's

Hopefully I didn't confuse you with these instructions. Basically it is just reinstalling Office and making sure all features are installed on the Vista PC

by edlockett

Hi, thanks very much for your reply. However, you must have missed the bit about the Runtime... There is no Office on any of the client PCs, so they are using the Runtime instead. At the moment I can't install a full version of Access on a Windows Vista computer, which does reduce the steps I can follow to investigate the issue.
You might well have a good point there about some component being missing, but I need to figure out which one exactly!
Thanks
Ed

by shasca

Your right I did miss that. The idea is the same though. The operating system version shouldn't affect the way an application runs.(shouldn't) I have seen making changes in the Region and Language applet in the control panel affect data output in Access, but I haven't fiddled with that in Vista yet.

by Former member

create a new module within Access then go to
tools > references and un-checking the tick box relating to the missing "FPDTC.dll".

Please post back if you have any more problems or questions.

by edlockett

I suspected it might be related to the references..
I need to configure a virtual machine with Vista for testing. Will post back to report progress!
Cheers.

by edlockett

Cheers Peco, that worked a treat!
Take it easy
Ed

by Former member

Please post back if you have any more problems or questions

by v.farrell

Hi, I am examining an old access app that worked fine on XP but on vista, it's missing all sorts of references including one for "TheType". I have no idea what this is used for but it's preventing me from running the app. Any ideas?

This discussion is closed to new replies.