Database keeps corrupting

T

Tony Toews [MVP]

John W. Vinson said:
That's VERY interesting, Ben. Another arrow (a sharp one!!) in the quiver for
those of us who dislike Lookup Fields...

Of course, as you now realize, lookups are never necessary; but this is just
another good reason to avoid using them entirely.
Click to expand...

But OTOH I have a client with many lookup fields in many of the 100
tables in the BE. The BE MDB is 200 Mb with 600K records in the main
table. No crashing of the database when opening tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Dynamic Naming of Form Button 3
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Active Content in this file is blocked issue 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
database keeps corrupting 12
Error-17099 SMTP Relay Error Problem Entourage 2004 0
Access 2003 vs 2010 1

Top