Re: Access has encountered a problem...

Greetings,

I couldn't find your "Form Filtering Problem" post, so I have a question
or 2 and some suggestions:

It sounds like you have a backend DB for the data storage. Is this
another Access mdb or a Sql server (Oracle) db?

If your backend is a server based db, you can simulate how you would
handle this with ADO.Net and pull your desired data into a temp table in
the local mdb (ADO.Net uses disconnected recordsets which is the same
thing as writing data to a table in the local mdb app from the backend
DB except that ADO.Net does this all in memory where the mdb writes
everything to the disk - which explains the substantial increase in
performance from ADO.Net over the mdb). Anyway, once you have the
desired dataset in the local app you can filter it very easily without
undesireable side effects.

If the backend is another mdb and you are having the problems you
describe, then try the same thing of pulling the desired data to the
local mdb as above.

Also, if your backend is another mdb, and it is approaching 500megs in
size and you are having these problems -- it is time to step up to sql
server (note: 500 megs is 0.0005% of the capacity of 1 sql server DB but
nearly 100% of the functional capacity of an mdb).

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Could not use Admin; file already in use.
    ... All users of the mdb need create/delete permissions on the folder where the ... with linked tables to the backend). ... Apparently the systems they tested the client server ...
    (microsoft.public.access.security)
  • Comiling problems
    ... selecting debug> compile all modules. ... I have an A2K 'backend' mdb on one PC, ... networked PCs each with a 'frontend' mdb that uses linked ...
    (microsoft.public.access.modulesdaovba)
  • Re: Adding a database to existing workgroup file
    ... Some don't even need the mdw to do so. ... the frontend on each person's PC. ... links to the tables in the backend. ... the database splitter on a secure mdb - the backend will end up unsecured. ...
    (microsoft.public.access.security)
  • Re: Security
    ... Did you add these new tables to the frontend, or a completely separate mdb? ... In any case, open the backend and use File, Import and import these tables ... You'll need to modify your shortcut, ...
    (microsoft.public.access.security)
  • 3197 record deleted error
    ... I get a strange behaviour when i do an INSERT INTO to a local Mdb table ... If the related table hasn't related record to the first table, ...
    (microsoft.public.sqlserver.odbc)