Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / April 2005

Tip: Looking for answers? Try searching our database.

Error selecting data from replicated table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lothar Geyer - 19 Apr 2005 09:45 GMT
I just got an error message when reading data from a replicated table.
The SQL statement is

sql = "Select DISTINCT p.*, f.Firmen_Nr, f.Firmen_Name" _
    & " From Projekte p, ProjektPartner pp, Firmen f" _
    & " Where p.ProjektID=pp.ProjektID" _
    & " And f.Firmen_Nr=p.FirmenNr"

The message (I get it in German) is number -2147217887 and like "If you
select distinct values (s_ColLineage) no Memo- or OLE-object must be
included."

What's with this message? Is this due to the p.*?

Lothar Geyer
Cheval - 19 Apr 2005 23:15 GMT
Memo fields cannot be indexed or grouped by. They even have to have their
own system replica fields to deal with them. Yes.

I just got an error message when reading data from a replicated table.
The SQL statement is

sql = "Select DISTINCT p.*, f.Firmen_Nr, f.Firmen_Name" _
    & " From Projekte p, ProjektPartner pp, Firmen f" _
    & " Where p.ProjektID=pp.ProjektID" _
    & " And f.Firmen_Nr=p.FirmenNr"

The message (I get it in German) is number -2147217887 and like "If you
select distinct values (s_ColLineage) no Memo- or OLE-object must be
included."

What's with this message? Is this due to the p.*?

Lothar Geyer
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.