Hi everyone,
I'm not sure if this is the right forum but hopefully someone can help me.
I have written a flash program which uses asp to integrate with an access database. I have a local database on my machine and would like to have a master database on another machine.
I would like to be able to add and delete records from the master database and have these reflected in the local database without having to download the complete master database each time.
At the moment I use a revision number category in the each database and each record has a revisionID. When i run an asp file that I have created, it checks if the revision on the master database is greater than the one on the local machine. If it is, then it runs a query to find all of the records with the missing revision numbers and downloads them. It then changes the local database revision number so that the asp file knows it is up to date.
The problem I am having problems with is the deleting of records. If I delete records on the master database, Im not sure how to reflect this onto the local database. I could use an identifier such as having the revisionId = -1, and this would tell the local database to delete that record. The problem with this is that i would still need to keep those records in the master database. This could result in quite a large database as I would have the records valid records and the deleted records(with revisionID = -1)
Does anyone know of an easier way I can delete a record in the master database and have it delete the same record in the local database?
Sorry about the very long post. I hope it makes sense.
Thanks
I'm not sure if this is the right forum but hopefully someone can help me.
I have written a flash program which uses asp to integrate with an access database. I have a local database on my machine and would like to have a master database on another machine.
I would like to be able to add and delete records from the master database and have these reflected in the local database without having to download the complete master database each time.
At the moment I use a revision number category in the each database and each record has a revisionID. When i run an asp file that I have created, it checks if the revision on the master database is greater than the one on the local machine. If it is, then it runs a query to find all of the records with the missing revision numbers and downloads them. It then changes the local database revision number so that the asp file knows it is up to date.
The problem I am having problems with is the deleting of records. If I delete records on the master database, Im not sure how to reflect this onto the local database. I could use an identifier such as having the revisionId = -1, and this would tell the local database to delete that record. The problem with this is that i would still need to keep those records in the master database. This could result in quite a large database as I would have the records valid records and the deleted records(with revisionID = -1)
Does anyone know of an easier way I can delete a record in the master database and have it delete the same record in the local database?
Sorry about the very long post. I hope it makes sense.
Thanks
