Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to check if Access 2000 or Access XP 2

Status
Not open for further replies.
balor

balor

Programmer
Joined
Jul 24, 2000
Messages
74
Hi,

Can I with vba-code check what version of Access the user is using?
 
Sort by date Sort by votes
The access version number can be retrieved using the following:

vAccessVersionNumber = SysCmd(acSysCmdAccessVer)

Returns:

7 is Access 95
8 is Access 97
9 is Access 2000
10 is Access 2002

Regards...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question Question
Use domain accounts to log in to Access database
Replies
0
Views
4K
breezett93
breezett93
scamquist58
  • Locked
  • Question Question
VB Change Default Printer - Access
Replies
1
Views
3K
combo
combo
dw134
  • Locked
  • Question Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
3K
dw134
dw134
LittleNick
  • Locked
  • Question Question
Can Quick Access Toolbar be disabled in Access 2010?
Replies
0
Views
3K
LittleNick
LittleNick
techstudent01
  • Locked
  • Question Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
3K
techstudent01
techstudent01

Part and Inventory Search

Sponsor

Back
Top