I am trying to connect a designer connection to a mdb. As i plan to
distribute the end product I need the easiest connection at the user end.
I am trying to connect with OLE DB for ODBC and it will not connect. The
only connection I can make is with the Jet 4. I have created a system DSN
which poionts to the mdb, but it will not connect. Any ideas.
Also, if I have opened the mdb to correct a table, the problem gets worse.
Re: ADP vs. MDB? ... One major problem we had was that in an adp all calls to the database seem ... to run in the same connection context (i.e. adp opens one connection to the ... revert to an .mdb, open and close my own connections as required, implement ... (microsoft.public.access.adp.sqlserver)
Re: Connection to Access Database Problem ...UserName & Password are OK as I have to enter them when I open ... Originally the mdb didn't have any userid/password set (which is how I had ... I've just deleted the above connection and tried setting up a new one. ... Like it isn't even looking at the database.... (borland.public.delphi.database.ado)
Re: große Access DB - connection offen lassen? ... Auf eine ~ 100MB große MDB zu. ...Eintrag in eine bereits vorhandene *.ldb machen muss. ... "unten" geschlossen (Programmtechnisch gesehen). ... angelegt werden und bei jedem Schliessen der Connection... (microsoft.public.de.german.entwickler.dotnet.datenbank)
Re: SQL -> MDB ... You cannot just transfer data from one connection to another one. ... ' and place them into a Products_Backup in local backup MDB... > then i have an access mdb file with one temp table... ... (microsoft.public.vb.database.ado)
Re: Syntax ... Thus my connection table is now the mdb file name minus the ".mdb" ... but I would generally recommend using the "SQL Statement ... (microsoft.public.sqlserver.dts)
