I've wondered about this too. Have you thought about creating a table that logs when a user opens the database? Username — Grant. I could use that command line in my login button Create a macro and name it Autoexec.
Try this link — Grant. Very nice! Add a comment. Active Oldest Votes. Database, rst As DAO. GetTempName fso. Stream lck. Open lck. Read 32 rst. AddNew rst! Read 32 '' skip accessUserId, almost always "Admin" Loop lck. NoMatch Then rst. Edit End If rst! Requery End Sub. Improve this answer.
Community Bot 1 1 1 silver badge. Gord Thompson Gord Thompson k 27 27 gold badges silver badges bronze badges. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content.
While using W3Schools, you agree to have read and accepted our terms of use , cookie and privacy policy. Copyright by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3. Obtaining Auto-Increment Values. Dynamic Cursor Support. Configuring Catalog and Schema Support. Microsoft Access. Microsoft Excel and Column Types. Microsoft Visual Basic. Microsoft Visual InterDev. Visual Objects. But then the password is stored readable in the ODBC information in the registry, therefore it is no good idea.
Leave the field German Benutzername empty. For example you can check opening German exclusive there, however then you will be unable to hide tables in OOo. The new data source should be included in the list. Choose it and click on OK. If your database is password protected and you haven't enter the password in the ODBC informations, check Password required. If you want to use the data source in other office modules, for example for mail merge, you must check the option Yes, register the database for me.
After click on Finish you determine file name and folder to save for the Open Document Base file. Now you can work with the database. You are able to define new tables. However in both connection types you cannot alter the structure of existing tables.
0コメント