Opening different DBASE-Databases at runtime via DAO 
Author Message
 Opening different DBASE-Databases at runtime via DAO

Hi!

Maybe one of you guys/girls can help me out of that one: There are still
people using DBASE. Yeah!
How is it done to open a DBASE-Database at runtime via DAO?
I tried the OpenDatabase-method, but i get errors (Databasetype not
recognized) though i passed "dbase IV;" as Connect. What Do I do wrong?
Any example or hint would be appreciated.

TIA

Kristof



Tue, 16 Apr 2002 03:00:00 GMT  
 Opening different DBASE-Databases at runtime via DAO

Quote:

> How is it done to open a DBASE-Database at runtime via DAO?
> I tried the OpenDatabase-method, but i get errors (Databasetype not
> recognized) though i passed "dbase IV;" as Connect. What Do I do wrong?
> Any example or hint would be appreciated.

Did you explicitly state the full connect and open this way?

Set dbKristof = OpenDatabase("C:\SomeFolder", False, True, "dBase IV")
Set rsKristof = dbKristof.OpenRecordset("FileName.dbf")

--
Jim in Cleveland
If you're writing to me, in my address
change "REAL_Address.see.below" to "worldnet.att.net"

"What's so funny 'bout peace, love & understanding?"
     - Nick Lowe



Tue, 16 Apr 2002 03:00:00 GMT  
 Opening different DBASE-Databases at runtime via DAO
if you use Microsoft Visual Foxpro odbc driver you can access more
functionality, as visual foxpro driver can also be used for dbase files.
Quote:

> Hi!

> Maybe one of you guys/girls can help me out of that one: There are still
> people using DBASE. Yeah!
> How is it done to open a DBASE-Database at runtime via DAO?
> I tried the OpenDatabase-method, but i get errors (Databasetype not
> recognized) though i passed "dbase IV;" as Connect. What Do I do wrong?
> Any example or hint would be appreciated.

> TIA

> Kristof



Mon, 22 Apr 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Multiple opens to a DBASE DB fails via ADO

2. Acc97: Specifying /CMD parameter when opening database via open dialog

3. database connection remain open if opened via recordset

4. DAO - problem with dates importing dbase databases

5. IMPROT DBASE 3 DATABASE TO ACCES VIA VB

6. Querying DBASE databases via ODBC

7. DAO Merging tables from different databases

8. Runtime error 3021 Opening DAO Query

9. Open database dBASE

10. opening a dBase database

11. Linking a dBase III table to an Access 2000 database - won't open

12. Best methods to open/edit dBase databases?

 

 
Powered by phpBB® Forum Software