|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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!
|
|
#2
|
|||
|
|||
|
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.
|
|
#3
|
|||
|
|||
|
Quote:
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. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > access database synchronization |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|