Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old February 23rd, 2005, 07:23 PM
freeturkeys freeturkeys is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 3 freeturkeys User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 m 42 sec
Reputation Power: 0
Unhappy access database synchronization

here's my situation, sad but true. I work at a recreation center and all of our members have id cards. the software we use to make the cards is polaroid id card maker. this program is essentially an access database that runs with the msaccess runtime. what i am trying to do is install or link to the database from multiple computers so that we can use it for more things then simply keeping track of id cards. i originally just made shortcuts on all the computers pointing to the database over the network, but the problem there is that if someone is using the db on one computer no one else can access it. what would be the easiest way to allow 3 computers to access and make changes to the database simultaneously?? one idea i had was to copy it to each computer and then find a program that would synchronize all three databases to say the same thing. do you think this would work? any ideas are welcome. thanks!

Reply With Quote
  #2  
Old February 24th, 2005, 09:26 AM
Mr_Jones Mr_Jones is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 20 Mr_Jones User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 15 m 34 sec
Reputation Power: 0
You would need to split the db into a back end (database) and front end (forms etc) for more than one simultaneous user. Look this up in the Access help for info.

Reply With Quote
  #3  
Old March 2nd, 2005, 03:55 PM
freeturkeys freeturkeys is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 3 freeturkeys User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 m 42 sec
Reputation Power: 0
Quote:
Originally Posted by Mr_Jones
You would need to split the db into a back end (database) and front end (forms etc) for more than one simultaneous user. Look this up in the Access help for info.


how would i go about accessing just the form instead of the whole database at once? i'm very new to the whole access thing in case you havent noticed. what i have done so far is simply make a shortcut on the desktop of each computers that points to the .mdb file over the network with the switches that are used in the shortcut the id maker software made on that computer... i'm not totally clear on whether or not the forms are part of the .mdb file or if they are seperate files... any help is much appreciated.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > access database synchronization


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT