Results 1 to 5 of 5
  1. #1
    cupidleomanoj is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    3

    Smile multiuser for access database

    Hi,
    I have a Application Software with VB6.0 as Front End and MS-Access2007 as its Back End. Both are running quiet well in a my PC in Offline, now i have to do the certain changes, ie, i need to install the only the Application Software in other PC, but not the MS-Access database. any updation in database done in the other PC should cause changes to my database on my PC.
    For eg: 'A' is a computer which has both the Application Software and the Access database.


    'B' is a Computer with only Application Software.
    'C' is a Computer with only Application Software.

    Any insert, update,delete done on the System 'B' & 'C' Must affect the actual database in Computer 'A'.

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    For that to work, you'll need to be able to modify your Front-end program to point to the database on a network location.

    Depending on how well the application was set up, this may be as simple as changing a setting somewhere or it may require you to change code in the program itself and re-compile it.

  3. #3
    cupidleomanoj is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    3

    Smile multiuser for access Database

    Hi Rawb,
    Thanks for your reply, your post mean that, i have to share my MS-Access Database to other users on the Network. so that they can access it from other systems which is shared through the local network. Is it so Rawb....

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    Access is made to be split FE/BE and one uses the Link Table Manager in the FE to connect to the BE. Since you are using a VB app/code and not an Access FE - this isn't really an Access question - it is a question for your visual development environment on connecting to database tables...the answer will vary somewhat depending on the specific environment/version but in general the odbc is well documented in all the visual development environments.

  5. #5
    cupidleomanoj is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    3
    Hi NTC,
    Thanks for your reply... i will work with all your suggestions....

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

Similar Threads

  1. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 AM
  2. Access database needs help!
    By chuffy in forum Access
    Replies: 4
    Last Post: 08-09-2010, 06:25 AM
  3. Error 3045 in multiuser mdb App
    By marlan in forum Access
    Replies: 2
    Last Post: 06-22-2010, 04:40 PM
  4. Database access
    By GbJubes in forum Access
    Replies: 1
    Last Post: 05-25-2010, 10:41 AM
  5. new to access need help on database
    By Miketallica in forum Access
    Replies: 1
    Last Post: 04-27-2010, 07:03 AM

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