Currently securing mdbs with .mdw and secure routine in ACCESS. Would like to move this routine to VB 6.0 which currently creates a new mdb and runs the
queries in the mdb using openschema,tabledefs, .fields but have not found the
way to SECURE the mdb. Everything I read says the only way it can be done is
through ACCESS. I have tried with VB 6.0 and am having no luck. Any
suggestions?
.
Re: Security not clicking ... Have you searched for all *.mdw files and renamed them? ... backup of your unsecure mdb.... Rename it to have a mdb extension - that should be your unsecure... Copy the secure mdw to the server. ... (microsoft.public.access.security)
Re: Security not clicking ... I have a single unsecured mdb file....Joan Wild wrote: ... Have you searched for all *.mdw files and renamed them? ... Rename it to have a mdb extension - that should be your unsecure... (microsoft.public.access.security)
Re: Advance Security Issue Part II ... discovered the dual mdw thing. ... >> The mdb contains the db objects, the object/SID relationships, and the SID ... The owner of the query is stored in the MSysObjects ... (microsoft.public.access.security)
Re: MDB remembers old MDW ... There were 2 reasons that I thought that the mdb had a link to the mdw:... When you looked at the Workgroup Administrator dialog it displayed ...Group permissions the old groups from 'Security.mdw' were displayed. ... (microsoft.public.access.security)
Re: MDB remembers old MDW ... There were 2 reasons that I thought that the mdb had a link to the mdw:...Group permissions the old groups from 'Security.mdw' were displayed. ... migrating all of our back-end databases to SQL Server 2005. ... (microsoft.public.access.security)
