Recent content by PercyN

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.