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!

Stop Opening Database Object Windows when executing Code

Status
Not open for further replies.
bestbefore99

bestbefore99

IS-IT--Management
Jan 24, 2002
16
IT
Hi all.

I have written an Access Database Application which converts another Access DB into mySQL.
Fine enough. Unfortunately it uses the DoCmd.TransferText method to create an intermediate text file.
When this command is executed, all DB objects to be imported are opened and you will see all windows opening on forms, modules, reports, before actually doing the desired work. Result, it takes ages to convert the Database.

Question: Is not any way to avoid Access opening all these windows?

Many Thanks

Massimo
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
548
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Code not working 1
Replies
5
Views
263
Darrylles
Darrylles
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
498
dhookom
dhookom
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
253
AJAY0618
AJAY0618

Part and Inventory Search

Sponsor

Back
Top