hello MS access geeks

amazeer Bishop of Volkswagenism

3,029 posts · joined Nov 2005 · 4 Aug 2009, 6:13 pm

#727387

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 Veteran Volks Folk

2,009 posts · joined Jul 2003 · 4 Aug 2009, 6:24 pm

#727389

amazeer wrote: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

Peter Hill
1975 Type 2 Double Cab
modulus.com.au

amazeer Bishop of Volkswagenism

3,029 posts · joined Nov 2005 · 4 Aug 2009, 7:57 pm

#727412

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

970 posts · joined Mar 2005 · 4 Aug 2009, 9:06 pm

#727452

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 Bishop of Volkswagenism

3,029 posts · joined Nov 2005 · 4 Aug 2009, 9:50 pm

#727480

Thanks. Its definitely small. Only 2 tables, only 2013 rows. Will give it a shot tomorrow.

amazeer Bishop of Volkswagenism

3,029 posts · joined Nov 2005 · 5 Aug 2009, 9:24 am

#727558

👍