ms-access-2007
How to execute Multiple "Create Table... " Statements in ACCESS Database
I have 480 \"Create table\" statements to be inserted into an empty access db. I found the access has no option of multiple query executions...[详细]
2023-03-26 20:36 分类:问答Database problem--student registering for the same class twice..how to stop it Access 20007
I am making a mock database and I have a student table, student_class linking table, and a class table.How can I make it so that a student cannot be registered for the same class twice?[详细]
2023-03-26 10:20 分类:问答How to add a checkbox in a form next to a query to append to another table
I am 开发者_运维百科building a training database.The tables I am using are: Employees, Training Courses, In Training, and Completed Training. I have a query that filters off of a form to show employee[详细]
2023-03-26 00:51 分类:问答Raising an Event/Calling a Method on a MS Access form from a C# MS Access COMAddIn
I have an VS 2008 C# MS Access add-in and I wanted to know how I could raise events or call methods on an MS Access form. Simply put, how do I raise an event or call a method on a Microsoft.Office.Int[详细]
2023-03-25 05:02 分类:问答how to select top N in access report detail section or select top N in sql subquery
I have a report that is based on a query. In the detail section of the report I want to limit the number of det开发者_开发百科ail lines to top N. (likea select TOP N type query). In this sample I want[详细]
2023-03-25 03:10 分类:问答Make Backup of Data(Ms Access database) from Java Desktop Application [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the qu开发者_JAVA技巧estion so it focuses on one problem only by[详细]
2023-03-24 23:41 分类:问答Setting Security Levels in Access 2007
I have created a split database in Access 2007 and need to set user level security. I don\'t want the users to have access to any of the tables 开发者_如何转开发or queries etc. I\'ve created a form so[详细]
2023-03-24 17:48 分类:问答Enforce Multiple Relationships Between Two Tables In Access
I want to create (and enforce) multiple \"one-to-many\" relationships between the primary key of one table to attributes of another.[详细]
2023-03-24 11:12 分类:问答How to create unique index in Access w/ integer fields that may be null?
I\'m trying to create a unique multi-column index on a table in Access.Several of the fields I\'ll be using in the index are long integers.These fields may be blank开发者_如何学运维 in some records.I[详细]
2023-03-24 10:53 分类:问答How to insert "Entire" DAO recordset into a table with VBA
I have a DAO recordset that gets created fine and I can transfer the records from the set to a table, this is done row by row and works well but I am transfering a large amount of data at once so this[详细]
2023-03-23 18:40 分类:问答