Detect Database Version prior to opening db

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Olgun (Olgun_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 10:41:07 -0800

Hi,

I am working on developing an access db that will be shared among multiple
users. Many people that will be using this app have both access 97 and access
2000 running on their machine. I am trying to figure out a way to detect the
version through vba, prior to getting the standard error message that access
produces if you try opening lets say a v97 db where your default db is set to
v2000 etc..

I can get the version of the db on a Form Load event with either
Application.CurrentDb.Version or SysCmd(acSysCmdAccessVer), but at this
stage the database is already open.

Ultimately I want to prevent users from trying to open and corrupt the
database, if they have access 97 setup as their default db.

Any response would be appreciated.

Relevant Pages

  • Re: Rails app organization question
    ... I -really- like Rails, though. ... Have one instance of the app and somehow allow it to use different databases depending on the user's login. ... Have multiple instances of the app running on virtual servers, similar to how cPanel sets up accounts for multiple hosts -- each host has its own directory, MySQL database, and so on. ...
    (comp.lang.ruby)
  • Re: Multiple Application Membership/Profiles in SQLServer?
    ... I would have the database as a Membership only database (you can add ... profile, etc., but no custom tables0. ... If you want to create multiple dbs (one for each app), ...
    (microsoft.public.dotnet.framework.aspnet)
  • Schema Inter-dependencies
    ... I am at a new position where they host multiple applications in Oracle ... dependencies on A's schema objects. ... Or would it be better to have each app (and associated ... completely seperate app living on the same database, ...
    (comp.databases.oracle.misc)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)