Our company use Orbit Front software for the drawings database data entries. it base on Access.
all drawing store in Access. Orbit Front software is limited license, hence I
create another database in SQL Server 2000, I every month export the Access data to
SQL Server manually. by the intranet all employees get the drawings information.

How I can export (move or link ) Access database to SQL Server ?
that it automatically export (move) Access data to Sql Server ?

daily entries are going on in Access database.

when I create link Access to Sql Server, it make
dbo_archive , in the table name,

archive is the table name in Access. when table name change ie
archive to dbo_archive , it create problem in data entries in Orbit Front, because
Orbit Front's table name changed.

hence it is not possible to generate like by ODBC Access to Sql Server in this case.

my question is that how can export (move) Access Data to Sql Server that
when do data entries in Access it also store (save) in Sql Server ?

Any help, procedure (method) please.

regards.

Mateen

You are getting "dbo.archive" because it is showing who owns that object. You can use DTS to insert the data to your SQL table and schedule it to automatically do this for you.

Thanks.

I need to export data from Access to SQL. Can i use DTS for this ...I need to automate the process so that its done evrytime there is an update in access table
  Please help
Thanks

Yes.. and next time start a new thread