You shouldn't see any major issues as long as your publications are all transactional or snapshots and the subscriptions are push. I worked with a SQL 2000 Publisher and...
After a fair bit of testing, it appears the Merge replication is working just fine as a separate publication, and has no adverse effects on the existing Transaction replication, in...
I take it the password is set on the VBA project in your Access front-end. If your backend tables are in SQL Server, and the front-end isn't doing table...