Users not able to access the back end of DB

[rkaria]

Hi

I have an Access 03 database that is centrally on the server, I then put a short cut link on users desktop to the database.

I would like to know how to not let users have access to the back end of the database, users have been going in and altering tables etc, I only would like them to see the forms. Is there a way to do this with out creating user logins? At the moment they only log onto the computer through the network. They dont have user logins for the actually database.

Thanks
Rkaria

 

[dbDamo]

Doesn't sound like you have split your Database. Your back end should contain Tables only - all forms, queries, macros etc should be in the front end with the tables linked to the back end. You can then password protect the back end meaning users cannot play around with table design

 

[rkaria]

Doesn't sound like you have split your Database. Your back end should contain Tables only - all forms, queries, macros etc should be in the front end with the tables linked to the back end. You can then password protect the back end meaning users cannot play around with table design

Thanks Damo, how do I split it?

 

[dbDamo]

Create a new blank Database and import all of your tables into it. Password protect this Database - this is your back end.

Now create another new blank Database and import all of your queries, forms, macros and modules. Then use the linked table manager to link to the tables in your backend - you will be prompted to enter the password you have set. This will be your front end.

There is an option in Access somewhere which will perform the split for you, but I have always done it manually.

 

[rkaria]

Create a new blank Database and import all of your tables into it. Password protect this Database - this is your back end.

Now create another new blank Database and import all of your queries, forms, macros and modules. Then use the linked table manager to link to the tables in your backend - you will be prompted to enter the password you have set. This will be your front end.

There is an option in Access somewhere which will perform the split for you, but I have always done it manually.

Thanks, I have tried exactly what you have suggested, and it does work but when i run the reports, it comes up with pop up box for every field in the query that the report relates to. Woud youi know why?
Thanks

 

[dbDamo]

What happens when you run the query directly?

 

[rkaria]

Thanks, I have tried exactly what you have suggested, and it does work but when i run the reports, it comes up with pop up box for every field in the query that the report relates to. Woud youi know why?
Thanks

Sorry I also forgot to mention, even though the users open the front end they can still see the reports, queires etc, and delete or alter the reports. Even though i have password protected the back end????

 

[dbDamo]

Then hide the Database window and distribute an .mde file - http://eu.dummies.com/WileyCDA/how-to/content/securing-your-access-2003-database-as-an-mde-file.html

And what happens when you run that query directly? Do you still get prompted to enter parameters?

 

[rkaria]

Then hide the Database window and distribute an .mde file - http://eu.dummies.com/WileyCDA/how-to/content/securing-your-access-2003-database-as-an-mde-file.html

And what happens when you run that query directly? Do you still get prompted to enter parameters?

Thanks, when i run the querie direct it prompt for the dates thats in the queury which is correct then at the bottom the progess bar runs the query but then crashes the whole database. I have resolved this issue now, as I have used the database splitter and all is working fine.

I will try to hide the database window.
thanks alot for your help on this.
R

 

[dbDamo]

If you base your report on a parameter query then you will be prompted to enter the parameters when the report is produced, just as you would when running the query.

To hide the Database window in A2000 you go to Tools>Startup and uncheck the Display Database window option.

Feel free to ask any more questions.

 

[rkaria]

If you base your report on a parameter query then you will be prompted to enter the parameters when the report is produced, just as you would when running the query.

To hide the Database window in A2000 you go to Tools>Startup and uncheck the Display Database window option.

Feel free to ask any more questions.

Hey
It should have only been the date parameters that appear, when i was running the report it was asking for a parameter for every field in the qury even though only the dates had parameters in the query!!?? bizarre but like i said that is sorted now as i used the database splitter tool.

I just tried to create an mde file but it wont allow as the database is in 2000 format, even though my computer has 2003 access. Must have been created orginally in 2000.

I think ive cracked everything now, test version has work, i will try on the live version.

Thanks for all the great tips!

 

[rkaria]

If you base your report on a parameter query then you will be prompted to enter the parameters when the report is produced, just as you would when running the query.

To hide the Database window in A2000 you go to Tools>Startup and uncheck the Display Database window option.

Feel free to ask any more questions.

Actually, i thought i solved it, im having problem with this 2000 format.

I have 2003 but when i create a database it automatically creates it into 2000 format???!?!? how do i change that? Thinking about the layout looks like 2000 aswell. Ive checked in add/remove programs and there is only office 2003 there, im confused.com

Thanks
R

 

[dbDamo]

Tools>Options>Advanced>Default File Format - change to Access 2003

 

[rkaria]

Tools>Options>Advanced>Default File Format - change to Access 2003

I just figured that out, that works for new databases but the one i currently have is still in 2000. it has not changed! Any Ideas?

 

[dbDamo]

Create new Databases. Just import the objects into new blank Databases with 2003 selected in this option. Then replace the new Back End on the server and distribute the new front end. Obviously some down time but shouldn't take you long.

Is having the Database in A2000 format causing you any specific problems?

 

[rkaria]

Create new Databases. Just import the objects into new blank Databases with 2003 selected in this option. Then replace the new Back End on the server and distribute the new front end. Obviously some down time but shouldn't take you long.

Is having the Database in A2000 format causing you any specific problems?

I feel so thick, of course thats the way to do it. Sorry its been one of those days today

yes i cant create mde file in 2000 format.

 

[dbDamo]

yes i cant create mde file in 2000 format.

and that was me being thick - tfi almost Friday!!!

 

[rkaria]

and that was me being thick - tfi almost Friday!!!

haha, well my weekend starts now! I finish in 2 minutes