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. PercyN

    Compact a password protected backend

    Hi lameid, I tried that but I still get that error "the database is open by another user..." And it happens right when it tries to execute the actual compact which is what baffles me because I would have thought that by creating a new DB and connecting to it, the existing DB should now be free...
  2. PercyN

    Compact a password protected backend

    Thanks lameid. The currentDB variable is a declaration in my function. It is not referring to the in-build CurruntDB function. Or did you mean because there is already an in-build function called CurrentDB, me declaring in in my function, causes a conflict? See my full code below: Public...
  3. PercyN

    Compact a password protected backend

    Hi, I'm trying to provide a code for compacting by BE. So the idea is to doe the following: 1. make a copy of the current DB just as a dummy 2. connect to the dummy in order to free the current DB 3. Compact the now freed current DB 4. Then reconnect back to the now compacted DB and then kill...
  4. PercyN

    Granting Folder Permissions to Users

    Hi, I'm using the code below on my spalsh form to giving permission to the folder in the folder that houses my FE and BE. This only runs, the first time the application executes on a computer after installtion. Seems quite straight forward, but it does not work. It works when I install...
  5. PercyN

    Access BE to SQL Database

    I have an access app I recently started to develop with nicely done FE and BE. My client however is worried that with 10-15 concurrent users generating close to 150 transactions per day will cause the database to start acting funny acting funny after a couple of years. He prefers an SQL...
  6. PercyN

    Limit number of concurrent Users connecting to the BE

    Hi, I'm working on a database for a client which I intent to offer on a "per-user-logged-on" license basis. So for instance he may create 1000 users if he wants in the users table but only 5 for instance can logon concurrently because thats what he paid for. What is the best way to go about...
  7. PercyN

    Backup Back end - compile error

    Thanks vbajock, but there is no code in the back end. Its all in the from end. I'm trying to back up the back end from the front end.
  8. PercyN

    Backup Back end - compile error

    Perfect! Thank strongm. Do you have any suggestions regarding using this for a password protected be?
  9. PercyN

    Backup Back end - compile error

    Ref: thread705-999475 This thread seems to be exactly what I need to backup my back-end but when I compile the code I get a "User-defined type not defined" error on: Dim fso As Scripting.FileSystemObject Am I missing something? Also if my back end is password protected, how can I tweek this...
  10. PercyN

    How to write an If Statement

    If Me!Status="Paid" then Me!BalDue=0 End if
  11. PercyN

    Compile error: Expected user-defined type, not project"

    I have this piece in my code in my split program: Dim db As Database When I compile I get an error message that says : Compile error: Expected user-defined type, not project" Can anyone please help with this?
  12. PercyN

    ESC key Cancels data entry

    Hi, I just tried that. Still cancels the data entry
  13. PercyN

    ESC key Cancels data entry

    Hi All, I have a form that is link to a table. On the form, when the user presses the ESC key in the middle of entering a new record, the entire record is canceled and the form resets to new. But I actually have a "Cancel" button which then asks the user to confirm the action before going ahead...
  14. PercyN

    How to connect to another copy of the same data bae

    Thanks Remou, this was very helpful but I actually want to do this in code, so that end users can connect to a backup copy for instance of the data base by simply specify the location of the new db.
  15. PercyN

    How to connect to another copy of the same data bae

    I have a program that I have split. It works fine because I dont have to move the BE (yet). If I ever do move the BE to another location or to a different server or for some reason I need to connect to another copy (e.g. backup copy) of the same data base, how do I go about?
  16. PercyN

    FileDialog Error in Access 2007

    Hi, I have tried to search for solutions to this problem but I keep getting solutions for Acess 2003 and below which does not work for me as I am using 2007. I am trying to open the file dialog box using the FileDialog method. I get an error on the first line where I declare my variable (fd) as...
  17. PercyN

    Ribbon Control Image Error (Invalid Picture)

    Thanks. I tried the first (shorter) method but when I compile, I get an error that highlightd "LoadImage" and says "Sub or Function not defined
  18. PercyN

    Ribbon Control Image Error (Invalid Picture)

    Hi, I am using the code below to upload images to my custom controls on my custom ribbon in acess 2007 but I keep getting this error message no. 481 "Invalid Image". When I try with a .bmp file it works but all my images are in .png fromat. How can I get around this? Function...
  19. PercyN

    How to disable Office Button - 2007

    Thanks for the tip PHV, I actually have been to this site before and though it has some very rich content on how to customize the ribbon it does not say how to diable the office button itself. I have tried to do it using the same XML code that customizes the ribbon but it doesn't work

Part and Inventory Search

Back
Top