During normal operation one of databases in my project chrashed. It's a JET 3.0 database. No repair functions are working on that base and every time I try to open it I get "Operation invalid without a current index" messsage box.
If I try to run repair procedure msg box with "(path and base name) isn't an index in this table. Look at the Indexes collection of the TableDef object to determine the valid index names."
If I open the database in debug mode with VB and compare its structure with a few months old base, I can see that after collapse TableDefs and Containers objects of failed base have changed.
In debug window it looks like this:
| |- Count <Operation invalid without a current index.>
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other.
As you build tables in Microsoft Ac…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…