Re: Jet Replication in Access 2007

Peter <peter.grman@xxxxxxxxx> wrote in
news:9eaeee78-cd14-4214-acb1-361a756d4d09@xxxxxxxxxxxxxxxxxxxxxxxxxxx
:

Why are you using OLEDB?

I just take the connection string from the currentproject and add
a password and change the Data Source property to connect to the
other database, because i tried to connect to it, as it is shown
in the msdn, but it didn't work, so i tried it this way and with
access 2000 and 2003 it worked

so you mean the connection string is wrong, and i have to change
it?

I don't know how you manage to get an OLEDB connect string for your
current connection. Then again, I've never used any form of
ADO/OLEDB, so maybe I'm confused. I'd think your front end would
have linked tables (which are, by definition, DAO). Of course,
you're using JRO, which works counterintuitively, because it's one
of the ugly stepchildren of the ADO debacle.

I don't have any advice to offer, except to dump JRO, which never
made the slightest sense to me in the first place.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.