Open Access DB on form load

[ef61778]

How would I open and make an Access database visible on form load?

 

[CCLINT]

Check out the VB DataForm wizard (select this when add a new form)

 

[ef61778]

Thanks CCLINT for the tip; however, this will not work with the form I currently have. I have a form with 3 buttons. To do a excel transfer to access, I need an opened database. I am using access 2000, which is showing as an unrecognized database. Any other ideas?

 

[CCLINT]

>this will not work with the form I currently have

That's right...but it will show you how to open a JET mdb and access it's data..


Also, concerning the JET 4 database being unrecognized:

Do a search in here using the Exact Phrase option and the keywords "unrecognized database".

 

[ef61778]

CClint- Thanks, it worked out. Thanks for the quick replys