Disable import of an Access .accdb (1 Viewer)

C

ct2013

Registered User.

Local time

Today, 19:29

Joined

Jun 6, 2013

Messages

87

• Jul 4, 2013

• #1

Hi,

I have a .accdb with security where ihave hidden navigation pane and toolbars...

Now left with one more thing, is it possible to disable anyone trying to import stuff from my database?

Maybe some code or is there a setting somewhere in current db?

Ta

 

B

billmeye

Access Aficionado

Local time

Today, 14:29

Joined

Feb 20, 2010

Messages

542

• Jul 5, 2013

• #2

Password protect the DB.

 

C

ct2013

Registered User.

Local time

Today, 19:29

Joined

Jun 6, 2013

Messages

87

• Jul 5, 2013

• #3

Thanks for reply, but i have users using it the whole time and that isnt an option.

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 19:29

Joined

Feb 19, 2013

Messages

16,606

• Jul 5, 2013

• #4

Don't link your tables in the FE so they cannot be seen. Password protect the back end and use recordsets to populate your forms and reports - ensure your front end is converted to ACCDE so users cannot read the vba.

This link may assist

http://support.microsoft.com/kb/209953

Note: all queries will need to be built in code rather than the query builder otherwise users can open a query and read the password

 

C

ct2013

Registered User.

Local time

Today, 19:29

Joined

Jun 6, 2013

Messages

87

• Jul 5, 2013

• #5

I have already linked the tables, i would prefer not to make it .accde and i have all hidden in .accdb with codes to block navigation panes and edit and toolbars...

will read that link later.

Ta

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 19:29

Joined

Feb 19, 2013

Messages

16,606

• Jul 5, 2013

• #6

at the moment there is nothing to stop a user opening a new access project and linking to your back end - unless you password protect the back end, which is what my suggestion does