Access x MSDE, DAO x ADO, dBase... 
Author Message
 Access x MSDE, DAO x ADO, dBase...

Can you tell me your opinion?

I will make app, that must read some data from DBF, these will proceed
and results will show and save for next proceed.

First time i'd make it with Acc97 linked tables a results save to MDB, but
i dont know, maybe its better save it to MSDE, it will go probably to SQL
Will I lost performance?. Its single user app, for the present.

Second question is about reading DBF. There will be FPT and DBT memo format.
I think maybe it will be better to open these dbf like:

    Select * FROM Something IN "C:\path" "dBase IV;"

Is it possible? And Shall I use DAO 3.6 or ADO 2.1? Or Must I use DAO 3.51?
I would not like to use BDE...

And last answer: I tried to use MSDE under Win98 and I have Off2000. Where
can I find something like Enterpice Manager (i'm not sure about exactly
name) from
SQL 7.0, where I can:
            -set user rights
            -create a delete database devices, or databases
            -add and delete users
            -and so on...
When I used the Access, it have not something under tools menu - but it
should have
(according with help)

Thanx for your opiniom.


Fri, 29 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. taxes for DAO/ADO + Access/MSDE

2. DAO or ADO with MSDE?

3. MSDE (SQL) versus Access DAO

4. ADO or DAO connection to dBase

5. Creating dBase tables using ADO or DAO ??

6. VB6, ADO 2.1 and MSDE (Access 2000)

7. ADO vs DAO when accessing data stored in MS Access

8. Accessing dbase with ADO

9. Problem with dBase IV ODBC access via ADO

10. Attaching a dBase III table to Access 2000 via ADO

11. Import dBase III files to Access 2000 with ADO

12. Problem with dBase IV ODBC access via ADO


Powered by phpBB® Forum Software