[MS_AccessPros] "too many databases" and DBEngine(0)(0)

 

Crystal and all:

I just saw this from Crystal:

my experience has shown using DBEngine(0)(0) instead of CurrentDb when
possible is a good idea to reduce the "too many databases open" error.

How does one use DBEngine(0)(0)? I currently have two types of currentdb in my code and I'd like to change them:

1. Dim db As DAO.Database then "Set db = Currentdb)

2. CurrentDb.Execute "DELETE

Thanks!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___