I have a table where I connect an item(text) to its picture
(Ole Object).  When I populate the Picture column I do not
see the path to the picture just the program used to open
it.  Moving to a different computer, when I populate the

When I try to insert a picture in table, access won't
insert it as an object but will insert as package.  I've
tried to reinstall program and install filters in custom
install.

I have a VB and S access application. In the database, there is a filed of
type memo. It contains long text, out of which I want to
retrieve a part, using the SQL statement in my VB to get recordsets.
Suppose the data in the memo field contains a name in single quotes, which I

Is it possible to use an Access 2000 adp with MSDE2000 (or MSDE2000A) ?
Or do I need to update something like MDAC ?
Is there some restrictions or problems compered to use Access 2000 adp with
MSDE 1 ?

Using A2K adp and SQL 2000.  I've got a SQL table with a field called
"Attended" which is a bit data type.  In my adp frontend, I've got this
field displayed on a continuous form (actually a subform) as a checkbox.
Some weirdness happens when checking/unchecking this box... ...

Can't get my stored procedure to return the value I want.  
When I hard code the criteria of the WHERE statement, all
is fine.  When I use a variable, it returns nothing.
The Sproc looks like this:

Can someone tell me if MS made any major (or minor) changes to the DIW from
2002 to 2003? I'm trying to learn how the DIW works for the first time and
found a tutorial on the one for 2002. The catch is: I just upgraded to 2003!
Thanks.

Can the MSDE perform OLAP processing using the MS OLAP cubes, etc.?
If not, can the SQL Server Developer's Edition?
Thanks,
MGFoster:::mgf00 <at> earthlink <decimal-point> net

I have recently develop a small database for my friend to record sale in
restaurant. Can I use Chinese character with Access field?
SF

What version will support replication? Will the Developer edition of SQL do
replication ?
Tom

I'm trying to determine in my machine has a trial or live version of SQL.
Anyone know how to tell which version I have?
Tom

Hi... I am trying to design my first Data Access Page in MS
Access XP and I have a really simple syntax question.  I
need to know the proper syntax for Microsoft Script for the
following:

I am thinking to move my MDE-MDB apps to ADE-MSDE. I
use 'local' tables in my mde app (tables not linked) for
data concerning to the app, how I create local tables in a
ADP.

Everytime I upsize to MS Accesss ADP from MDB to SQL Server 2000, I have one table that I cannot add new records to.  The Primary key field for the table is just like the rest.
In the table  I'm using "Autonumber" to add new records, however the "Autonumber" box does not plug in a ...

i an trying to setup a dic. DB in access, but the Host
server uses Mysql "witch i know nothing about" it is
talking about something called "ODBC" how can i set this
up to work. and is there a step by step totor. that i can