Update table from a remote table

[snyperx3]

I have a database that someone will carry around with them on their laptop, and then there is the same database that is stored on the server at the office. These have to match. I created a button on the portable version that is supposed to execute a query. I have the tables on the portable version, and then the table that is at the main office is set as a Linked Table. Is there any way to use an update query to make these values match? When I try to execute my update query i get the following error :

Cannot join on Memo, OLE, or Hyperlink Object ([Tech Equipment Repair Log].[Ticket Number]=[Tech Equipment Repair Log_Office].[Ticket Number]).

Is there any way i can do this without having to write a bunch of VBA code??

-Pete

 

[snyperx3]

Im sorry. That was completely my fault.

I attempted to click "Number" for the type, and apparently my mouse slipped and I clicked "Memo". Please excuse my ignorance.

Its all good now. =]

-Pete