problem with accessing password protected access database

[harikrishnanair]

Hello All,

Mine could be a tricky problem.
I have developed a mail server (using free Socket Wrench component instead of winsock control). There is a password protected access database which is used to store few info. Now, here's the catch. In most of the PC (with winxp, win98, win2003) everything is working perfect, but in one winXP pc and one Win 98 pc, the application shows an error that it is not able to open the database. Would somebody tell me how I can debug this problem ? In my development PC everything works fine, and works fine at almost all other place I tested except for the two places i mentioned.

Sometimes I also get "Illegal Operation" error. What could be the problem?

I also keep a log file to save all the operation I do in the application. This log file could be viewed from the application. (I provided a button. If user clicks on this button, the log file would be opened in notepad. simple). One day I got an error saying that the log file is in use by another application, hence my application cannot access it. I thought that may be the user is keeping the log file open when I'm trying to write to it. So now what I do is before displaying the log file to the user, I make a copy of the original log file and display this copy to user, so that I can write to the original in the background. But I'm stilll getting this problem SOMETIMES.

There's another issue. When I download mail I make temporary txt files and store it in a temp location. But if there's a virus in it, and if there's a anti-virus running in the application, the antivirus either locks the file or deletes it. But in the background I'm trying to access this file, and I get error. Is there any solution to this?


Any help on these issues would be highly appreciated, as I'm struggling with these for the last six months. PLEASE.

[dee-u]

How are you accessing the password protected database? Does those pc's have sufficient rights to open the database?

[harikrishnanair]

How are you accessing the password protected database? Does those pc's have sufficient rights to open the database?

I am using connection string. MS Jet connection. There's password provision in it. See the problem is, I am able to access the db in some PC and in few PC i'm facing the problem, so I'm sure it's not the connection string which is causing the problem.
And if there had been any issue with rights, then it should have worked in all win98 pc. But win98 pc is also giving problem. I don't think there is any rights issue in 98. Or am I wrong?

[d3gerald]

this is how i connect to a password protected access database

'cn is my adodb connection
cn.Open 'Provider = Microsoft.Jet.OLEDB.4.0;Data Source = <Path and filename of your database here>;Persist Security Info=False;Jet OLEDB:Database Password=password'

[RobDog888]

For all your connection string formats - http://www.connectionstrings.com

Are you receiving an error message and what is it if any?

Did you install the program or did you copy over your exe and db? Did you install MDAC? What version is the database in? Access 97, 2000, 2003?

[harikrishnanair]

this is how i connect to a password protected access database

'cn is my adodb connection
cn.Open 'Provider = Microsoft.Jet.OLEDB.4.0;Data Source = <Path and filename of your database here>;Persist Security Info=False;Jet OLEDB:Database Password=password'

This is how even I did it. As I told you before. In most of the PC it is working, but there's one particular 98 and one partcular XP pc where it is not working.
When I try to connect, it returns false.

[harikrishnanair]

For all your connection string formats - http://www.connectionstrings.com

Are you receiving an error message and what is it if any?

Did you install the program or did you copy over your exe and db? Did you install MDAC? What version is the database in? Access 97, 2000, 2003?

No error. My connection string returns false.
In most of the PC it is working, but there's one particular 98 and one partcular XP pc where it is not working. I cannot figure out why it's happening.

I installed the program, ofcourse. . MDAC, VBRuntimes...I tried everything.
Access 2000.

[harikrishnanair]

somebody pls help me with this.....PLEASE... atleast give me a valid reason as to why this would happen...

What about "Illegal operation" error?

[RobDog888]

I skimmed over the thread again and didnt see if you mentioned if this is a db on a network share r are all local copies of the db?

For the XP system, do you have the XP firewall tuned on?

For the 98 system is it 98 SE or just 98?

[harikrishnanair]

I skimmed over the thread again and didnt see if you mentioned if this is a db on a network share r are all local copies of the db?

For the XP system, do you have the XP firewall tuned on?

For the 98 system is it 98 SE or just 98?

Thank you for the concern.

The application has it's own local db. Nothing to do with network share.

XP: Firewall off.

And it's simple 98.

[RobDog888]

Verify the version of MDAC on those two systems by downloading the Component Checker utility from MS (its free) and it will tell you what version is installed on each system