Weird query error

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

We are currently running Access 2000 on our office
computers. We have a multi-user database which is
currently NOT split (we are in the testing phase of a
split). Two identical computers, with identical operating
systems (Win 98) and the same version of Access both try
to open a report. On one computer it opens fine. On the
other, we get this error: "Cannot use Memo, OLE or
Hyperlink Object field "FloorShipNotes" in the SELECT
clause of a union query." And the report just doesn't
open.

The two computers are running a shortcut to the database
which is held on our server (Win 2000 OS), and so there
is no way that they can have different information in
them.

What the heck? How do I fix this?

Thanks in advance,
Melissa
 
HI:

Just a thought: Is your database set to exclusive access, meaning one user
at a time? This will prohibit access to the table by another user if it was
previously opened by another user who has the database open now.
 
No, it isn't.

Normally if one user opens the database first and has a
report open, we get an error message saying something
about the database being locked on "(insert person's name
here)". This is different.

Any other thoughts?
Melissa
 
HI:

Is your memo field [FloorShipNotes] storing word, excel,photos or other
binary data? If so, MS recommends using and OLE object field. If its just
text under 255 characters use a text field.

help?


See the Access help for 'Should I creat a text or memo field'
 
Back
Top