remove all security

[Jpaul]

I'm working with a 2003 database and have admin rights. How do I completely remove all security?
I want to import/export with the database but it want let me.
Thansks

[jmcilhinney]

Are you saying, without actually saying, that it's Access 2003? Exactly what security restrictions are you encountering?

[Jpaul]

When I try to import with a database from the 2003 database, I'm getting "no authorization". I understand why, because in the access the database you have to have user rights.
So, (in my copy folder where I'm working with a copy of the database), I want to completely remove all security.
The security it uses is the access mdw file.
Thanks

[jmcilhinney]

The security it uses is the access mdw file.

That is the important bit of information that you should have provided in the first place.

[Jpaul]

Well......, Not sure about that, The original post mentioned the export/import problem. Which security
wasn't allowing. What I really want to know is how do I completely remove the security.

[GRichG]

Do a Google search for getting past security in an mdb. There are tools out there, some free.

[dotanhensenson]

Database security is important to secure your data from unauthorized user. Cybersecurity is the protection of internet-connected systems such as hardware, software and data from cyber-threats. Please check this website for more detail.

[FunkyDexter]

Link removed as it smacked of advertising. Also, there's really no need to dig up 2 year old threads. Please try to avoid doing that unless you're going to add something highly pertinent to the discussion.

[Prahlad]

Remove security follow this link
"https://support.microsoft.com/en-in/help/290991/how-to-manually-remove-sql-server-2000-default-named-or-virtual-instan"

Import/Export
Right click the database itself, Tasks -> Generate Scripts...

Then follow the wizard.

For SSMS2008+, if you want to also export the data, on the "Set Scripting Options" step, select the "Advanced" button and change "Types of data to script" from "Schema Only" to "Data Only" or "Schema and Data".