mde slower then mdb

[Aad Blom]

Hi there,

I have compiled my front-end database from mdb to an mde file. The mde
database is incredible slow compare to the accepable speed of the mdb
database. Does anyone have some suggestions? Thanks in advance

[Deano]

Aad Blom wrote:

Hi there,

I have compiled my front-end database from mdb to an mde file. The mde
database is incredible slow compare to the accepable speed of the mdb
database. Does anyone have some suggestions? Thanks in advance

Decompiling it would speed things up. I would read up on this area before
you rush into it though and of course work on a backup copy of the original
file.

[Allen Browne]

If there is a huge difference in speed, it is probably a factor such as:
- Name AutCorrect,
- SubDatasheets, or
- Caching of the connect property.

Details in Tony Toews' Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Aad Blom" <aa*****@centa.nl> wrote in message
news:bc**************************@posting.google.c om...

I have compiled my front-end database from mdb to an mde file. The mde
database is incredible slow compare to the accepable speed of the mdb
database. Does anyone have some suggestions? Thanks in advance

[david epsom dot com dot au]

or perhaps you have disabled Virus scanning for MDB's, but
not for MDE's ?? Or is it one particular query that is slower ??

(david)

"Aad Blom" <aa*****@centa.nl> wrote in message
news:bc**************************@posting.google.c om...

Hi there,

I have compiled my front-end database from mdb to an mde file. The mde
database is incredible slow compare to the accepable speed of the mdb
database. Does anyone have some suggestions? Thanks in advance