NEED ACCESS SOLUTION QUICK!

I

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
 
P

PC Datasheet

Are you on a network?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
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.
 
M

MacDermott

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

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
 
Top