Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Francescina

    Access security, is there a way...

    It is possible that your MDW does NOT contain an user with administrator rights. This means that the developer of the application has completely applied the "double-MDW" security improvement I always recommend. If you do not get hold of a MDW that contains a real administrator (or...
  2. Francescina

    Super .mdw file surpasses all security

    Korngeek, Your question: How do you allow them to create new users and set their permissions without allowing them to get into protected areas of the program? The answer: Only users with adminstrator rights (to EVERYTHING) can create new users. If you absolutely need this feature then you have...
  3. Francescina

    Office XP-worth buying????

    Deploying applications with ACCESS is nearly as buggy in A-XP as in A2K. Have a look to the runtime-related articles in the ACCESS online Encyclopedia on www.unsoftwareag.com. Since my new computer was delivered with A-XP I use A-XP to develop the new applications but I stay with the A2K...
  4. Francescina

    seperating data from database

    Apparently one of your references is not correctly set and thus VBA can not find the function.
  5. Francescina

    Super .mdw file surpasses all security

    Fireviking, There is only one possible explanation for this behaviour: You did not delete all rights from the standard user and admin (both users AND groups) and replaced them with custom admin and users. This is why as soon as any standard MDW is used (containing the standard admin and user...
  6. Francescina

    Clients not paying for mods - anything code available?

    The Windows Registry can be modified from within ACCESS by three ways: 1.) GetSetting and SetSetting give you Read/Write to a certain area of the Registry (see online help) 2.) API calls allow you full access to everything in the Registry but are a pain in the *** to program. 3.) Using the...
  7. Francescina

    hide database?

    You might also create a "prison" form that opens automatically and gives only access to certain options and once it is closed or minimized the application quits automatically.
  8. Francescina

    MS Access queries transaction

    As far as I know Your transaction will only work with VBA, not via the properties of the query in the database window. Is your MDB file located on a web server? In this case you need to use ASP/ADO features.
  9. Francescina

    hide database?

    Your "full permission user" will be able to change the data but not the table's structure.
  10. Francescina

    Need Help on Multilanguage

    Since Access2K is using UNICODE there is no problem to store chinese in a table field. But since I do not use Chinese or any other language using non-latin characters I can not help you any further. You might need to read Michael Kaplan's book on VBA's Internationalization to understand how...
  11. Francescina

    Making a Read Only database from an editable database

    I fear that the only professional solution is to activate the security system on the database.
  12. Francescina

    Password Protecting Specific Records

    Either you create a new table 1:1 that contains the record ID and its password or your table structure needs a supplementary field "Password". In either case you need to check via VBA before exposing any record whether it is protected or not. If so, you need a PW-checking routine...
  13. Francescina

    Bar Codes with Access

    ACCESS ONLINE ENCYCLOPEDIA ( www.unsoftwareag.com ) Article Code: G8 ACCESS and Barcodes ? Problem In many applications, such as POS or member administration, Barcodes are a great help since you can read articles with a scanner: The execution speed increases The number of errors decreases...
  14. Francescina

    Usernames & Passwords

    Have a look at the MS white paper on security and the security related articles in the ACCESS Online Encyclopedia at www.unsoftwareag.com
  15. Francescina

    Consolidate three remote databases

    In general terms: 220.000 records is not a big quantity for ACCESS, I am working with tables containing more than 1.5 million records. If the MDB is working with 150.000 records this is a very good sign concerning its design so do not be afraid to accumulate their data. If you want to have...
  16. Francescina

    MS Access queries transaction

    Yes, as far as action queries are concerned, but you need to give us more details about your project. Otherwise you can not expect a detailed answer.
  17. Francescina

    Linking an ADOBE document to an Access Database

    Hm, this is a very interesting question. I suppose that you have to inquire about the possible data exchange between the ADOBE-PDF- object-model and ASP-ADO (maybe XML?). I think that this is not impossible and the only competent company to answer this question should be ADOBE itself. Please...
  18. Francescina

    Runtime for an Access 2000 database

    You can still find the A2K runtime (I think even in German) with the MDT-installer for less than 300$ at www.unsoftwareag.com/tomdt.htm
  19. Francescina

    Clients not paying for mods - anything code available?

    Since "evil" customers will easily find out about your checking the system date they might just change their system date and your code no longer works. Therefore I strongly recommend that you install a double security for your reminder system: first, check a special (your custom) key...
  20. Francescina

    Where can I get Access XP runtime? thanks

    Alternatively (much less expensive!!) you can use the A2K runtime (just same the MDB in A2K format). Then you can find the A2K runtime for less than 300$ at www.unsoftwareag.com/tomdt.htm

Part and Inventory Search

Back
Top