 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / October 2005NEED ACCESS SOLUTION QUICK!
I and a coworker have taken over a process from consultants where we work to produce 1 report where the all of the data is kept in Access. The way the process was formed, we each have many separate databases, stored locally, that we update manually or import in Excel spreadsheets.We then send each other spreadsheets via email and have to import these excel spreadsheets into each other's databases in order to produce an interim report so the other coworker can complete their process. It's NUTZ! Does anyone know of a good and more seamless solution where we can consolidate our records, databases, in order to produce this one report. We are open to all types of Microsoft Technologies Thanks One database with all the tables, and a copy of the front-end database on each users machine which is linked to the common back-end. Basic stuff...  SignatureKevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm >I and a coworker have taken over a process from consultants where we work >to produce 1 report where the all of the data is kept in Access. The way [quoted text clipped - 8 lines] > > Thanks Good solution - IF all your users are on the same LAN. Otherwise, you may want to look at replication... > One database with all the tables, and a copy of the front-end database on > each users machine which is linked to the common back-end. [quoted text clipped - 13 lines] > > > > Thanks Access replication...<shudder> I'd go with MSDE/ASP before I'd touch Access replication again....:-) SignatureKevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm > Good solution - > IF all your users are on the same LAN. [quoted text clipped - 20 lines] >> > >> > Thanks > Access replication...<shudder> Replication, I contend, is "not for the faint of heart", but several regulars in the USENET newsgroup comp.databases.ms-access say that it _can_ work, if absolutely necessary. Larry Linson Microsoft Access MVP Are you on a network? SignaturePC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com If you don't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. >I and a coworker have taken over a process from consultants where we work >to produce 1 report where the all of the data is kept in Access. The way [quoted text clipped - 8 lines] > > Thanks > Are you on a network? These 1000 (if at all a real figure..) is only the result of -- 4 years abusing the newsgroups. -- 4 years blatantly advertising and jobhunting. You just don't care about the newsgroups. You have no ethics at all. You only care about making money, and you act as if the groups are your private hunting ground. -- You abuse this group and others for job-hunting and advertising over and over again -- You are insulting lots of people here when they ask you to stop this -- You posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions (the latest 'star's': 'Access Resource' and Tom notmy@email.com) -- You try to sell a CD ($125,--) with FREE code you gathered from these groups here -- There even has been a 'Scam-alert' about you which has been explained recently in the thread 'To all': http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en -- Also recently it became clear that you have been spamming innocent people asking questions: http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en So why would ANYBODY ever trust a person like you and hire you? ******************************************************** To all: Explanation and more on this answer to Steve: http://home.tiscali.nl/arracom/stopsteve.html Arno R |
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.