NEED ACCESS SOLUTION QUICK!

[ibeetb]

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

 

[Kevin3NF]

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...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[PC Datasheet]

Are you on a network?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
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.

 

[MacDermott]

Good solution -
IF all your users are on the same LAN.
Otherwise, you may want to look at replication...

 

[Kevin3NF]

Access replication...<shudder>

I'd go with MSDE/ASP before I'd touch Access replication again....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[StopThisAdvertising]

Are you on a network?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
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.

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 (e-mail address removed))
-- 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

 

[Larry Linson]

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