 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Conversion / May 2006Access Upgrade
Looking for a solution to move FROM an Access DB to something bigger and which can be multi-user. Currently uses a local Access DB (not networked) that is copied to the network so the next user can Access. Has anyone upgraded from Access to something more multi-user friendly? If you are talking about a wired ethernet local-area-network, with just a few dozen users, Access is perfectly capable. Just split the database so each user has a local copy of the front end, with tables linked to the shared back end. More info in: Split your MDB file into data and application at: http://allenbrowne.com/ser-01.html If you need to use Access on a wide-area-network, here is a good introductory article: Ms-access and WANS? at: http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html If you want to move up to SQL Server, Microsoft has heaps of information if you search for "upsizing".  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Looking for a solution to move FROM an Access DB to something bigger and > which can be multi-user. Currently uses a local Access DB (not networked) > that is copied to the network so the next user can Access. Has anyone > upgraded from Access to something more multi-user friendly? Access's default Jet database engine (the one that uses mdb file) has no problems supporting moderate numbers of users. How many will you have, and what sort of use will they be making of the database? >Looking for a solution to move FROM an Access DB to something bigger and >which can be multi-user. Currently uses a local Access DB (not networked) >that is copied to the network so the next user can Access. Has anyone >upgraded from Access to something more multi-user friendly? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. TÜRKÇE MESAJ YOLLAMINIZI ARZ EDERÝM..... > Looking for a solution to move FROM an Access DB to something bigger and > which can be multi-user. Currently uses a local Access DB (not networked) > that is copied to the network so the next user can Access. Has anyone > upgraded from Access to something more multi-user friendly? =========================================================================== FULL LEGAL SOFTWARE !!! Games, video, program, image, chat, questbook, catalog site, arts, news, and... This site it is full register and legal software !!! Please download and you must register software !!! PLEASE REGISTER SOFTWARE: http://www.webteam.gsi.pl/rejestracja.htm DOWNLOAD LEGAL SOFTWARE: http://www.webteam.gsi.pl Full question and post: http://www.webteam.gsi.pl Contact and service and advanced technology: http://www.webteam.gsi.pl/kontakt.htm FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm Please add me URL for you all site and search engines and best friends !!! Me site: SERWIS WEBNETI: http://www.webneti.gsi.pl PORTAL WEBTEAM:http://www.webteam.gsi.pl LANGUAGE: http://www.webneti.cjb.net ========================================================================== |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.