HORRIBLE PROBLEM WITH ADO AND ACCESS

From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 19:28:19 +0200

Hi there,

this is really confusing!! I am using ADO to connect to an Access database.
When I am adding datasets and in the background, the database is open with
Access, the datasets are stored and saved. If Access is closed then the
datasets are first added but when I close the application, they are gone!!!
I checked my Transactions, everything is right.

As I said, when Access is open parallelly, everything works fine, when
Access is closed, the newly saved datasets are gone.....

Any help?????

Thanks,

Pascal

Relevant Pages

  • Re: How to connect MS ACCESS in Netwaork base VB6.0 Programme from server
    ... Structure you can use to connect to and query an Access Database using ADO. ... How to connect MS ACCESS in Netwaork base VB6.0 Programme from server ... SIDE) AND ATTENDENS STORE OM MS ACCESS DATABASE WHICH IS STORED ON ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Active Server pages on a mac
    ... In otherwords does the Excel object model on a Mac have ADO? ... Here is how to create a connection to a MS Access Database: ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • ADO and Active Server pages on a mac
    ... Can you use ADO object to connect to an Access database from Excel on a Mac ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • Re: Importing data From Word Form to Access
    ... you have DAO and ADO. ... > access database. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: renaming a access table in ado .net
    ... i need to rename a table in a access database, ... I'm not aware of any way to rename a table directly using Access SQL DLL. ... You will probably need to use either ADOX or DAO. ...
    (microsoft.public.dotnet.framework.adonet)