Newbie Help!

[IanMac]

Hi all, as the title suggests i'm pretty new to Access (07-10) and your help would be very creatful.
I have inherited a database, one table, and have created a single form for it.
Questions are these...previoulsy when 2 instances of the databse being opened, at the same time on different machines, a warning message would appear. This no longer happens, why?
Also, how would i lock the form, which is also used as a lookup for items, so that only a couple of people could ammend/add data?

Thanks in advance...Ian

 

[Ranman256]

If you want others to share the db, it must be split.
Is your db split? (the app /queries/reports is on each persons PC, but the tables alone are on the server)

I would build a table of users, tUsers.
their userID, and rights code.
When the main menu loads , get the userid via
sUserID = Environ("Username")

Then lookup in tUsers to see if they have rights to be in the form.

if sUserID = dlookup("[userID]","tUsers","[userid]='" & sUserID & "'")
   docmd.openform "frmEdit"
endif

 

[MSAccessRookie]

Hi all, as the title suggests i'm pretty new to Access (07-10) and your help would be very creatful.
I have inherited a database, one table, and have created a single form for it.
Questions are these...previoulsy when 2 instances of the databse being opened, at the same time on different machines, a warning message would appear. This no longer happens, why?
Also, how would i lock the form, which is also used as a lookup for items, so that only a couple of people could ammend/add data?

Thanks in advance...Ian

I would like to agree with Ranman that splitting the database is always the first choice when there are multiple users on separate machines. Having said that, let me address your two issues separately:

• When 2 users opened the database on different machines at the same time, a warning message used to appear. This Message no longer happens.
  • This may have been due to the fact that in the old way the users lock blocks of records when they opened a Table, and no other users can read records in these blocks as long as they are open, while in the new way, the Form usually locks a single record at a time, so the possibility of being blocked is much less.
• How would I lock the form, which is also used as a lookup for items, so that only a couple of people could amend/add data?
  • You can build a read-only Form for the users that only need to browse the data.
  • You can build a sign in form that requires entry the a user ID and Password. If your are already on a network, and the network ID may be available to use as a user ID and the password provides additional level of security. I am sure that there are also other (more complicated) methods, but I have provided these two as a starting point.

-- Rookie

 

[Ranman256]

once you determine the rights, once the form opens,
set me.dataentry = no
or recordsettype = snapshot
or me.locked = yes

there are many ways to prevent user form editing/adding/ data.

 

[IanMac]

Thanks guys! I'll give it a go