Dear friends,

I have found a problem in MS Access with field type changing from "text" to
"memo".
If any one have some idea regarding this, please help me.

Thanks,
Rgds,
jasa

It would help if you describe the problem you are experiencing ...

--
HTH
Van T. Dinh
MVP (Access)



"jasa" <jasa @discussions.microsoft.com> wrote in message
news:67D3BD88-4052-40B0-A10A-(E-Mail Removed)...
> Dear friends,
>
> I have found a problem in MS Access with field type changing from "text"
> to
> "memo".
> If any one have some idea regarding this, please help me.
>
> Thanks,
> Rgds,
> jasa

Dear Sir,

Thank you for the kind reply.

OK…, let me explain my problem.

We have developed a SFA (Sales Force Automation System) using MS Access for
the PC database with VB 6 and HandBase 3 as the PDA database. Everyday data
are transferred from access to Handbase and Handbase to access.
Sometimes we have noticed that some fields we defined as "text" in MS Access
had been changed to "Memo" after data transferring from Handbase to access.
Also in the same time related fields of the HandBase had changed to type
"Note" (“Note” is a field in the Handbase, field size is bigger than "text").
So I am doubtful when transferring data form access to Handbase this thing
was happened.

Thank you.

Regards
jasa



"Van T. Dinh" wrote:

> It would help if you describe the problem you are experiencing ...
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "jasa" <jasa @discussions.microsoft.com> wrote in message
> news:67D3BD88-4052-40B0-A10A-(E-Mail Removed)...
> > Dear friends,
> >
> > I have found a problem in MS Access with field type changing from "text"
> > to
> > "memo".
> > If any one have some idea regarding this, please help me.
> >
> > Thanks,
> > Rgds,
> > jasa
>
>
>

It sounds to me that you are using a JET database to hold the data, not
Access as a GUI ... If that is the case, you should search Microsoft Web
site for updates for JET, not Office ...

Check your VB code, HandBase and PDA database doc to see whether you are
using JET 3.5 or JET 4. I haven't seen any update for JET 3.5 for a while
(since mainstram support has ended) and JET 4.0 is up to Service Pack 8.

If you are using JET 4.0, for more info. see the following article:

http://support.microsoft.com/kb/275561

I don't know PDA database but I can't see how updating data in an existing
JET Table from a PDA database can actually change the Design of the JET
Table (e.g. changing Field data type) unless in updating JET data, your PDA
database actually deletes the existing JET Table and then imports the data
into a new JET Table with the old name. (Another possibility is the PDA
database modifies the JET Table design using DDL SQL but I doubt any PDA
database would do this). In this case, you will need to check your PDA
database documentation to synch. data by updating existing JET Table rather
than delete and re-create the JET Table ...

--
HTH
Van T. Dinh
MVP (Access)



"jasa" <(E-Mail Removed)> wrote in message
news:3DE13D93-9539-4816-A697-(E-Mail Removed)...
> Dear Sir,
>
> Thank you for the kind reply.
>
> OK., let me explain my problem.
>
> We have developed a SFA (Sales Force Automation System) using MS Access
> for
> the PC database with VB 6 and HandBase 3 as the PDA database. Everyday
> data
> are transferred from access to Handbase and Handbase to access.
> Sometimes we have noticed that some fields we defined as "text" in MS
> Access
> had been changed to "Memo" after data transferring from Handbase to
> access.
> Also in the same time related fields of the HandBase had changed to type
> "Note" ("Note" is a field in the Handbase, field size is bigger than
> "text").
> So I am doubtful when transferring data form access to Handbase this thing
> was happened.
>
> Thank you.
>
> Regards
> jasa
>