Backend

[LEE hepworth]

Hi all
Have a database on the backend. Front end has a password which are linked to this backend. Have disabled the shift key for the back end and all short cut keys.
just wanted to know if adding a password to the back end would this prevent access from the fron end or would they get asked for a password for each new entry .
Also users can link to the back end how do I prevent this as they can change the data this way
Using access 97
Ta

 

[bsdixon]

I get the following error message when I try and use the database splitter.

"subscript out of range"

Does anyone know what the problem is and what I need to do to fix it?

Thanks.

 

[bsdixon]

Has anyone gotten this error message?

How do I get around it so that I can create a back end?

Thanks for the help!

 

[bsdixon]

I am still getting the same error message as above. When I spit the database, I get a back end file that just contains the tables.

A front end table is not created. The original file just remains with all of the forms, tables, and queries.

How do I create the front end?

Thanks in advance for the help.

Brad