For more information about using the Amazon WorkSpaces client application or web browser to access provisioned WorkSpaces, see the Amazon WorkSpaces User Guide. For more information about administering WorkSpaces, see the Amazon WorkSpaces Administration Guide. You can also manage your WorkSpaces resources using the WorkSpaces console, Command Line Interface (CLI), and SDKs. For more information about the supported Amazon Web Services Regions, endpoints, and service quotas of the Amazon WorkSpaces service, see WorkSpaces endpoints and quotas in the Amazon Web Services General Reference. This API Reference provides detailed information about the actions, data types, parameters, and errors of the WorkSpaces service. Users can access their virtual desktops from multiple devices or web browsers. You can quickly add or remove users as your needs change. WorkSpaces eliminates the need to procure and deploy hardware or install complex software. 'Deposit funds into another account tableĭbX.A low-level client representing Amazon WorkSpacesĪmazon WorkSpaces enables you to provision virtual, cloud-based Microsoft Windows or Amazon Linux desktops for your users, known as WorkSpaces. Set dbX = wrk.OpenDatabase("e:\books\acc2007vba\myDB.accdb")ĭbC.Execute "INSERT INTO tblAccounts ( Amount, Txn, TxnDate ) SELECT -20, 'DEBIT', Date()", dbFailOnError Sample code provided by the Microsoft Access 2010 Programmer’s Reference. The following example shows how to use a transaction in a Data Access Objects (DAO) workspace. "Properties of unnamed Microsoft Access workspace"ĭebug.Print " " & prpLoop.Name & " = " & prpLoop ' Enumerate Properties collection of Microsoft Access Set wrkAcc = CreateWorkspace("", "admin", "")ĭebug.Print "Workspace objects in Workspaces collection:" ' specified by the DefaultType property of DBEngine ' Create an unnamed Workspace object of the type It then lists the properties of theworkspace. This example uses the CreateWorkspace method to create a Microsoft Access workspace. ' Enumerate the Properties collection of the new Set wrkNewAcc = CreateWorkspace("NewAccessWorkspace", _ ' Create a new Microsoft Access workspace. It then enumerates the Workspaces collections and the Properties collection of the Workspace object. This example creates a new Microsoft Access Workspace object and appends it to the Workspaces collection. Use ADO if you want to access external data sources without using the Microsoft Access database engine. ODBCDirect workspaces are not supported in Microsoft Access 2013. To refer to a Workspace object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms: However, you must refer to it by the object variable to which you have assigned it. You can use a newly created Workspace object without appending it to the Workspaces collection. After you create a new Workspace object, you must append it to the Workspaces collection if you need to refer to it from the Workspaces collection. You can create Workspace objects with the CreateWorkspace method. You can create additional Workspace objects to manage transactions independently across Database objects. If you then use the Rollback method, both the update and delete operations are canceled and rolled back. For example, you use a BeginTrans method, update several records in a database, and then delete records in another database. When you use transactions, all databases in the specified Workspace are affected- even if multiple Database objects are opened in the Workspace. If security is enabled, the UserName property setting is the name of the user who logged on. The settings of the Name and UserName properties of the default workspace are "#Default Workspace#" and "Admin," respectively. When you first refer to or use a Workspace object, you automatically create the default workspace, DBEngine.Workspaces(0). Use the BeginTrans, CommitTrans, and Rollback methods to manage nested transaction processing within a Workspace and use several Workspace objects to conduct multiple, simultaneous, and overlapping transactions. Use the OpenDatabase method to open one or more existing databases on a Workspace. Use the Close method to terminate a session. The session creates a scope in which you can open multiple databases and conduct one instance of nested transactions. Use the Name, UserName, and Type properties to establish a named session. In a session, you can open multiple databases or connections, and manage transactions. Use the Workspace object to manage the current session or to start an additional session. RemarksĪ Workspace is a non-persistent object that defines how your application interacts with data by using the Microsoft Access database engine. It contains open databases and provides mechanisms for simultaneous transactions and, in Microsoft Access workspaces, secure workgroup support. A Workspace object defines a named session for a user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |