Search results for query: *

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

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

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

Thanks John!

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

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

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

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.

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

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

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

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?

Hi, I just tried that. Still cancels the 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...

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.

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?

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

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

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

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