o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

***RESOVED***VB 6 Connect to a Secured Access DB, Workgroup file not found. -

Hello out there

I am connection to a Secured Access Database using VB6 and I always get the following error (err.number = -2147217843),

err.Description
"Cannot start your applocation. The workgroup information file is missing or opened exclusively by another user". Note: I am the only user currectly using the Database, no one alse.

My Code:
Code:
Dim strDB As String
Dim Conn As adodb.Connection

Set Conn=New adodb.Connection

Conn.Provider="Microsoft.Jet.OLEDB.4.0"
strDB="C:\DatabaseName.mdb"
Conn.CursorLocation=adUseClient
Conn.Open strDB, "UserName","CorrectPW"
There is nothing wrong with the Access Database, opened outside the VB environment, it open without any problems.
The Default workgroup file is back to System.mdw.
This Access Database has its own WorkGroup.mdw file dedicate to this Database only.

Please anyone who can help is welcomed.

Thanks a lot.

Wizard

 

***RESOVED***VB 6 Connect to a Secured Access DB, Workgroup file not found. -
Hello out there I am connection to a Secured Access Database using VB6 and I always get the following error (err.number = -2147217843), err.Description "Cannot start your applocation. The workgroup information file is missing or opened exclusively by another user". Not


vb 6 and access 2000 workgroup file creation -
I have written a project that utilises an existing workgroup file to access a secured mdb, add users and set their relvant permissions. ...but what I really want to do is to create the actual workgroup file itself, setting the administrative issues within it ENTIRELY IN CODE......is th


WorkGroup Info File -
Hi all, I was wondering if anyone knew a way to find out the name and path of the workgroup security file for a secured Access database in code. i.e. the user points to a secured database, is there any way for me to automatically find which workgroup file that database is using?


Accessing a secured Access 97database -
I have developed a client server database in Access 97 using. I wish to have a stand-alone VB 6 app, which checks to see if any records are overdue (every morning at 1 am). It then gets the name and email address together with other relevant information and generates emails and sends


using ADO with Secured Database -
Hello, I am trying to hook up an ado through DE to a secured access db, db was secured with the "user level security wizard". when I test connection of the ado it keeps telling me: "test connection failed because of an error in initializing provider. cannot start your


Data Control + Workgroup / System Database -
Hi, I've looked long and hard for information regarding this, but it seems that interfacing with MDW files isn't the most common thing, at least not with controls. What I want to do is have a data control, with a DBGrid bound to it, access my MS Access (97) database. The databas


Cannot start your application. The workgroup information file is missing or opened ex -
I get the following error message on trying to connect to my user-level secured mdb: "Cannot start your application. The workgroup information file is missing or opened exclusively by another user." My connection string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Sourc


Connecting to a password secured Access db -
Hi, is it possible to connect to an Access database wich is secured with a password? I'm using a DataEnvironment... Thanks a lot...


access 2k ---- ado ---- workgroup -
Hi, I am trying to connect to an access 2k db, using the workgroup, and ado. But I can't seem to do it. Can anyone help me pls? This is the connection string. It says the file doesn't exist or something has it exclusively open.... nothing has it open. <path> is the path


Opinion needed: Domain or Workgroup. -
Hi, We are replacing our NT4 web server with a win2K. The NT4 was setup in a workgroup, not a domain. Are there any pro's or con's to domains vs workgroups? The root webpage allows anonymous access. However there are secured pages that require the user to be setup as a user on t


Problems connecting to a password protected database -
Hi, I try to connect to a password secured database from VB but there is a problem. This is the code which I have: pconInters.ConnectionString = _ "Persist Security Info=False;" & _ "User ID=" & strUser & ";" & &qu


Access Workgroup file -
How can I change the workgroup file (mdw) (run time) in vb6? ex. dim AppAccess as new Access.Application AppAccess.opencurrentdatabase "C:\Employee.mdb" AppAccess.visible = true The employee file need to joint a workgroup file. I would like to specify the path o


Access security - wizard won't run -
I'm not able to run the user-level security wizard in my access database that is on a network, my username is in the admins group but the messagebox keeps telling me that I have to be a member of this group - I am! Why is this happening?! Also, I've created a new workgroup information


Connect VB to Foxpro table in Foxpro DB***RESOVED*** -
I would to knowm how do I use code to connect to a Foxpro Database. I can connect to Access Database but there seems to be a major difference between Access DB and Foxpro DB. That is connect data from foxpro DB to VB application. Can anybody please assist me. Thanks in advance, your


Open secured password MS access database -
Hi, Question1: If my MS access data is not secured by a password, I can use this code to open it: Data1.DatabaseName = App.path & "\MyParts.mdb" Now I set the MyParts.mdb to prompt a password to open it. Of course, that code above cannot open it any more. Que


Access 97 Workgroup Information file -
Can anyone tell me something about the workgroup info file in access 97, and what role it plays in multiuser database access. Thanks in advance.


How to Access Ms-Access WorkGroup tables using VB Code -
Hi This is Kishore, currently working on VB6.0 project, which is using MS-Access95 as Backend. I have one secured database, for which i want to change the login Password using VB Code/Script. Can anybody please guide me in this scenario. Regards, Kishore


Help! WorkGroup file in Access97 -
How can I change the workgroup file (mdw) (run time) in vb6? ex. dim AppAccess as new Access.Application AppAccess.opencurrentdatabase "C:\Employee.mdb" AppAccess.visible = true The employee file need to joint a workgroup file. I would like to specify the


User Groups in Access 97 to Access 2000 -
Hi, Someone create an access database file that consist of forms, tables, reports and so on in Access 97. He also created the user workgroup, so that only a few has administrative rights while the others have only "Users" rights. At least, I believe that is what he did.


Secured FTP -
Hey, I am trying to logon to a secured FTP site with the INET control, but I am not able to Put, Get or Delete. Does anyone know of third party Secured COM object I could use? I am trying SecuredFX but it doesn't allow me to delete file on the FTP server. TIA


What is the best way to store user names / passwords -
Hi! I am making a small application for checking whether email messages on the server have potential viruses. I've already made the email checking part, but I also have to login users so that they can check only their own messages. Most of our users don't even remember their POP3 pa


Convert Access DB -
I need to convert an Access 97 database that uses workgroup security file. I can not convert the database to 2K because it can not recognize any passwords, permissions. Can I just delete the system.mdw database and recreate another workgroup database? What is the proper way to acc


***RESOLVED***Tell VB which Workgroup file to use when opening Access Database 2000 -
Hello Out there How can I write a VB6 code to tell access 2000 which Workgroup file to use before opening the Database. I will really appreciate any VB code example or API that can help me to accomplish this task. You know, within access environment we use the shortcut command


DAO and WIF's -
Does Anyone know how to connect to an Access Database that has a Workgroup Information File, using DAO? The uname=;password= in the connect string only works for ODBC connections. I get a generic error message about No Installable ISAM when I try to connect to the database with a v


workgroup -
How to add,edit,select and delete users in access workgroup file from vb?


More Network Woes.... Damn XP -
Alright more networks woes from the inexperienced master here. lol I'm trying to get file sharing enabled on three XP machines. They are all part of the same workgroup and file sharing is enabled on all three machines but here are the problems: 1. Two of the machines can't view c


Connect to database file (.mdf) -
Wondering if this is possible.... Can I add a database file to my ASP.net project (.mdf), put my tables, stored procedures, etc. in it and connect directly to the .mdf file without the use of SQL server? Meaning similiar to how I would connect to an Access database? If so, what w


The workgroup information file is missing or -
Hi all, I use vb(ADO) connect to accsess but miss anounce: The workgroup information file is missing or opened exclusively by another user. I don't know how to solve, Please help me Thanks


Securing VB created Access DB... -
Hi, I have an VB app. which creates an Access .mdb file using the "CreateDatabase" command. Unfortunatley anyone can access this DB in access using the default admin workgroup. Is there anyway I can secure any DB's created within my app this way, to stop the DB from bei


Users in a workgroup -
I have created a Db that i am sharing over a network. The users need access to a workgroup that the database is part of. Is there any way that i can get the users set up in the workgroup, rather than going to each workstation and running the workadm.exe ?


Secured Database -
Can somebody tell me how to connect to a secured Access97 database with ADO please.


Ms Access Workgroup security -
I have a database which uses msAcess workgroup security.. Im tryin to make a program so that the workgroup can be administered without using access.. i can view, add, delete, edit users and groups... BUT how can i get the group of the current user who is logged in? I need to


Access 97 workgroup -
How can I connect a secure access database through ADO/Data Environment? Thanks!


Security of Access through VB -
hello friends, i am doing an appln on encryption. I am using Access as database. I want to keep the database secured i.e no user can see what's in the database, and in the coding i usually put and take the values in the database, So how c


Connection to Access db with Adodc -
Hello everyone, Is it possible to connect to password protected Access Database from Adodc? I have an Access db with both User level security and database password (both the passwords are same) I tried to connect to this db from a ADODC, providing the UserName and password in


Urgent - Gurus ;) **Resolved** -
Hi, I have a mdb (access 97) which I've been developing - and I'm going to upgrade to 2k. What happens if I forget to relink the tables from Access 97 ? I'm asking this 'cause I've just ran 2k and converted the front end (code etc - which worked beautifully considering its o


Accessing a password-protected .mdb file -
I am using an ADO data control object on my form to access the Microsoft Jet 4.0 OLE database engine. I have a database file in the application folder and I don't want anyone fiddling with it, so I want to password protect it. Easy enough, I use the security feature of Microsoft Acce


workgroup info file... -
im using ADO constantly in vb projects. when ever im debugging an app using ado and something goes wrong, i.e. error, crash, VB bombs my program out etc. then if i try and start it up again it says that the workgroup information file (for access) is missing... if i then save my p


Connect Secured MDB with Data Report -
hai i am trying to connect a password protected access database with Data Report. After setting all the properties and password in ADO if i click Test Connection. its giving an error. help me.


[2008] Connecting to Access Database that uses workgroups -
Hi all, So I downloaded the VB 2008 Express edition. My information is stored in a Access 2000 Database I'll call db1.mdb After I connect I can't seem to run queries, it says that I don't have read permissions. I think this is because my string doesn't contain my workgroup inform