rickys

Hello everyone,

I have a little situation that I need help with urgently. I have a VB6 application that uses a microsoft access database to store all the information. The database has about 5 tables that keep track of various customer transactions etc. Just so that noone can open this access database, I have setup a database password. Noone ever needs to find out or change this password, therefore I have it hard-coded into the application itself. I also have a user called EMPLOYEE and a password for that username. This is the one and the only user thats ever going to access the database therfore, its all hard-coded inside the application. My application uses both ADODB.Recordset objects and ADO datacontrol objects. Everything works fine with the recrodset as I can show the workgroup file in the code like this:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword"


However, for the ado datacontrol object (the one that looks like a horizontal scrollbar), I don't know how to indicate what the workgroup file is (MySystem.mdw). Is there a property that I can set for this control to fix this issue? Every time I run the program and go to a datagrid that takes its values from this ADO datacontrol, it crashes with an error saying: Workgroup file is missing or opened by another user.

Not sure if this made much sense but I tried my best.

Please help...


Thanks

IUnknown

You can supply the same connection string to the ADO datacontrol, or you can try this to generate the required ConnectionString.

1. Open up the Property Pages for the ADO datacontrol.
2. On the General Tab, click on the option Use Connection String.
3. Click on the Build button.
4. The DataLink Properties window will appear.
5. In the Provider Tab, select Microsoft Jet X.XX OLE DB Provider (where X.XX is the version)
6. In the Connection Tab, enter your Access DB name and Logon information
7. Go to the All Tab.
8. Scroll down the list until you see "Jet OLEDB System Database" in the Name column.
9. Change this value to your System.mdw full path.
10. Click OK.