Visual Basic&database, Using Access 'Security' from VB

Using Access 'Security' from VB

Author	Message
David Barret #1 / 3	Using Access 'Security' from VB Sorry if this has been covered before, but I am having some trouble getting the Access database security scheme to work from VB. I have a database (mdb) file and a workgroups information file (dbw) on an NT server with read/write permissions (at this stage). I am accessing the data from VB using both DAO objects (for use within the code) and data controls (for spiffy DBGrid boxes etc). Previously, I had the database unsecured, but now that it is secured I get an error to the effect that it either can't find the .mdw file or it is locked. This happens when I try to opena a workspace with CreateWorkspace. It doesn' t appear to be locked (no .ldb file) and is in the place the relevent registry key specifies. Can anyone think of a good reason why it won't read the wretched thing? Thanks in advance. David Barrett
Sun, 13 Aug 2000 03:00:00 GMT

Josi #2 / 3	Using Access 'Security' from VB Quote: >This >happens when I try to opena a workspace with CreateWorkspace. It >doesn' t appear to be locked (no .ldb file) and is in the place the >relevent >registry key specifies. Can anyone think of a good reason why it won't >read the wretched thing? Thanks in advance. ---------------------------------------------------------------------------- ---------------------------------- What is exact text of the error? Because I have had prety same troubles. I just couldn't get to work VB with Access secured databases. Everything worked fine while I was programming at home, but when I installed application on users comp it wouldn't open the database. Guess how I solved the problem? I've installed VB on the users computer. Josip
Mon, 14 Aug 2000 03:00:00 GMT

Thomas Grabl #3 / 3	Using Access 'Security' from VB Have you tryed setting the DAO.SystemDB to the path and filename of your workgroup information file? Quote: > Sorry if this has been covered before, but I am having some trouble > getting the Access database security scheme to work from VB. I > have a database (mdb) file and a workgroups information file (dbw) > on an NT server with read/write permissions (at this stage). I am > accessing the data from VB using both DAO objects (for use within > the code) and data controls (for spiffy DBGrid boxes etc). Previously, > I had the database unsecured, but now that it is secured I get an error > to the effect that it either can't find the .mdw file or it is locked. > This > happens when I try to opena a workspace with CreateWorkspace. It > doesn' t appear to be locked (no .ldb file) and is in the place the > relevent > registry key specifies. Can anyone think of a good reason why it won't > read the wretched thing? Thanks in advance. > David Barrett
Sun, 20 Aug 2000 03:00:00 GMT

Page 1 of 1

[ 3 post ]