ADO Error message for database

[ruddconsulting]

So after upgrading and merging the database I am now getting this message: ADO Error Message: [FireDAC] [Phys][ODBC][Microsoft] [ODBC Microsoft access Driver] General error Unable to open registry key Temporary (volatile) Acs DSN for process 0x11c0 Thread 0x1150 DBC 0x8557 fb4Jet

This only happens if two or more computers attempt to access the database. The database was moved to a USB drive on the router so could that be the issue and I need to move it to a different drive such as the NAS drive? This is when it all started. I have the screenshot attached.

Thank for your help!!

[Paul Mayer]

The image was too small to be able to read but your text of it helped. It is a security issue as you can see in this Microsoft KB Article:

http://support.microsoft.com/kb/295297

I'm not sure that a USB drive can handle traffic at a rate that an actual hard drive on the network would. But that is not why the error message is popping up.

See this video on giving full read/write privileges for the database folder to all users:

http://timeclockwindow.com/help/SetFolderProperties/index.html

[ruddconsulting]

Thanks Paul!
I have checked the security permissions on both computers and they seem fine. What has me stumped is that if Computer A logs on first then computer B everything works fine. If Computer B logs on first then Computer A will get the message. Changed the admin settings on computer A to see if that would help and it did not. I have also been unable to change the security permissions on ready share on the netgear router and have a question to them about that. I have even mapped the folder as a network drive to see if I could make that work but no luck. Now is has become a quest.....chuckling. The folder and file have full permissions set for everyone but above it I could not change.

[Paul Mayer]

Did you go to that Microsoft KB Article? It's a known security issue as you can see since they have a special set of instructions to fix the problem. You might want to try their instructions on that Article.

[ruddconsulting]

Hello Paul; Yes I did follow the KB article you pointed out and set the permissions in the registry. There is no change so we will keep on looking.

[Paul Mayer]

Another thought since it is a security issue is the Antivirus software on your computers may be blocking it.

Right click on the TCW Icon and select Run as Administrator to test. I'm thinking that would override any AV blocking.