473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Read Only Front End (Access 2000/2002)

I want to create a front end, where the linked tables are read only. The object of the exercise is to allow some users to write their own queries and reports, but prevent them from updating anything either by typing into the tables, or writing update queries.

I did this in 1999, but I can't remember what I did.

I know I could use the Access security setup, but that is not an option. The users are scattered all over the far boonies of MA and have no computer experts available on site. If they screw up the security somehow, they won't be able to use the main system.

I have found one way to do it, but it is ugly, so I'm hoping for an elegant solution.

Thanks.
Oct 28 '06 #1
9 3454
MMcCarthy
14,534 Expert Mod 8TB
If you make your front end an mde. Keep a backup copy of the mdb development

First...
Lock all the forms to read only.
In the form properties set locked to yes

Set your startup options to hide database window and unclick all the boxes. create a customised menu bar with only those options the users will need and set this as the menu bar in startup as well.

This means the only access the users will have is through the forms and locking them makes them read only.
Oct 28 '06 #2
What you suggest is they way the main system works.
In this front end they would be writting their own queries and reports. So an MDE won't work in this case.

Thanks
Oct 28 '06 #3
PEB
1,418 Expert 1GB
I'm afraid mcarthy but how the users will write their own queries? And creating Query but shouldn't be update query or append query??? Maybe invent a new query builder without those options???

It's better to search for something common to the attached tables...

The only thing that isn't convinient is that the users have permissions to create and modify queries and reports... Those are a big permissions... I don't give such a permissions to my users...

Using form filters and filters created by me - ok but creating queries...

This isn't for each head! ;)

If you organize the things that your users can't modify and create queries... it should be very ddifferent...

Your tables will be seen by queries with read only permissions... You will defend the access to the query builder and everthing will be ok...

:)


If you make your front end an mde. Keep a backup copy of the mdb development

First...
Lock all the forms to read only.
In the form properties set locked to yes

Set your startup options to hide database window and unclick all the boxes. create a customised menu bar with only those options the users will need and set this as the menu bar in startup as well.

This means the only access the users will have is through the forms and locking them makes them read only.
Oct 28 '06 #4
pks00
280 Expert 100+
I want to create a front end, where the linked tables are read only. The object of the exercise is to allow some users to write their own queries and reports, but prevent them from updating anything either by typing into the tables, or writing update queries.

I did this in 1999, but I can't remember what I did.

I know I could use the Access security setup, but that is not an option. The users are scattered all over the far boonies of MA and have no computer experts available on site. If they screw up the security somehow, they won't be able to use the main system.

I have found one way to do it, but it is ugly, so I'm hoping for an elegant solution.

Thanks.

Have u considered making the backend readonly? If the network folder or the database itself is readonly, would that not then make your linked tables readonly?
Oct 29 '06 #5
Hi:
I can't make the back end read only because it is used by the main system. That system is strictly form based and allows as little freedom as possible, You can't open it with shift, you can only use my custom menu bar, etc.

But some of them want to do their own queries and reports. If is was up to me, I wouldn't let them do even this/. But I have to protect the back end from accidental screw ups.

I can do what I want in a very simple way, but it is ugly and I know there is a better way.

I can create a form for each table. The form is set to lock all records. Open the forms hidden.
Then no query that changes the records will work.
But I know I had a much more elegant method years ago.

Another possibility is to copy the main back end in the autoexec. I backends are in the 5 meg range. The world be an opening delay, but perhaps that is the simplest answer unless I can remember what I did.
Thanks
Oct 29 '06 #6
NeoPa
32,556 Expert Mod 16PB
This is only a guess really, but did you have an ODBC link before which could be set up as Read Only?
We use one of those to our back-end system.

Your system could, of course continue to use the current method but those 'others' (users - damn!) could use the R/O link.
Oct 29 '06 #7
PEB
1,418 Expert 1GB
It's not necessary to be a form...

A query based on a table it's a good way also...

But the query is read only...

and they can do all possible filters on the respective query...

Of course with form Autofilter...


What more???

If they want a specific join... you do it and the rest is teir homework... They can save the filters as query I think but haven't verified if the users without write rights can access this option..

:)
Oct 29 '06 #8
pks00
280 Expert 100+
Have u considered looking at getting a report writer like Crystal Reports?
Oct 30 '06 #9
pks00
280 Expert 100+
Here's a thought

What if u created Replica's of the database? You will need to enable Synchronisation but then ensure its only from Master to Replica

If you do this, then it doesnt matter what they do to the data as they are not touching the backend. And if they want the latest data, they have to ensure they perform the sync! By the way, u can perform that via code

here is a good link talking about replication and synchronisation from ms
http://msdn.microsoft.com/library/de...l/dbrepjet.asp

e.g. code for syncing

Public Sub SendChangeToReplica()

'Sends data or structural changes to the replica.
CurrentDb.Synchronize "C:\master.mdb", dbRepImportChanges

End Sub
Oct 30 '06 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: David ROBERT | last post by:
Hello, I need to read data from a MS Access database. The program (reader) is installed on a linux box and is written in python langage. The database is MS Access 2002 installed on a Win XP box...
3
by: Scott | last post by:
Hi, If we want to compile an Access 2002 database and distribute it to others, will the compiled software run on any PC, like Windows 98, Windows 2000, etc. Also, you don't have to have...
3
by: Stickleback | last post by:
Morning All I have been developing and deploying with Office 2000 for about 3 years, mainly Access based programs and although I have gotten used to it's quirks, I am starting to feel that I...
7
by: JMCN | last post by:
Is this possible to have the 97 users with 97 front end, 2000 users with 2000 front end, 2002 users with 2002 front end, and 2003 users with 2003 front end all linked up to an access 97 backend? ...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
0
by: PaulB | last post by:
Hi there, Allthough I searched for previous posts, I was unable to solve my problem. I try to link my front-mdb with an Excel file using the next line DoCmd.TransferSpreadsheet acLink, 8,...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.