Split database

[reynier09]

Hi, I'm trying to split my database so just to give access to the FE to the users. I'm new to Access and I thought that by doing this they won't be able to modify the data that is in the tables in the BE, but I was wrong. I also made the FE ACCDE but I can still modify the data in FE. Is there a way to restrict my users in the FE so they can't modify the data in the tables. Thanks.

[CJ_London]

I presume you mean they can see the tables and change data directly in the table rather than through a form.

If so, there are various levels you can go to depending on how seriously you consider you need to take this

At the simplest level, hide the navigation pane
At the most sophisticated level, use sql server (or express) as the back end

in between, you can hide the ribbon, disable bypass keys, hide the tables, all of which can be relatively easily reversed by a half way sophisticated user.

There are also all sorts of things you can do using queries and/or vba so you don't need to show linked tables

If on the other hand you mean users can only view data and not make changes - i.e. readonly, go to the backend in explorer and set to readonly - again can be overcome by a knowledgeable user

[reynier09]

They don't even need to see the tables in the FE honestly. SQL is going to be my future goal but for now I just want them to use the FE and not being able to modify the data on the tables. As you say some of the changes can be reversed by a willing user but I'm not too worried about that so far. So...

how do I go about not showing the linked tables. ( I just deleted the tables in the FE, but now the queries, forms and reports won't work. If I go to the linked table manager is not available.) Is there a way to keep them in the BE and not showing up in the FE while working. I mean I have that now but is not working after deleting them from the FE.

Also, if I make the BE read-only how would I input data? Thanks

[CJ_London]

how do I go about not showing the linked tables

As I suggested, easiest way is hide the navigation pane and ribbon (File>Options>Current Database then untick display navigation pane and click OK). You might also want to click on the Navigation Options button and modify the display options.

To hide the ribbon, see links on this link http://stackoverflow.com/questions/1...-ribbon-onload

To disable bypass keys, see this link http://www.databasedev.co.uk/disable_shift_bypass.html. Be sure to have a means to renable the bypass otherwise you will not be able to access the db as a developer - make sure you have a backup before testing.

If you want the (much) more complex vba solution it will probably require you to rewrite the application, it is one of those things you build in from the beginning.

Also, if I make the BE read-only how would I input data? Thanks

wasn't sure from your post whether users could make changes through forms. (I have a number of dbs where the data is static from the users perspective - catalogues for example.) Doesn't sound like this is relevant in this case.

[reynier09]

Only one use will need to input/modify the data in the tables(me). The other users just use reports, forms and/or run queries. I will use your suggestions but was really trying to complete hide the tables in the FE so those users can't modify the data. Thanks

[CJ_London]

if only you need to change data then get onto IT, have them set users to only have read only access to the back end and you to have full access.

The other options in my last post will effectively hide the tables and all the other objects. If your users need to write their own queries then they can just as easily write an update, append or delete query to modify the data.

Also found this link on the same subject. Relates to mdb's but the principles stand with the exception of jet security (which was abandoned in 2007).

https://bytes.com/topic/access/answe...able-read-only