How (1 Viewer)

[hussain]

I have 2 Access Database, one located in our Company network, and the other one is in our Internet Web site.

the internet database include only tables.
the other one contain tables, forms, reports ..etc.

The two databases should contain the same data. the problem is that the two database updated separately, which mean they will have different data.

The suggested soloution is to centerlize the database on the internet and link the network database to it.
the question is, Is it possible, if so, HOW???

i hope that was clear.

 

[Newman]

Here is what you should do:
(Notice that I have the french version and the words I use for menus may be different from yours, but should mean the same)
First, don't put any tables in your company network database.
Use the File menu... OutsideDatas... LinkTables.
Then use the next window to locate the network where lies your Internet database and click OK.
Finally, Click SelectAll and OK in the next window. You'll be linked to the same tables with both databases.
Hope that help!
Newman