Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training - Multiple Users
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms access training - Multiple Users
Resolved · Low Priority · Version Standard
Reply Tue 14 Nov 2006, 10:25Delegate 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?
For upcoming training course dates see: Pricing & availability
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.
|