Re: dev connections work, test does not

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 07/26/04


Date: Mon, 26 Jul 2004 08:28:33 -0500

On Fri, 23 Jul 2004 13:14:01 -0700, "Helen" <Helen@discussions.microsoft.com> wrote:

¤ Hi, Paul:
¤
¤ Yes, I'd heard that before - stay away from ODBC! I was using ole and it worked. Then, because the app was failing on my test box, I thought I'd try another way, hence my efforts with odbc. Whatever works, really, at this point!
¤
¤ In test, what is happening is that the login generic box appears when I run the .exe. I put in a great deal of effort on my DEV box preventing this from showing. The connections have all been troublesome from the beginning, and finally I achieved success in DEV, and the login box didn't pop up. The main form appears, I click on my option of which report I'd like to see, and a second form appears that loads the crystal report. All connections and ids are done behind the scenes.
¤
¤ The error is that the login box appears, and even then if I enter server/database/uid/pwd detail, it kicks me out. It seems to be connecting to connection information somewhere that doesn't relate to the application.
¤
¤ Tks for your time and effort in helping.
¤

Can I assume that the login dialog is for the Access database and not for a linked table to another
database (such as SQL Server)?

If you are implementing user-level security for your Access database then it's possible that the
system.mdw file cannot be located. Would this be a possibility?

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)



Relevant Pages

  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... DDE is the only connection method that actually starts Access. ... .odc or ODBC Connection parameter in VBA (there is a tab for ... > the User/System DSN ... >>>>> Document to connect to a Secured Access Database, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... you have to use ODBC (or the old DDE ... but then you go onto say that an "ODBC connection set up ... >> Document to connect to a Secured Access Database, ... >they have a .dsn extension. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ADO and Active Server pages on a mac
    ... Mac XL doesn't include ODBC drivers, but you can obtain 3rd party. ... 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)
  • JDBC and MS Access Anywhere
    ... I am currently working on a Java project that is directly connected with a MS ... I have already connected the ODBC on my windows XP system ... ODBC in windows and then connect to the Access Database file in the project ... folder...regardless weather the user has setup a ODBC connection to the ...
    (comp.lang.java.databases)