Re: Which Database am I Using

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"DanBair" <DanBair@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
OK, I'm so new I don't even know what database I'm using and I wish I
could
use another name to ask this question. How do I tell what database I'm
using. I'm using Access 2002 I think.


Dan,
Open up Access, then select Help | About and then check the version number.

Here are a couple of connection string examples for connecting to a MDB
using ADO:
- OLE DB
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

- ODBC
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForAccess

Or if you are using ADO.NET:
http://www.carlprothman.net/Default.aspx?tabid=86#OLEDBManagedProvider

HTH



.

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ... When the user exits the dialog box, the driver connects ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Change Connection String at runtime.
    ... easily moved to another database, or have versions for each database. ... connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment. ... It appears that the generated code uses the application settings to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... database without knowing anything beforehand except the driver name. ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: No Go on VB6/ADO/Access2007
    ... and it needs to interact with an Access 2007 database. ... connection no problem with ADO and a connection string. ... here is that my table has an auto-increment field which is the primary ... rather than ADO itself, this points to a problem with the database. ...
    (microsoft.public.data.ado)