Design option

[trandel]

Hi,

I have an existing desktop Access database for a Membership system which is working fine (+- 1000 members). We have an existing website that is also working fine and developed using Frontpage 2003 - due for conversion to Expression Web.

Challenge:

We want to offer a facility for members to update their details online via the website. That's the easy part - my query is how do I manage to synchronise both the desktop and the website DB? Replication seems to have disappeared with Access 2003.

New members would be added locally whereas updates would be handled either locally or remotely.

Any ideas very welcome.

Regards

Tony Randell

 

[boblarson]

Replication seems to have disappeared with Access 2003.

Not sure how you came up with this as I have 2003 and the replication is still there.

 

[dfenton]

Replication seems to have disappeared with Access 2003.

As Bob says, Replication is alive and well in A2K3. It's even alive and well in A2K7 (despite what you might hear), except you have to use MDB format (rather than the new ACCDB format).

Perhaps you mean that your MDB seems to have lost replicability in the conversion to A2K3?

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/