Access and PCAnywhere

[RobynB]

Hi,

I bought PCAnywhere as I was told that I could then use that to have
employees in other offies open and use the same database, but I get this
error code on the remote people's connections:

"Profile Application - Your profile application database or project contains
a missing or broken reference to the file COMDLG32.OCX version 1.2" It then
says that I have to fix the missing or broken reference before using the
profile application.

I am not sure what to do on this. I have the HOST computer in my office and
when I connect to it via a shortcut I built or throught the HOST computer it
opens fine. This is just happening on those who are remotely connecting to it.

Any suggestions are much appreciated.

Thanks,
Robyn

 

[Pete D.]

I'm not familar with using PCAnywhere this way but the message your getting
should be fixed by registering the file. If you need to download the ocx
you can get it here and register it on the other machines.
http://www.ascentive.com/support/new/support_dll.phtml?dllname=COMDLG32.OCX

To register it save the fill to directory listed below and then on the run
cmd line enter below exactly. If it works you will get the message
DllRegisterServer ... succeeded. The WEB site above has more details.

regsvr32 \windows\system32\COMDLG32.OCX

 

[Sylvain Lafontaine]

It's not clear from your message if it's PCAnywhere that simply cannot
connect to remote machine or if after the connection - and proper working of
PCAnywhere for other task like opening and displaying WIndows Explorer - it
fails when you attempt to open Access.

I'm no longer familiar with PCAnywhere because I stopped usint it many years
ago: it's generally considered better to use Remoting instead (like with
Remote Desktop, Terminal Server (TS) - with or without Citrix - or Thinsoft
(thinsoft.com)) than to use PCAnywhere because the later captures the screen
at the display level (it's pixel based), making it slower than Remoting also
because it permits only one user at a time on any host machine. However,
if you can open a connection to a remote machine with it, I don't see why
you should have any problem opening Access after that.

 

[Arvin Meyer [MVP]]

As the other's have mentioned, using PCAnywhere is not a good idea with
Access. Actually, it's not that good with any software any more because of
security concerns. It broadcasts your IP address to any PCAnywhere request
so it will open a port when requested by another PCAnywhere machine.

Instead, you can try a terminal service connection using RDP. Just click on
Start >>> Run and type: mstsc.exe and an RDP app will open, then type the IP
address/ username/ domain (if necessary) and password.

Your immediate problem though is registering comdlg32.ocx. To do that go to:

Start >>> Run, then type:

"C:\Windows\System32\Regsvr32.exe" "C:\Windows\System32\comdlg32.ocx"

and click OK. You should get a message back telling you that it succeeded.
If you don't you need to change the path or locate the comdlg32.ocx file.