Looking for a simple server-intranet solution.

C

CWH

I have created a user.mdb where data is entered into a variety of forms
(stored in tables). I have several people using the user.mdb independently on
there own laptops. In this db I have created a VB command that uses DoCmd.
TransferDatabase which exports data the User selects into a transfer.mdb
(receiver database).

I have created an admin.mdb with append queries which imports the data from
transfer.mdb databases (those submitted by the Users). The admin.mdb database
is designed for an Administrator to view data and print records etc.. The
admin.mdb is also designed to allow data entry, modify & delete.

Example: User.mdb (downloads data)---->transfer.mdb-->Admin.mdb (uploads data)


I would like to put the admin.mdb on a network server. And find the simplest
way to continue to upload data from the user.mdb databases (they will remain
on laptops). I would also like the admin.mdb while on the server to let the
Administrator view reports and if possible continue to allow data entry,
modify & delete.

Any suggestions would be appreciated. Many thanks…
 
J

Jerry Whittle

I think that you may have reinvented the database wheel. Check out
Replication in Access Help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Tables and Appending Data From Temporary db 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Using Styles In An Outline 0
Newbie looking for advice on sharing a database. 0
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
vlookup excel and access... 0
vlookup from excel to access 4
Looking for a simple solution 3

Top