default value

[Susan]

I have quoting software which contains an access backend. It is not possible
to move the location of this software's database file to my web directory but
I would like 4 of the tables to be contained in my website's database.

I have therefore duplicated the 4 necessary tables from database1 (quoting
software) to database2 (website's database) and now require that they be
backed up regularly into my database2 (website's database).

I assume it is not possible via Access to back up database files on a table
level rather than on a database level?

Can a programmer create an app to achieve this? If yes, what type of
programmer?

 

[Clifford Bass]

Hi Susan,

Basic question: Why cannot your web site get to the back end database
directly in the directory where it is located? It seems that is someone were
to create a process that can copy the data from the one place to the other,
that the other place can get back to the one place. In which case it is
merely a network security issue.

Clifford Bass