Recent content by ElsVanMiert

  1. E

    HTML web form to Access input

    Yes, it is possible for ACCESS to read OUTLOOK e-mails but the format has to be standardized since it is read sequentially. Refer to the OUTLOOK object model for the exact syntax.
  2. E

    Can I create a recordset that is global for each user on a multiuser application?

    Recordsets are stored in the computer's RAM, consequently it can only be read on one computer. You need to store this RS as a temporary table in the BE MDB in order to make it accessible for all users of your application. Alternatively (and to avoid the bloating of the BE) you could write a CSV...
  3. E

    Running out of memory.

    Here is the reason and some solutions for the problem: ACCESS ONLINE ENCYCLOPEDIA www.unsoftwareag.com Article Code: G3 Why insufficient memory ? Description You can have installed lots of RAM (128 MB and more) on your machine but nethertheless ACCESS crashed after a short period of time...
  4. E

    Linking Access db with streaming

    There is a special wizard for Access 2000 available that allows you to store any video file inside the table structure without bloating the MDB.
  5. E

    Argh!

    If you want a fast solution: Create a new MDB and import all database objects from the original (attention: references and links). The longer solution works with VBA: Open the VBA window with ALT-F11 and restore the MDB settings with the appropriate code (I tried to find it on my HDD, but did...
  6. E

    Multiple OLE Objects in Report

    If you do not manage to make the report display the OLE's properly (it is certainly an ACCESS bug) you might consider to mis-use a form as a report and print it this way.
  7. E

    30 Minute Average Report - HELP!

    I would simply store the data in an ACCESS table and do the calculations only when the report has to be printed or displayed on the screen.
  8. E

    Multiple OLE Objects in Report

    I strongly suggest that you give up the unbound object frame and work exclusively with image controls. Have a look at www.unsoftwareag.com/togwa.htm for alternative solutions, too.
  9. E

    Customizing an Access 2000 Runtime installation

    Apparently you found the perfect solution for this problem.
  10. E

    security of MDB file...

    Since your problem is the security of the tables in the BE, here the corresponding article from the ACCESS ONLINE ENCYCLOPEDIA at www.unsoftwareag.com Article Code: S4 Security of the backend tables ? PROBLEM If you activate the security system on the frontend all database objects are...
  11. E

    PDW and Setup

    We had the same problem with Win95 computers and finally we install the A2K runtime (that has LESS (!) bugs than the XP version) on these computers.
  12. E

    Customizing an Access 2000 Runtime installation

    The missing part: ... is closed from A2K to A97.
  13. E

    Customizing an Access 2000 Runtime installation

    The problem is that Windows automatically updates the Registry settings for MDB files once you use a certain version of ACCESS. The only solution is to write an exe or vbs that changes these settings once A2K runtime is closed.
  14. E

    Working on a DB while client is using it?

    Here is an article from the ACCESS ONLINE ENCYCLOPEDIA at www.unsoftwareag.com concerning Frontend/Backend architecture Article Code: G9 How do I split my application in frontend and backend? PROBLEM If all database objects (tables, queries, forms, reports, macros and modules) are located...
  15. E

    Communicating in background - DDE?

    IE can not work as a DDE server, you need to use the OLE object model(see IE documentation on www.microsoft.com) to access to its functions.
Back
Top Bottom