Disable "Import Data" Option ?

[exipnakias]

Hello Guys.
I would like to know if there is a way [VB Code etc], which can prevent users to import data from an access database to another.

I have a database that I do not want users to be able to copy the data (tables, forms, reports, query, macros, modules etc) of this database to another one (using the import option of MS Access).

Thanks in advanced.

[exipnakias]

noone can help ? Noone knows ?

[Mai Le]

noone can help ? Noone knows ?

I don't think we have this option in Access database, but you can hide tables, forms... then nobody could import your data..
- right click on table, select properties, select hidden then ok.
is that help.

Mai Le

[missinglinq]

To hide objects you have to do as Mai Le said and you have to go to Options - Views and under Show make sure the Hidden Objects is unchecked.

Whether or not this will help you depends on who you're trying to protect your data from and how savvy they are, Access wise. The visibility of the hidden table depends on how the option I mentioned above is set up in the potential data thief's copy of Access! If he has Show Hidden Objects checked, the table will still be open to being imported.

The sad truth is that Access security is really geared towards preventing non-authorized users from changing the design of the database, not from retrieving data. The built in "security" features has in previous versions of Access has been so poor that Microsoft dropped them altogether with v2007.

As I said, Access security, like all security, really, depends on who you're trying to secure against. If it's someone outside of your organization, they are general, non-Access specific things that can be done to prevent the stealing your data. But if the person you're concerned about has legitimate access to your network and/or Access apps, and has any real working knowledge of Access, security of your data is probably thru Acces is not really possible.

I've never worked with SQL Server or those types of back ends, and there may be something, security-wise, that you could do with one of them. Maybe one of my fellow inmates here can help you with that.

Good luck and welcome to bytes!

Linq ;0)>

[PianoMan64]

To hide objects you have to do as Mai Le said and you have to go to Options - Views and under Show make sure the Hidden Objects is unchecked.

Whether or not this will help you depends on who you're trying to protect your data from and how savvy they are, Access wise. The visibility of the hidden table depends on how the option I mentioned above is set up in the potential data thief's copy of Access! If he has Show Hidden Objects checked, the table will still be open to being imported.

The sad truth is that Access security is really geared towards preventing non-authorized users from changing the design of the database, not from retrieving data. The built in "security" features has in previous versions of Access has been so poor that Microsoft dropped them altogether with v2007.

As I said, Access security, like all security, really, depends on who you're trying to secure against. If it's someone outside of your organization, they are general, non-Access specific things that can be done to prevent the stealing your data. But if the person you're concerned about has legitimate access to your network and/or Access apps, and has any real working knowledge of Access, security of your data is probably thru Acces is not really possible.

I've never worked with SQL Server or those types of back ends, and there may be something, security-wise, that you could do with one of them. Maybe one of my fellow inmates here can help you with that.

Good luck and welcome to bytes!

Linq ;0)>

The only way you're going to keep the data from being pulled is to put the data in some other backend besides MS Access. MS Access doesn't have any security that you can employ from securing the data, if someone knows how to access the database and has appropriate access to the MDB file where the data is housed.

You'll need to either go to MS SQL or Oracle as a backend. A great deal more security options available for you.

If you would like details, let me know, I have experince in both.

Joe P.

[exipnakias]

I don't think we have this option in Access database, but you can hide tables, forms... then nobody could import your data..
- right click on table, select properties, select hidden then ok.
is that help.

Mai Le

I can't find this "hidden" option.

[exipnakias]

To hide objects you have to do as Mai Le said and you have to go to Options - Views and under Show make sure the Hidden Objects is unchecked.

Whether or not this will help you depends on who you're trying to protect your data from and how savvy they are, Access wise. The visibility of the hidden table depends on how the option I mentioned above is set up in the potential data thief's copy of Access! If he has Show Hidden Objects checked, the table will still be open to being imported.

The sad truth is that Access security is really geared towards preventing non-authorized users from changing the design of the database, not from retrieving data. The built in "security" features has in previous versions of Access has been so poor that Microsoft dropped them altogether with v2007.

As I said, Access security, like all security, really, depends on who you're trying to secure against. If it's someone outside of your organization, they are general, non-Access specific things that can be done to prevent the stealing your data. But if the person you're concerned about has legitimate access to your network and/or Access apps, and has any real working knowledge of Access, security of your data is probably thru Acces is not really possible.

I've never worked with SQL Server or those types of back ends, and there may be something, security-wise, that you could do with one of them. Maybe one of my fellow inmates here can help you with that.

Good luck and welcome to bytes!

Linq ;0)>

I did not really understand how I am going to hide my data and how I will set the options. Can you be more clearly pls ?

[exipnakias]

The only way you're going to keep the data from being pulled is to put the data in some other backend besides MS Access. MS Access doesn't have any security that you can employ from securing the data, if someone knows how to access the database and has appropriate access to the MDB file where the data is housed.

You'll need to either go to MS SQL or Oracle as a backend. A great deal more security options available for you.

If you would like details, let me know, I have experince in both.

Joe P.

It is very difficult to re-build the whoel database in another database software which I do not actually know how it works.

[PianoMan64]

It is very difficult to re-build the whoel database in another database software which I do not actually know how it works.

Without being able to develope in another backend, then you're limited as to your options to secure your data.

MS Access doesn't support any kind of user security except for the User accounts that can be held in the MDW file when you're using the MDB or MDE format. This is not supported in ACCBD or ACCDE format.

I'm not sure how you would like to proceed at this point. I would be willing to help you with any questions you have about mirgating over to either oracle or MS Access.

Joe P.

[exipnakias]

Without being able to develope in another backend, then you're limited as to your options to secure your data.

MS Access doesn't support any kind of user security except for the User accounts that can be held in the MDW file when you're using the MDB or MDE format. This is not supported in ACCBD or ACCDE format.

I'm not sure how you would like to proceed at this point. I would be willing to help you with any questions you have about mirgating over to either oracle or MS Access.

Joe P.

I agree with you. But It has been mentioned that I can hide the objects so not to be visible. Is this possible and how ?

[pod]

Hello Guys.
I would like to know if there is a way [VB Code etc], which can prevent users to import data from an access database to another.

I have a database that I do not want users to be able to copy the data (tables, forms, reports, query, macros, modules etc) of this database to another one (using the import option of MS Access).

Thanks in advanced.

Not the best way but...
If you really want to secure your data, why don't you encrypt everything that goes into the database... this way anyone trying to retrieve the data will need your permission/key to decrypt it.

[exipnakias]

Not the best way but...
If you really want to secure your data, why don't you encrypt everything that goes into the database... this way anyone trying to retrieve the data will need your permission/key to decrypt it.

It's no use. This database is given to some persons for use and they know the encryption password. So they can import data into a new database anytime they want.

[lamonka]

you can use this cod in hidding tables or unhidden them
Public Sub hide_on()
Dim c As String
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentData
' Search for open AccessObject objects in AllTables collection.
For Each obj In dbs.AllTables
c = obj.Name
If c Like "MSys*" Then

Else

Application.SetHiddenAttribute acTable, c, True
End If
Next obj
MsgBox "hide_on"
End Sub
-------------------------------------------------------------------------------------------------
Public Sub hide_off()
Dim c As String
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentData
' Search for open AccessObject objects in AllTables collection.
For Each obj In dbs.AllTables
c = obj.Name
If c Like "MSys*" Then

Else

Application.SetHiddenAttribute acTable, c, False
End If
Next obj
MsgBox "hide_off"
End Sub