HOW to import data FROM web server MS access database to Offline MS Access Database

Hi all

I have a question.

What i have?
I have a MS Access database, Online.mdb, residing on a web server.
I have a offline database, Offline.mdb, residing on my computer, offline with internet connection.

Scenario:
The database(Online.mdb) residing on the web server will capture daily sales orders and customer records.

Task:

I need to specify a connection from the offline database(Offline.mdb) residing on my computer TO the Online.mdb, database which resides on the web server.

How do i go about doing it?

I read alot on ODBC... but, i dunnoe how?
Bearing in mind that the Online.mdb resides in the web server.
I need to download data from web to offline.
Both are using MS Access, I cant use mySQL/ MSSQL.

Please teach me to connect to it... I cant seem to figure it out...

Thanks!!

Rdgs
James

You link to it as you would to any other Access db. Files/Get External Data - just type the UNC path to the db in the file box.

Pat Hartman said:

You link to it as you would to any other Access db. Files/Get External Data - just type the UNC path to the db in the file box.

Click to expand...

Hi... I dun get this part... What is UNC path? How to get it?

//server name/path/db name