Results 1 to 3 of 3
  1. #1
    sunnie_joe is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    Question Access 2010 - Access the db from multi OS Win-XP and Win-7

    I have users with mix OS needs to access the database resides on the server and can’t be divided in 2 or have 2 separate databases.
    The VB within the db, has code reference to the MS Office see below, I can only use one. I’m looking for a way to incorporate both path in the script or an alternative method to enable both users access the db from multi OS Win-XP and Win-7.

    Thank you

    Database
    path= \\server-670\DATABASE\tsa.accdb

    Clients
    Windows XP 32bit OS with MS Access 2010 /32bit,
    path= C:\Program Files\Microsoft Office\office14\MSACCESS.EXE

    Windows 7 64bit OS with MS Access 2010 /32bit,
    path= C:\Program Files (x86)\Microsoft Office\office14\MSACCESS.EXE

    VB script
    Private Sub Command71_Click()
    Dim stAppName As String
    stAppName = "" & DLookup("[Link]", "Admin_Links", "[No] = 4") & ""
    If DLookup("[Type]", "Admin_Links", "[No] = 4") = "Database" Then
    Call Shell(stAppName, 1)
    Else
    Application.FollowHyperlink stAppName, , True
    End If
    ‘stAppName = "C:\Program Files (x86)\Microsoft Office\office14\MSACCESS.EXE\ \\server-670\DATABASE\tsa.accdb /wrkgrp \\server-670\DATABASE\tsa.mdw"
    ‘stAppName = "C:\Program Files\Microsoft Office\office14\MSACCESS.EXE\ \\server-670\DATABASE\tsa.accdb /wrkgrp \\server-670\DATABASE\tsa.mdw"


    End Sub

  2. #2
    sunnie_joe is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5
    What is it you disagree?
    Quote Originally Posted by monest View Post
    disagree

  3. #3
    sunnie_joe is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    Question What do you disagree with?

    Quote Originally Posted by sunnie_joe View Post
    What is it you disagree?

    can you be more specific please?

    Did i post this question in the wrong forum?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  2. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  3. Replies: 1
    Last Post: 01-05-2012, 02:34 PM
  4. Replies: 11
    Last Post: 07-17-2011, 08:56 PM
  5. Access 2010 - Multi Currency
    By Jismaeel in forum Access
    Replies: 1
    Last Post: 12-20-2010, 03:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums