Restrict Opening of Forms

[Declan]

Hi all.

Is there a way to make forms un-openable? I've managed to get rid of the close button on each form already, but I don't want ANY user to be able to double click the form on the side and be able to open it.

I've made 1 form open the moment the database is opened, and wanted to use boxes combined with macros to let the user go through the database via forms. So, is there a way to not let any user open a form unless directed through a macro?

Thanks guys,
Declan
--
one more question, can someone explain what splitting the database actually means, and how to do it? I've tried researching but didn't really get it. :banghead:

 

[CJ_London]

can someone explain what splitting the database actually means

database is split into front end (FE) and backend (BE).

BE contains only tables, nothing else, and placed on the network server where all users can read/write privileges.

FE contains everything else (forms, reports, queries, code) and linked to the backend. Each user has their own copy on their own machine.

how to do it

use the database splitter function provided by access or to do it yourself, open a new db as your backend, copy all tables into it. Then in your front end, deleted all the tables and then using the link manager to link to the backend.

Before you do this, take a copy in case you mess up.

Failure to split a db in a multiuser environment will almost certainly result in corruption at some point, plus make updating with improvements/bug fixes almost impossible.