How do I send a MS Access Report or data over the LAN to another computer?

[scout78]

I am working on a project and I need to send some information from one computer in one room to a computer in another room that is on the same local area connection. I am using MS access and do not want to send it via email. I am trying to have a report with data appear on the other computer that I am not using spitting out info based on the information that entered into the first computer. Does anyone know how this can be done?

[bailey]

copy and past would be one way
ftp is another way
telenet is another one

[Tazzin]

Ok.. let me get this straight...
On one computer you have MS Access.. with data in tables etc.. and the reports you need. You want the other PC to be able to access just the reports from the other system correct?

[Tazzin]

I did this awhile back when I was working .. unemployed right now

First off .. within Access you can "split" your database... my database had nice forms and buttons for about 30-50 employees to enter and change data in. When you split the database.. you will have 2 parts. The actual Table data and the forms, reports etc. Think of the Forms / Reports etc as the Front End... where users can access the gui's and buttons.. etc. Think of the Table data as the Back End... where just the raw tables are stored.

Now that the Database is "split" ...whichever computer (within your local network) you put the Front End on will have access back to the Back End / table data. Note: If you move the Back End anywhere else on your system (besides copying it somewhere else for a backup) .. the Front Ends will not find it.

If you are worried about secuity from the front end. Then you should run the Users and Groups Security Wizards under the Tools Menu.

Hope this helps.
Taz

[scout78]

Tazzin, you are correct. I just have a system that updates the inventory on one computer. if there are any parts that are short, that appears on the report on the other computer. if you know of any easier way to get this done, feel free to let me know.

[Siliconjunkie]

put the access file in a shared dir, then open it from wherever.

[Tazzin]

duhhh.. lol.. good thinking Junkie..

If you go Junkies' route.. putting it in a shared folder.. only one user can access the file at a time.

[scout78]

I can't do that because I want to be able to use it at the same time on both computers. I want to be able to insert data on one computer and at the same time check for low part quantities on the other computer.

[Siliconjunkie]

Then you may need to use a real DB like MySQL with access as a frontend.

[Tazzin]

Scout.. you can do what I said .. split the DB... and put the front end on the PC you want to check the reports on.. and leave the back end and front end on the PC you want to put your data in.