Microsoft Access 2003 Problem

[ashley.moses]

Hi,

I have a visual basic 6.0 application with microsoft access 2003 as
the backend.

One of the users cannot open the access db via the vb app.
All the other users can open the access db from the vb app and when I
asked the user to log on one of the other users machines it seems to
work 100% - the access db opens and he can print the report.

The database resides on a server where +- 8 users are mapped. I tried
re-installing ms access 2003 but still nothing happens. I even logged
on the machine myself but it still does not work.

It seems there is a problem with the user's machine as the other users
can work with no hassle.

Can anyone assist.

Thanking you in advance.

 

[Tony Toews [MVP]]

One of the users cannot open the access db via the vb app.

Are there any error messages?

You might need to register the DAO dll using regsvr32. For example
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\DAO360.DLL

An easy way to register a file is to search for both files at one time
(<insert name of your file> REGSVR32.EXE) then drag and drop the
OCX/DLL onto the EXE. As most relevant DLLs and OCXs reside in
c:\<your windows version>\system32 you can try in this directory first
to minimize searching time. If that doesn't find both then go up a
directory level to c:\<your windows version>.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[ashley.moses]

Hi Tony,

Thanks for the reply.
I have done what you told me to do but still no joy.

And there are know error messages that display.

Do you have any other suggestions?

Ashley