Issues accessing MDB

[Rich Baerwalde]

I've been able to successfully develop a program that pulls data from an MDB
file and exports it intoa VNC file for remotely accessing workstations at my
network. The program works fine on the computer I designed it on. However,
when I attempted to access the program from another computer (general
manager's) I keep receiving the error message
CLSID:{00000010-0000-0010-8000-00AA006D2EA43}.

I've downloaded and run the VB Runtime file that Microsoft gave as a
solution, as well as Access onto that computer, yet the program still cannot
find the class needed to resolve the database I established. Does anyone
have any suggestions on what I need to do?

Apologies ahead of time if I'm posting this on the wrong board. I'm still
relatively new to Visual Basic (using VB6).

Richard Baerwalde
SDS@ccess

 

[Rich Baerwalde]

-- Issue --
Please disregard the prior post. Shortly after I posted, the solution came
in a search on the MSDN section of Microsoft's site. The computer I
attempted to work this program on had the Microsoft DAO 3.6 installed, which
works with files created by Access2000 and later, whereas it did not have
Microsoft's DAO 3.5, which pulls from the earlier versions of Access.

-- Solution --
The file should be located in c:\Program Files\Common Files\Microsoft
Shared\DAO\ and accessed through the Run command in the Start Menu :
regsvr32 "c:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll" to
register it on the computer.

Richard Baerwalde
SDS@ccess

 

[Albert D. Kallal]

So it sounds like you're using an access file or database but not an access
application?

windows XP does ship with the jet database engine.

Hence, as a general rule, you should be able to read, and pull data from a
mdb file
without installing any software.


When you said VNC, did you mean VPN? I don't see how VNC would any effect
to your issue.

Note that you can't use a socket connection to an MDB file, you must use a
valid windows path name.
(and you must use valid windows networking to make this connection also.
that means if you try and pull data over the Internet you'll have to use
some type of valid windows networking).

Is hard to tell your problem here, in the meantime you might want read my
following article on using MS access databases over a WAN:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html