Disabling Import/Linking

**Mark** · Nov 13 '05, 03:06 AM

Re: Disabling Import/Linking

Hi All,
After countless hours of searching, I think I have found a solution to
my problem from the Microsoft site (
http://support.microsoft.com/?kbid=210329 ). What is suggested is that I
disable the ability to create a new database when using my workgroup. As the
"inquisitiv e" person needs to create the database from within my workgroup
to have permission to import, this seems like the perfect solution.
However, my programming skills are still in their infant stages and the
function provided by Microsoft does not work!!!!! The code below throws up
the following error message when I try to run it: Compile error:
User-defined type not defined.

Could anyone please help me rectify this problem??

Function Remove_DBCreate ()

Dim d As DAO.Database, c As Container, SystemDB As String
SystemDB = "C:\Program Files\Microsoft Office\" & _
"Office\System. mdw" ' Use path for your system.
Set d = DBEngine(0).Ope nDatabase(Syste mDB)
Set c = d.Containers!Da tabases
c.UserName = "Users"
c.Permissions = c.Permissions And Not dbSecDBCreate

End Function

TIA,

Mark

"Mark" <mark.reed75@nt lworld.com> wrote in message
news:XChZc.49$5 J1.46@newsfe3-win.ntli.net...[color=blue]
> Hi All,
>
> Firstly, I am aware from reading previous posts that if someone is
> determined enough, they will crack an Access Application. However, this
> problem seems basic but I can't find a workaround.
>
> I have a frontend/backend database at work which contains some
> sensitive information. I have used Access security along with my own and
> have disabled the shift key at start-up. I thought this was quite secure
> but I have found that someone has hacked into it and given themselves
> administrator privileges within my own security. After a lot of
> investigation, I have found out that they have done this by creating a
> new database under my workgroup and then importing the tables from the
> frontend. They can then open up any table they please and have
> visibility of everything due to no form being set to start-up..
>
> I have changed the way my security works by splitting the user table
> down so that the permissions given to each user is split from their
> passwords which they can change and given them only read permissions.
>
> What I want to be able to do is stop people being able to import/link
> from either the FE or BE unless they are the administrator. I have spent
> hours looking through the help files but can't see any reference to
> this.
>
> I am using Access 2002 SP2 on a XP platform.
>
> TIA
>
>[/color]

**MacDermott** · Nov 13 '05, 03:06 AM

Re: Disabling Import/Linking

Do you have a reference to DAO?
From a code window, click Tools - References.
In the box that comes up, check Microsoft DAO Library.
Be sure to exit by using the OK button.

HTH

"Mark" <mark.reed75@nt lworld.com> wrote in message
news:izzZc.23$P M3.9@newsfe2-gui.ntli.net...[color=blue]
> Hi All,
> After countless hours of searching, I think I have found a solution to
> my problem from the Microsoft site (
> http://support.microsoft.com/?kbid=210329 ). What is suggested is that I
> disable the ability to create a new database when using my workgroup. As[/color]
the[color=blue]
> "inquisitiv e" person needs to create the database from within my workgroup
> to have permission to import, this seems like the perfect solution.
> However, my programming skills are still in their infant stages and[/color]
the[color=blue]
> function provided by Microsoft does not work!!!!! The code below throws up
> the following error message when I try to run it: Compile error:
> User-defined type not defined.
>
> Could anyone please help me rectify this problem??
>
> Function Remove_DBCreate ()
>
> Dim d As DAO.Database, c As Container, SystemDB As String
> SystemDB = "C:\Program Files\Microsoft Office\" & _
> "Office\System. mdw" ' Use path for your system.
> Set d = DBEngine(0).Ope nDatabase(Syste mDB)
> Set c = d.Containers!Da tabases
> c.UserName = "Users"
> c.Permissions = c.Permissions And Not dbSecDBCreate
>
> End Function
>
> TIA,
>
> Mark
>
> "Mark" <mark.reed75@nt lworld.com> wrote in message
> news:XChZc.49$5 J1.46@newsfe3-win.ntli.net...[color=green]
> > Hi All,
> >
> > Firstly, I am aware from reading previous posts that if someone is
> > determined enough, they will crack an Access Application. However, this
> > problem seems basic but I can't find a workaround.
> >
> > I have a frontend/backend database at work which contains some
> > sensitive information. I have used Access security along with my own and
> > have disabled the shift key at start-up. I thought this was quite secure
> > but I have found that someone has hacked into it and given themselves
> > administrator privileges within my own security. After a lot of
> > investigation, I have found out that they have done this by creating a
> > new database under my workgroup and then importing the tables from the
> > frontend. They can then open up any table they please and have
> > visibility of everything due to no form being set to start-up..
> >
> > I have changed the way my security works by splitting the user table
> > down so that the permissions given to each user is split from their
> > passwords which they can change and given them only read permissions.
> >
> > What I want to be able to do is stop people being able to import/link
> > from either the FE or BE unless they are the administrator. I have spent
> > hours looking through the help files but can't see any reference to
> > this.
> >
> > I am using Access 2002 SP2 on a XP platform.
> >
> > TIA
> >
> >[/color]
>
>[/color]

**Mark** · Nov 13 '05, 03:06 AM

Re: Disabling Import/Linking

Really simple when you know how isn't it? Thanks very much for your help.
The code runs now and I have achieved what I wanted.

Cheers,

Mark

"MacDermott " <macdermott@nos pam.com> wrote in message
news:6DCZc.1911 $Wv5.1119@newsr ead3.news.atl.e arthlink.net...[color=blue]
> Do you have a reference to DAO?
> From a code window, click Tools - References.
> In the box that comes up, check Microsoft DAO Library.
> Be sure to exit by using the OK button.
>
> HTH
>
> "Mark" <mark.reed75@nt lworld.com> wrote in message
> news:izzZc.23$P M3.9@newsfe2-gui.ntli.net...[color=green]
>> Hi All,
>> After countless hours of searching, I think I have found a solution
>> to
>> my problem from the Microsoft site (
>> http://support.microsoft.com/?kbid=210329 ). What is suggested is that I
>> disable the ability to create a new database when using my workgroup. As[/color]
> the[color=green]
>> "inquisitiv e" person needs to create the database from within my
>> workgroup
>> to have permission to import, this seems like the perfect solution.
>> However, my programming skills are still in their infant stages and[/color]
> the[color=green]
>> function provided by Microsoft does not work!!!!! The code below throws
>> up
>> the following error message when I try to run it: Compile error:
>> User-defined type not defined.
>>
>> Could anyone please help me rectify this problem??
>>
>> Function Remove_DBCreate ()
>>
>> Dim d As DAO.Database, c As Container, SystemDB As String
>> SystemDB = "C:\Program Files\Microsoft Office\" & _
>> "Office\System. mdw" ' Use path for your system.
>> Set d = DBEngine(0).Ope nDatabase(Syste mDB)
>> Set c = d.Containers!Da tabases
>> c.UserName = "Users"
>> c.Permissions = c.Permissions And Not dbSecDBCreate
>>
>> End Function
>>
>> TIA,
>>
>> Mark
>>
>> "Mark" <mark.reed75@nt lworld.com> wrote in message
>> news:XChZc.49$5 J1.46@newsfe3-win.ntli.net...[color=darkred]
>> > Hi All,
>> >
>> > Firstly, I am aware from reading previous posts that if someone is
>> > determined enough, they will crack an Access Application. However, this
>> > problem seems basic but I can't find a workaround.
>> >
>> > I have a frontend/backend database at work which contains some
>> > sensitive information. I have used Access security along with my own
>> > and
>> > have disabled the shift key at start-up. I thought this was quite
>> > secure
>> > but I have found that someone has hacked into it and given themselves
>> > administrator privileges within my own security. After a lot of
>> > investigation, I have found out that they have done this by creating a
>> > new database under my workgroup and then importing the tables from the
>> > frontend. They can then open up any table they please and have
>> > visibility of everything due to no form being set to start-up..
>> >
>> > I have changed the way my security works by splitting the user table
>> > down so that the permissions given to each user is split from their
>> > passwords which they can change and given them only read permissions.
>> >
>> > What I want to be able to do is stop people being able to import/link
>> > from either the FE or BE unless they are the administrator. I have
>> > spent
>> > hours looking through the help files but can't see any reference to
>> > this.
>> >
>> > I am using Access 2002 SP2 on a XP platform.
>> >
>> > TIA
>> >
>> >[/color]
>>
>>[/color]
>
>[/color]

Disabling Import/Linking

Disabling Import/Linking

Comment

Comment

Comment