| [ Total Views: 493 | Total Replies: 5 | Thread Id: 78195 ] |
|
|
 amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on August 4th, 2009 at 06:13 PM |
|
|
hello MS access geeks
Hi guys n dolls,
I have created an access database to help out with a little project we have going at work. I've got my pretty form going, all is well. EXCEPT the
users have access to the tables. Instead of opening the form, a couple of people are opening the tables behind the form and editing that way. Pretty
dangerous because the form has some important fields locked, but the fields are being updated directly to the table by dirty cheats.
I've never used access before. How can I stop this?
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline
Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular
|
| posted on August 4th, 2009 at 06:24 PM |
|
|
| Quote: | Originally
posted by amazeer
I've never used access before. How can I stop this?
|
Stop it - you'll go blind. Use MySQL, write the user interface in Perl or PHP. Exercise complete control over who gets to what. Send no money to
Micro$oft. With any multi-user Access database, you *will* get frequent database corruptions; I had one with about 30 users, once a month I would get
complete database corruption.
hth
|
|
|
amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on August 4th, 2009 at 07:57 PM |
|
|
No can do, I'm a public servant. Cant do anything but use what is already available. Have a perfectly good DB2 server sitting there but not allowed
to create schemas or tables. Not even an index.
At full speed I think we'll only get a max of 8 users, currently 4. I have a scheduled task taking backup copies every 4 hours. Thats the disaster
mitigation plan in its entirity.
|
|
|
eraser
Fahrvergnugen
Posts: 970
Threads: 128
Registered: March 11th, 2005
Member Is Offline
Location: Adelaide
Theme: UltimaBB Pro Powder
|
| posted on August 4th, 2009 at 09:06 PM |
|
|
Ahh access will be fine for a small database. What you might want to do is lock the file so only the form can be accessed.
If you go to tools then startup you can make your form startup by default.
Then you can choose not to Display database window,
To get to this you can use the F11 key,
You can also de-select allow full menus
To get these hold shift whilst opening the database.
hopefully this will help.
-M
|
|
|
amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on August 4th, 2009 at 09:50 PM |
|
|
Thanks. Its definitely small. Only 2 tables, only 2013 rows. Will give it a shot tomorrow.
|
|
|
amazeer
A.k.a.: Surly Duff
Bishop of Volkswagenism
Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter
|
| posted on August 5th, 2009 at 09:24 AM |
|
|
|
|
|
