473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Disabling Import/Linking

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
Nov 13 '05 #1
3 1883
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
"inquisitive" 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).OpenDatabase(SystemDB)
Set c = d.Containers!Databases
c.UserName = "Users"
c.Permissions = c.Permissions And Not dbSecDBCreate

End Function

TIA,

Mark

"Mark" <ma*********@ntlworld.com> wrote in message
news:XC*************@newsfe3-win.ntli.net...
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

Nov 13 '05 #2
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" <ma*********@ntlworld.com> wrote in message
news:iz************@newsfe2-gui.ntli.net...
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 "inquisitive" 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).OpenDatabase(SystemDB)
Set c = d.Containers!Databases
c.UserName = "Users"
c.Permissions = c.Permissions And Not dbSecDBCreate

End Function

TIA,

Mark

"Mark" <ma*********@ntlworld.com> wrote in message
news:XC*************@newsfe3-win.ntli.net...
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


Nov 13 '05 #3
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" <ma********@nospam.com> wrote in message
news:6D*****************@newsread3.news.atl.earthl ink.net...
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" <ma*********@ntlworld.com> wrote in message
news:iz************@newsfe2-gui.ntli.net...
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
"inquisitive" 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).OpenDatabase(SystemDB)
Set c = d.Containers!Databases
c.UserName = "Users"
c.Permissions = c.Permissions And Not dbSecDBCreate

End Function

TIA,

Mark

"Mark" <ma*********@ntlworld.com> wrote in message
news:XC*************@newsfe3-win.ntli.net...
> 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
>
>



Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Vio | last post by:
Hi, I've been trying to embed (statically) wxPy alongside an embedded py interpreter on a linux/gtk box. At one point, for some reason misc.o linking reported "multiple definitions of...
0
by: Adrian Holovaty | last post by:
Hi, everybody, How can I go about writing an import hook that shows or hides (i.e., does not allow import of) modules within a package based on a defined setting? Here's a basic example of...
2
by: Torsten Mohr | last post by:
Hi, is there some description available to overwrite the import hook? By googling i found out so far that i need to overwrite __builtins__.__import__ with something else. Can i also do this...
4
by: Steve Jorgensen | last post by:
I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not...
3
by: Trev | last post by:
Is there a way to create/manipulate import specs in VBA?
8
by: Nick M | last post by:
Hello All, Excellent info here Thanks! I am very new to using access in general and I am on a learning curve. I'm trying to import an excel workbook (with worksheets) into an access db via a...
2
by: veaux | last post by:
Peeked around here but didn't really see an explanation as to the varied "Invalid Argument" errors that appear in Access sometimes. I'm using Access 2003 and trying to import an Access table of...
5
by: kuratkull | last post by:
Hello, *************** import urllib2 import re import string import sys url = "http://www.macgyver.com/" request = urllib2.Request(url)
3
by: Koen Vossen | last post by:
A project I'm currently working on uses Turbogears as a framework. I'd like to interact with it using the tg-admin shell. We also use gettext's _() function for internationalization. Now, this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.