Replication

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Is there any way to make replication between one computer with MS
Access and access file placed on the laptop but without access.
The problem is that I wish to have replication on demand from laptop
where are reports in Excell generated on the base of access files.
The problem is that I dont have access on laptop, is this possible ???

regards
PK
 
You can use Excel to connect to and read Access tables, but the connection
must be live, not replicated. If the data is one way only, it is very easy.
If not, I suggest that you use Excel to connect to the most current Access
data on the laptop, then periodically link the Excel worksheet back by
saving it when the network connection is resumed. Use a query to
update/append data back to the Access tables.

Adding a copy of Access (about US$100 for the upgrade) to the laptop is the
best alternative. Then you can use Access replication.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 

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

Back
Top