Posts by debasisdas

494

App.path is not set in MDB file.

you need to set that in your VB code

ex--

ConnectionString = App.Path & "\MyDB.mdb"

You only need to change your connection string not the reference.

http://www.connectionstrings.com/mysql

You can also try using Base64, also known as MIME encoding, translates binary into safe text. It is used to send attachments in email and to change small bits of unsafe high-character data into stuff that is a lot nicer for text-based system.

478

478 :-O

Since MySQL is open source, you may not get enough help on the same in net as compared to Access.

478 :D

478 :cool:

478

You need to use MSComm Control.

@juve

which part you are are unable to interpret ?

Now a century in half the number of balls.

Fastest in world cup.

I clicked on a PM and got this.

Invalid Private Message specified. If you followed a valid link, please notify the administrator

Welcome back.

406

God asks no man whether he will accept life. That is not the choice. You must take it. The only question is how.

~Henry Ward Beecher

406

392

Hi Jaskaran,

Welcome to Daniweb.

Mahatma Gandhi, father of the nation in my country.

Records start tumbling.

Another hat-trick.

This is Malinga's second hat-trick of his career and in World Cups as well.

386 :sweat:

What you think post #3 is ?

If you are familiar with vb6 coding for database, mysql is no different from other DBMS.

No homework / assignment please.

You need to do a lot of other work before starting actual data migration.

1. Field mapping.
2. checking for data type compatibility
3. how to handle LOB columns

etc...

Why not use an unique id to each DVD , instead of repeating the name. That is a beter and effecient design.

History started repeating, hat-trick in world cup.

386

In your case ,all depends on how much you can afford to spend.

and i don't think all versions of office is shipped with Access.

You can look for something like MySQL.

A trigger is what you are looking for.

386

After scoring 676 runs in 99.5 overs for the loss of 18 wickets in over 7 hours, What you get is a tie. This is 4th tied match in the history of cricket world cup.

386

384

Hi Paul,

Welcome to Daniweb.

Welcome to Daniweb.

Please post your question in the proper section only.

Also don't forget to mention what you have tried so far and where exactly you are struck.

388

Life is a series of collisions with the future.

Why not, they ended playing the semis in 2003.

Welcome aboard.

388

392

First of all you need to understand the complete architecture of both the source and target database.

and he proved it. :cool:

396

You need to pass only the desired record set to the report not the entire table.

@Ezzaral: He is secretly on our side. ;)

400

The Host.

There can never be any second choice.

Hi Sintex,

Welcome to Daniweb.

Its time for some big cricketing moments.