microsoft access not responding

  • Thread starter Thread starter Memo
  • Start date Start date
Memo said:
Creating an mde and Microsoft Access is Not Responding
Click to expand...

Try importing into a new MDB and see if that works. Also how big is
your MDB and how long are you letting this run? Have you recently
compacted your FE? Also try decompiling.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
 
mdb is small, 5 small tables and a few forms with simple code. However when I
try to create an mde it just hangs then the Not Respond message appears. It
is not a rights issue, I have tried this on the lan shared with rights and on
my home drive with same results.
 
Memo said:
mdb is small, 5 small tables and a few forms with simple code.
Click to expand...

Is this a single user application? What happens if you need to give
the users some new or changed functionality such as changes to a form?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
this relatively painless.. The utility also supports Terminal
Server/Citrix quite nicely.

Tony
 
Back
Top