|
|
|
|
Access Subcategories |
Use Jet's ShowPlan to write efficient queries |
| Access | Views: 1 | |
| In large databases, an inefficient query can reduce performance to a crawl. The ShowPlan feature of the Access Jet engine lets you plan more efficient queries, optimize your database, and boost performance |
Access 2000 How To's: Calculating Working Days |
| Access | Views: 3 | |
| This Access 2000 How To's article explains how to use Access 2000 date functions when determining 1) the number of work days representing an interval between two dates, and 2) the projected end working date calculated from a start date and number of hour.. |
Views & Procedures in Access |
| Access | Views: 0 | |
| The Query object in Microsoft Access acts as both, a View and a Stored Procedure. This article demonstrates how to access the Query object as a view or as a stored procedure through your ASP.NET pages |
Renaming Access Database Tables |
| Access | Views: 0 | |
| Have you heard of ADOX (ADO Extensions)? This technology is an object extension to ADO (classic ADO, not ADO.NET) that provides developers with an object model to represent database schema information. That is, you can use an object model to find out wha.. |
Code Sample: Excel to Access Converter |
| Access | Views: 0 | |
| Use this simple VBScript to convert .csv Excel files to .mdb Access files |
Converting a Spreadsheet to a Database |
| Access | Views: 0 | |
| Do you have an unwieldy Microsoft Excel spreadsheet that you'd like to convert to an Access database? This illustrated tutorial walks you through the process, step-by-step |
Protecting your Access Database .mdb File |
| Access | Views: 1 | |
| When creating Web applications with an Access database, developers often save the Access database to a Web accessible folder. That is, they may save the actual .mdb file as: C:\INetPub\wwwroot\MyDB.mdb. The downside to this approach is that anyone who kn.. |
Grab Access data online |
| Access | Views: 1 | |
| Even novice developers can quickly learn to make their Access databases available on the Web |
|
|
|
