|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hi All,
Can anyone advise on this please.
I have a shred database with security. Database is shared between five
users, all except me have Access 2000, I have Access 2003. Database in an
Access 2000 format.
We keep getting corruptions where the Form page goes blank. Repair sometimes
brings the forms back visibly but they are still not accessible. The App and
Data are not split and I intend to do this asap when I have figured out how
to disable security!, but is there anything else I should be doing?
Regards.
Bill.
|
|
Hi,
you certainly have to split your application. And check network hardware -
bad hardware is a possible reason for frequent corruptions
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Bill" <bill[ at ]bill.com> wrote in message
news:%234gCujI3GHA.4484[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] > Hi All,
>
> Can anyone advise on this please.
>
> I have a shred database with security. Database is shared between five
> users, all except me have Access 2000, I have Access 2003. Database in an
> Access 2000 format.
>
> We keep getting corruptions where the Form page goes blank. Repair
> sometimes brings the forms back visibly but they are still not accessible.
> The App and Data are not split and I intend to do this asap when I have
> figured out how to disable security!, but is there anything else I should
> be doing?
>
> Regards.
> Bill.
>
|
|
"Bill" <bill[ at ]bill.com> wrote in message
news:%234gCujI3GHA.4484[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] > Hi All,
>
> Can anyone advise on this please.
>
> I have a shred database with security. Database is shared between five
> users, all except me have Access 2000, I have Access 2003. Database in an
> Access 2000 format.
>
> We keep getting corruptions where the Form page goes blank. Repair
> sometimes brings the forms back visibly but they are still not accessible.
> The App and Data are not split and I intend to do this asap when I have
> figured out how to disable security!, but is there anything else I should
> be doing?
>
> Regards.
> Bill.
>
Hi Bill.
The corruption is likely owing to the app not being split. I'm not sure why
you'd want to disable security in order to make the split, it isn't
necessary to do so ... or do you mean you can't get to the db window and
menus? Either way, don't just split it and share the front end, give each
user their own copy of it.
Regards,
Keith.
www.keithwilby.com
|
|
[Quoted Text] >
> Hi Bill.
>
> The corruption is likely owing to the app not being split. I'm not sure
> why you'd want to disable security in order to make the split, it isn't
> necessary to do so ... or do you mean you can't get to the db window and
> menus? Either way, don't just split it and share the front end, give each
> user their own copy of it.
>
> Regards,
> Keith.
> www.keithwilby.com
>
Keith,
The reason I want to disable security is pure ignorance on my part! I was
simply under the impression that it is a necessary precedent!!!
I accept what you are saying but don't quite understand where the security
would sit? Would it be on the front or backend or both?
Thanks for the help.
Bill.
|
|
"Bill" <bill[ at ]bill.com> wrote in message
news:eVzVBOJ3GHA.5024[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] >
> Keith,
>
> The reason I want to disable security is pure ignorance on my part! I was
> simply under the impression that it is a necessary precedent!!!
>
> I accept what you are saying but don't quite understand where the security
> would sit? Would it be on the front or backend or both?
>
It would be on both. All you need to do is split the app whilst you're
joined to your custom workgroup, that way you will still be the owner of
both files and all objects contained. The easiest way IMO would be to make
a copy of your file and delete all objects except the tables - that is your
BE. On the other copy of the file, delete all tables and then link to your
BE file - job done! Be sure to have a backup just in case though.
Regards,
Keith.
|
|
[Quoted Text] >
> It would be on both. All you need to do is split the app whilst you're
> joined to your custom workgroup, that way you will still be the owner of
> both files and all objects contained. The easiest way IMO would be to
> make a copy of your file and delete all objects except the tables - that
> is your BE. On the other copy of the file, delete all tables and then
> link to your BE file - job done! Be sure to have a backup just in case
> though.
>
> Regards,
> Keith.
>
Ok - here goes!!!!!!
Watch this space!!!!
|
|
|
[Quoted Text] >>
>
> It would be on both. All you need to do is split the app whilst you're
> joined to your custom workgroup, that way you will still be the owner of
> both files and all objects contained. The easiest way IMO would be to
> make a copy of your file and delete all objects except the tables - that
> is your BE. On the other copy of the file, delete all tables and then
> link to your BE file - job done! Be sure to have a backup just in case
> though.
>
> Regards,
> Keith.
>
Ok, have done that using the database splitter wizard and now have a second
mdb database appended _BE.
All is working fine but there is not security on the _BE mdb file. I can
double click it and go straight in.
When using the original batch file (which points at the original file) there
is security.
What do I need to do to get security on the _BE file too?
Thanks for sticking with this.
Bill.
|
|
"Bill" <bill[ at ]bill.com> wrote in message
news:ezGnD$J3GHA.1060[ at ]TK2MSFTNGP04.phx.gbl...
[Quoted Text] >>>
>>
>> It would be on both. All you need to do is split the app whilst you're
>> joined to your custom workgroup, that way you will still be the owner of
>> both files and all objects contained. The easiest way IMO would be to
>> make a copy of your file and delete all objects except the tables - that
>> is your BE. On the other copy of the file, delete all tables and then
>> link to your BE file - job done! Be sure to have a backup just in case
>> though.
>>
>> Regards,
>> Keith.
>>
> Ok, have done that using the database splitter wizard and now have a
> second mdb database appended _BE.
>
> All is working fine but there is not security on the _BE mdb file. I can
> double click it and go straight in.
>
> When using the original batch file (which points at the original file)
> there is security.
>
> What do I need to do to get security on the _BE file too?
>
> Thanks for sticking with this.
> Bill.
>
I've never used the wizard Bill so I don't know, sorry. If your original
unsplit file has security on it then using the method I described earlier
would cause the new file to inherit that security.
Regards,
Keith.
|
|
Bill,
if you open original file by double-clicking on it - will access ask for
user/password?
anyway - here security FAQ which can help you to make database secure
http://support.microsoft.com/kb/207793/en-us
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Bill" <bill[ at ]bill.com> wrote in message
news:ezGnD$J3GHA.1060[ at ]TK2MSFTNGP04.phx.gbl...
[Quoted Text] >>>
>>
>> It would be on both. All you need to do is split the app whilst you're
>> joined to your custom workgroup, that way you will still be the owner of
>> both files and all objects contained. The easiest way IMO would be to
>> make a copy of your file and delete all objects except the tables - that
>> is your BE. On the other copy of the file, delete all tables and then
>> link to your BE file - job done! Be sure to have a backup just in case
>> though.
>>
>> Regards,
>> Keith.
>>
> Ok, have done that using the database splitter wizard and now have a
> second mdb database appended _BE.
>
> All is working fine but there is not security on the _BE mdb file. I can
> double click it and go straight in.
>
> When using the original batch file (which points at the original file)
> there is security.
>
> What do I need to do to get security on the _BE file too?
>
> Thanks for sticking with this.
> Bill.
>
|
|
Bill wrote:
[Quoted Text] >> It would be on both. All you need to do is split the app whilst
>> you're joined to your custom workgroup, that way you will still be
>> the owner of both files and all objects contained. The easiest way
>> IMO would be to make a copy of your file and delete all objects
>> except the tables - that is your BE. On the other copy of the file,
>> delete all tables and then link to your BE file - job done! Be sure
>> to have a backup just in case though.
>>
>> Regards,
>> Keith.
>>
> Ok, have done that using the database splitter wizard and now have a
> second mdb database appended _BE.
>
> All is working fine but there is not security on the _BE mdb file. I
> can double click it and go straight in.
>
> When using the original batch file (which points at the original
> file) there is security.
>
> What do I need to do to get security on the _BE file too?
>
> Thanks for sticking with this.
> Bill.
The splitting wizard always results in an unsecured back end. If you had
split manually as suggested then both files would be secured.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
|
As others have said, the splitter wizard always results in an unsecure
backend.
To Fix: Open the secure frontend, logging in as a user that's member of the
Admins Group. (this will ensure that you are using the correct mdw file).
Hit Ctrl-N and create a new mdb. File, Get External Data, and import all
the objects from the current backend file you have. This ensures that the
owner of these objects and the mdb are owned by the username you are logged
in as. Now go to Tools, Security, Permissions and remove all permissions
for all objects for the Users Group and the Admin User. Then assign any
necessary permissions for the groups that you created. (likely open
permission on the database; if you used RWOP queries in the frontend, then
users don't need any permissions on the tables, otherwise they do.
--
Joan Wild
Microsoft Access MVP
Bill wrote:
[Quoted Text] >> It would be on both. All you need to do is split the app whilst
>> you're joined to your custom workgroup, that way you will still be
>> the owner of both files and all objects contained. The easiest way
>> IMO would be to make a copy of your file and delete all objects
>> except the tables - that is your BE. On the other copy of the file,
>> delete all tables and then link to your BE file - job done! Be sure
>> to have a backup just in case though.
>>
>> Regards,
>> Keith.
>>
> Ok, have done that using the database splitter wizard and now have a
> second mdb database appended _BE.
>
> All is working fine but there is not security on the _BE mdb file. I
> can double click it and go straight in.
>
> When using the original batch file (which points at the original
> file) there is security.
>
> What do I need to do to get security on the _BE file too?
>
> Thanks for sticking with this.
> Bill.
|
|
And that's the fix for my error.
Many Thanks.
Bill.
"Joan Wild" <jwild[ at ]nospamtyenet.com> wrote in message
news:%23TFtLBl3GHA.4632[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] > As others have said, the splitter wizard always results in an unsecure
> backend.
>
> To Fix: Open the secure frontend, logging in as a user that's member of
the
> Admins Group. (this will ensure that you are using the correct mdw file).
>
> Hit Ctrl-N and create a new mdb. File, Get External Data, and import all
> the objects from the current backend file you have. This ensures that the
> owner of these objects and the mdb are owned by the username you are
logged
> in as. Now go to Tools, Security, Permissions and remove all permissions
> for all objects for the Users Group and the Admin User. Then assign any
> necessary permissions for the groups that you created. (likely open
> permission on the database; if you used RWOP queries in the frontend, then
> users don't need any permissions on the tables, otherwise they do.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Bill wrote:
> >> It would be on both. All you need to do is split the app whilst
> >> you're joined to your custom workgroup, that way you will still be
> >> the owner of both files and all objects contained. The easiest way
> >> IMO would be to make a copy of your file and delete all objects
> >> except the tables - that is your BE. On the other copy of the file,
> >> delete all tables and then link to your BE file - job done! Be sure
> >> to have a backup just in case though.
> >>
> >> Regards,
> >> Keith.
> >>
> > Ok, have done that using the database splitter wizard and now have a
> > second mdb database appended _BE.
> >
> > All is working fine but there is not security on the _BE mdb file. I
> > can double click it and go straight in.
> >
> > When using the original batch file (which points at the original
> > file) there is security.
> >
> > What do I need to do to get security on the _BE file too?
> >
> > Thanks for sticking with this.
> > Bill.
>
>
|
|
|