Con.connectionstring = provider=microsoft.jet.oledb.4.0 data source

Members Current visitors New profile posts Search profile posts. C Community. Log in Register. Search titles only. Search Advanced search….

New posts. Search forums. Log in. Install the app. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Unable to open database. Thread starter JA12 Start date May 12, JA12 Member.

I initially tried: VB. Error Details: Number: 5 Description: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Error Details: Number: 5 Description: Not a valid account name or password. Set this value to 0 to scan all rows. This might hurt performance. If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection string.

If you try, you receive the following error message: "Could not decrypt file. A workaround for the "could not decrypt file" problem. Important note! The quota " in the string needs to be escaped using your language specific escape syntax. New Post.

Hi , I am trying ot connect a VB application to Access database. Please help in forming the connection string so taht i can connect to the remote system connected in network. Follow Post Reply. Cor Ligthert. Vignesharaw, Than just change the filepath in that, all users needs to have rights for that by the way Access is not a database server, it is a database file. I hope this helps?

Hi Cor, Thanks for that. But it needs the folder containing the file to be shared! Is there any otehr way to achieve this without sharing the file? Vignesh Not that I know with ms-access Sorry Cor. Anyway, thanks Cor. Paul Clement. Have you tried using a UNC path name? Hi Paul, Thanks for your comment.