Converting .MDB to .MDE

[narasareddy]

Hai All,

i am new in Access. i am creating the .MDB Format. but that database is very Slow. thats why i am converting to .MDE Format. How to Conver and how to Connect the Data Source( ODBC ).

pls Help ASAP

Thanks & Regards

 

[namliam]

Converting MDB to MDE will not help your speed anything.

Linking data can be done using the Linked table manager (without use of ODBC).

 

[narasareddy]

thanks for reply

how to use Link Tables and whats the purpose of Link tables

 

[narasareddy]

how to create the linked tables

Hai all,

how to create the linked table and whats the purpose of linked tabled.

i want to speed up the database( .MDB ).

any help

thanks & Regards

 

[boblarson]

If you are connecting to another database for your tables then this might help:
http://www.fmsinc.com/free/NewTips/Access/LinkedDatabase.asp

And, this might help too:
http://www.granite.ab.ca/access/performancefaq.htm

 

[namliam]

Hai all,

how to create the linked table and whats the purpose of linked tabled.

i want to speed up the database( .MDB ).

any help

thanks & Regards

A linked table is a way of having data in a secondary database, be it Oracle, SQL Server or simply another Access database.

To actually speed up the database there may be different roads that can be taken.
1) redesign it
2) Create indexes
3) Smarter/more efficient coding
4) Put the data into a "bigger" database like Oracle

All depends on what you have... and/or what your DB will be.

 

[narasareddy]

update statistics

Hai,

Thanks for Reply.

i created indexes but no Speedup. HOW TO UPDATE STATISTICS IN DATABASE OR TABLES. AND HOW TO RE CREATE THE INDEXES.

one thing i am SELECTING ONE STATEMENT. LIKE

SELECT EMP_CODE FROM EMP;

INDEX IS CREATE INDEX XEMP ON EMP(EMP_CODE);

i am running the Select Statement. how to see the its taking(XEMP) the index OR not. HOW TO CHECK.

plz help ASAP

Thanks & Regards

 

[namliam]

You are basicaly selecting everything from the table, therefor an index will not be used.
A query like this should not take that long, as access normaly only fetches enough to fill the first (few) screens of information.