Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CurrentDB ?

Status
Not open for further replies.
Informatic

Informatic

Programmer
Oct 4, 2002
34
DE
Hi

A friend of mine has told me that the function 'CurrentDb' make the VBA Code to work very slow...

Is it true and what can i do...
 
Sort by date Sort by votes
What your friend said is not true. The CurrentDB Method enables you to create more than one variable of type Database that refers to the current database. Microsoft Access still supports the DBEngine(0)(0) syntax, but you should consider making this modification to your code in order to avoid possible conflicts in a multiuser database.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

irethedo
  • Locked
  • Question
correct syntax for setting up a SQL string for CurrentDb.Execute 1
Replies
4
Views
188
irethedo
irethedo
DataChick
  • Locked
  • Question
Set db = CurrentDb Not Working for One User
Replies
1
Views
58
TheAceMan1
TheAceMan1
Marco123
  • Locked
  • Question
FileLen(Currentdb.Name) not updating when code is running
Replies
5
Views
90
Marco123
Marco123
OhioSteve
  • Locked
  • Question
CurrentDb().TableDefs("myTable").question 2
Replies
3
Views
210
OhioSteve
OhioSteve
Apollo13a
  • Locked
  • Question
DAO set Currentdb error 2
Replies
3
Views
33
Apollo13a
Apollo13a

Part and Inventory Search

Sponsor

Back
Top