Which Version of Access

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I know I have seen this before, but I can't seem to locate my references.

I am looking for a way to prevent users from openeing Acc97 databases using
other versions of Access.
How can I determine which version of access the user is using to when
opening a database?



Thanks,
Andy
 
Andy said:
I know I have seen this before, but I can't seem to locate my
references.

I am looking for a way to prevent users from openeing Acc97 databases
using other versions of Access.
How can I determine which version of access the user is using to when
opening a database?



Thanks,
Andy
Click to expand...

If you distribute an MDE then Access 97 will automatically be the only
version that can open it.
 
Thanks Rick,

Most of the dtatabases are MDE's, but one is not (and can't be due to a
dynamically generated report).

But I also want to protect the back end databases from being opened directly
using the wrong version. We seem to have some users that always like to
bypass as many rules as possible.


Andy
 
Andy said:
Thanks Rick,

Most of the dtatabases are MDE's, but one is not (and can't be due to
a dynamically generated report).
Click to expand...

If you posted what was "dynamic" about it someone could likely point out
that the same thing could be accomplished in an MDE. Most "on the fly
design changes" can also be done in the open event of the report without
needing to actually go into design view.
But I also want to protect the back end databases from being opened
directly using the wrong version. We seem to have some users that
always like to bypass as many rules as possible.
Click to expand...

The only thing that would prevent that is setting up User-Level security or
better personnel management.
 
Redesign of the database is not an option.

All I requested was a way to determine the current version of Access being
used to open the databse.

Thanks for the non-help.

Andy
 
Andy said:
Redesign of the database is not an option.

All I requested was a way to determine the current version of Access
being used to open the databse.

Thanks for the non-help.
Click to expand...

I don't understand this response. Your original post was to "PREVENT" users
opening the file in a different version. There is code that will tell you
the Access version that a user is running, but that code will only be able
to run AFTER they have already opened the file. If your intent is to
prevent people from opening in a newer version and converting it when Access
asks them then your code would only run after the damage had already been
done.

Using an MDE would prevent this and implementing User Level Security would
prevent this which were both things I suggested. How can you consider that
"non-help"?

Here is the code
SysCmd(acSysCmdAccessVer)

I found it by Googling on "determine access version in code group:*access*"

It was the very first link returned by Google (and surprise) it was a post
by me made in June 2000.
(what are the odds?)
 
Rick said:
Here is the code
SysCmd(acSysCmdAccessVer)
Click to expand...
Thanks for the info (I knew it was simple).
I found it by Googling on "determine access version in code group:*access*"

It was the very first link returned by Google (and surprise) it was a post
by me made in June 2000.
(what are the odds?)
Click to expand...

Yeah, I did a Google search too...several in fact.
Using "which version of access" returned 34 million hits...
Using "determine access version" returned 6 million hits...
Using "determine access version in code group:*access*" returned 4
million hits...

....and yours was not first.

I initiated my Google searches using the FireFox Google search.

I don't doubt that you did post in 2000, nor that you found your post
first in your list. But not every one searches the same way you do, and
those differences don't make them wrong, nor any less competent at
searching.
 
Back
Top