Search results

I have a backup procedure that is giving me a "Permission Denied" on my own profile. Can anyone spot an error in my code?Public Function BackupFE() On Error GoTo BackupFE_Err Dim SourceFile As String, DestinationFile As String Dim aFSO As Variant Dim Path As String, Name As String...

A sincere and heartfelt thank you to Uncle Gizmo and vbaInet! I really value the time you take to answer my often lame questions. It is part of my learning process and I shouldn't get so defensive when someone points out my errors. I didn't mean to be critical of you, I was just embarrassed. :o...

Thanks, I guess. I mean, I do really appreciate your taking the time to answer my post, but I feel you have prejudged my design without knowing the whole story. What I have is a very small personal database having a total of 88 records, eventually topping out at less than 150. It could have...

IHi, I have a very simple single-table database with 23 fields. Some of the records have only two or three fields populated. I would like to be able to print a summary of only the populated fields in each record. It would Ideally look something like: Record 1 Name Field 1 Title: Field 1...

Ahh! Sweet success! I abandoned the FE I was experimenting with and started from a clean copy of the DB I am developing. I copied the code from the abandoned copy and changed the approach for making the form read-only as I indicated in my last post and it worked perfectly. I did have to replace...

Hi gemma-the-husky, Thanks for responding. I'm pretty sure the syntax for Tdf.Connect = ";DATABASE=" & NewPathname & ";Password=" & "password" is correct. The reasons I believe this are: A) When I plug in the right password I get no errors and stepping through the code it moves through the...

Hi, I have done some research and found another way to re-link my table. It deletes the existing table and creates the new linked table just fine. It prompts for a password, which is okay with me. But, I have three problems listed in order of importance.: 1) When I open the local database, I...

I figured out that I can open a form in read-only mode, which suffices to met my needs. Thanks for all the help!

Thanks! That cleared up the error and the code ran, but the tables were not linked to the new BE. So, I went back to my example and realized I had somehow deleted the "Tdf.RefreshLink" line. I replaced the line but now I get an "Invalid password" error on that line. None of the other properties...

Hi gemma-the husky, Okay, I admit it. I don't have the foggiest notion how to use the code you gave me. I'm a novice and what I tried to use is probably not in any way correct. I used: Dbs.TableDefs."tblMain".connect ;database=NewPathName ;password="My Password" Dbs is my CurrentDB and...

Hi, I'm trying to change the table links to a password protected BE DB. I found an example online, which I adapted to my needs. When I set it up to fail to find the normal BE it seems to work as intended until it gets to the line "Tdf.RefreshLink". Then it crashes with a 3031 "Not a valid...

Hi, Please pardon that last question. It's been a long time since I used a for loop.:o

Hi, I'm trying to addapt the following code from http://www.access-programmers.co.uk/forums/showthread.php?t=167786 for my application, but I don't see where "Tdf" gets defined. Can you help me out?Private Sub Relink_Click() Dim Dbs As Database Dim Tdf As TableDef Dim Tdfs As TableDefs Dim...

Hi, I think I've thought of a different approach to my problem. Please take a look at my idea's main steps and tell me if you see any problems or have any suggestions. 1) Check to see if the main BE exists 2) If not change the table (there is only one) link source to the local copy of the BE 3)...

Hi, Thanks for answering! I have explained in more detail in a seperate message, but there is a local copy for other users and a "file server" copy, which at the moment resides on my machine. I don't want changes made to the local copies since they will be lost anyway. It is not "real-world" but...

Hi, I have searched and have not been able to find anything on creating a read-only copy of a back end DB with VBA. I am creating backups of my back end file and would like to create a local read-only copy to use in the event that the regular back end is not available. If anyone has any insight...

It would be very unusual for us to both have it open at the same time. :D

Thank you for bearing with me through this, I really appreciate it. Yes, I did take note and have changed the code. It now includes the date, hour and minute in the name and I am keeping a complete history of them. I'm not terribly concerned if I rewrite a backup that is less than a minute old...

I finally figured out what I did wrong! Sorry to lead you on a wild goose chase, it was a couple of amateur mistakes that aren't worth explaining. Thanks for your patience. :o

I'm trying to backup the BE. I thought I needed the OpenProtectedDB to do it. I'm the one who's lost! If I skip that and just go back to the code for backing up my BE, the code is: Public Function BackupDB() On Error GoTo BackupDB_Err Dim sourceFile As String, destinationFile As String...