ms access training - Multiple Users

Resolved · Low Priority · Version Standard

Tue 14 Nov 2006, 10:25 Delegate Cheryl said...

Cheryl has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Multiple Users

Can multiple users make changes to a table that is resides on a SQL server 2000 db and is linked to an access db?

Tue 14 Nov 2006, 12:40 Trainer Richard said...

RE: Multiple Users

The answer depends on the security permissions set on the SQL database. When your environment consists of linked tables, the database that has the actual table controls the permissions.

Generally speaking, you are able to make data changes to the table, provided you have the appropriate permissions. Structural changes need to be made in the actual table itself, in your case, in the SQL database tables.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.