help needed to convert .mdb to .mde

[asuni]

hi all,
I am using access 2003. I need to convert .mdb to .mde. How i don't know. i am new to this. Any help please.And how to create ODBC for .mde file. which drivers have to use.
Thanks in advs

 

[KenHigg]

Tools->Database Utilities->Make MDE File

 

[Guus2005]

Try Tools|Database Utilities|Make MDE file.

Keep a copy of your mdb file!

 

[asuni]

Thanks to all but how to create ODBC for .mde file. which drivers have to use.

 

[Guus2005]

You have to create a System DSN which is computer bound, not application bound.

 

[asuni]

ya, but which driver i have to select. For .mdb i used to select Driver do Microsoft Access(*.mdb). For .mde which driver have to select.
Thanks

 

[Guus2005]

No need to create any drivers, because Access is native to Access. What backend database do you use? Oracle, MySQL, SQL Server? In that case use the ODBC you have already created. You don't need to create a driver for an MDE file because an MDE file is still Access. Code and Forms are shielded and fixed but tables and queries are still accesible.

Enjoy!