Search results

  1. E

    How to allow a user access to only one query of my DB?

    Here is an article from www.unsoftwareag.com: ACCESS ONLINE ENCYCLOPEDIA Article Code: S4 Security of the backend tables ? PROBLEM If you activate the security system on the frontend all database objects are securized. In a split application all tables from the backend file are linked into...
  2. E

    Background image size blowout

    The reason for the bloating effect is the fact that ACCESS stores JPGS and GIF internally as BMPs. Have a look at www.unsoftwareag.com/togwa.htm for alternative solutions.
  3. E

    Can I run Access without having Office?

    Overview about runtime issues ACCESS ONLINE ENCYCLOPEDIA www.unsoftwareag.com Article Code: D1 Runtime issues: an overview Transforming MDB files into EXE files It is definitely not possible to transform a MDB- or MDE-file into an executable file since the MDB and MDE-files contain dynamic...
  4. E

    Running a DB without spending £300

    Runtime for 200$ available The cheapest solution is still the MDT-installer that comes with the complete runtime for A2K. Have a look at www.unsoftwareag.com/tomdt.htm for the details.
  5. E

    Anyone Understand Spanish?

    Maria Estoy haciendo un programita para un supermercadito en Nicaragua. = I am about to create a small program for a supermarket in Nicaragua. Tengo todo listo menos una cosita que nose como hecerlo= I got everything togehter but one detail I do not know how to do it. Me gustaria mandarte en...
  6. E

    memory

    List of solutions: This is a wonderful article I found at www.unsoftwareag.com: ACCESS ONLINE ENCYCLOPEDIA 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...
  7. E

    Save data locally from a linked table remotely

    d Did you try to execute a maketable-query? But remember that these temporary tables will bloat your MDB according to their size.
  8. E

    Running a module from a macro?

    You can not "run" a module, since it is only a container for funcs and subs. Note that only public funcs and subs can be executed from the outside and that form and report modules can not contain public funcs and subs. Here an interesting article from the AOE (www.unsoftwareag.com): ACCESS...
  9. E

    Split Database

    Eventually you need to activate the security system. Be sure to read the MS white paper as well as the security related articles in the ACCESS ONLINE ENCYCLOPEDIA (www.unsoftwareag.com) Here is what I found about the FE/BE architecture: Article Code: G9 How do I split my application in...
  10. E

    question about opening a doc in Word

    You might store the DOC file inside a table thus becoming completely independant. The only problem is the bloating effect, in order to avoid it you need a special wizard like Word!with ACCESS.
  11. E

    combo boxes n images

    Alternative In strongly recommend that you use an Image control to display the graphic files. Furthermore, you should store the graphic file names in a lookup table (minimum e fields: Autonumber/shortName/FileNameWithPath) that feed the combo box: column(0) = displays ShortName column(1) holds...
  12. E

    Internet Mysteries

    These are the tools you need: 1. Thorough HTML and DHTML knowledge 2. Excellent ASP knowledge 3. JAVASCRIPT to simulate the intelligence of the ACCESS forms 4. CSS for the graphic interface 5. Intensive testing for performance and security, backup strategy The list is definitely not complete...
  13. E

    Storing images in Access?

    You can store the photos, but you need a special wizard, here is a link with some alternatives: www.unsoftwareag.com/togwa.htm I use this system since more than one year, integrated it in 4 applications and I am very happy with it.
  14. E

    Application Distribution

    You have a security problem I strongly suggest that you change the architecture of your application: The frontend has to be a MDE in order to protect everything except the tables and macros. Install one copy of the FE on each client. If you want to more security, you have to read the MS white...
  15. E

    Can an access database run alone?

    There is plenty of information about the runtime issue in the ACCESS online encyclopedia at www.unsoftwareag.com
  16. E

    My Access Application as an EXE???

    The runtime version of Access2000 is still available with the MDT2000 toolkit at www.unsoftwareag.com/tomdt.htm ! Not only that it is way cheaper than the Developer version, but it comes with a much better installer than the "PDW".
  17. E

    Pictures

    There is plenty of information about this topic in the ACCESS Online Encyclopedia (www.unsoftwareag.com) and www.unsoftwareag.com/togwa.htm.
  18. E

    linking access to word

    You could also store the DOC-file inside the table, but in order to avoid the bloating of the MDB you need a special wizard. I use Word!With ACCESS from Universal Software since 2 years but there might be others.
  19. E

    Compacting a growing 2000 mdb

    The problem is definitely the temporary tables. Once they are deleted they still require space inside the MDB file. Only compacting (releases up to 80%) or decompiling (releases 100%) will help. I strongly suggest that you de-locate your temporary tables either in a linked MDB or - MUCH better -...
  20. E

    Working vs Not Working

    This is the no.1-problem with Access 2000: Check the references in the VBA window. One of them will be marked as "missing". The only solution is to re-link the defectous reference. If you want to avoid this problem then you need to make sure that the referenced files have all the same: -size...
Back
Top Bottom