May 6, 2002 at 11:30 am
Hello,
Can I use a Access file as a publisher (DBASCMfg.mdb) on a remote server...mapped to a logical drive on SQL Server and then use transactional replication to duplicate the tables onto a SQL server database. Please let me know how. After going thru the book I can only see SQL server DBs using wizards on Enterprise Manager.
Thanks
Raghu
Raghu
Raghu
May 6, 2002 at 7:59 pm
I have never seen this work and do not believe you can do it directly. You might could setup a SQL server to act as mediate by pulling the data periodically makeing only chanes and publishing back out.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 7, 2002 at 6:10 am
I know that I have gotten merge replication between SQL and Access to work, so even if you can't get transactional to work you could go with this. MDB was local during my test.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply