Constant backing up data to archives while dealing with RowSource for next empty. Help! :)

[Orestees]

I've searched everywhere but wasn't able to find anything that directly applied to what I'm needing to do.

The scenario - 10 Users all with identical userform workbooks for data entry. Each entry is marked with a unique identifier and saved into their own workbook. This data will also need to be entered into 2 Master files (one for archiving and the other for pulling data back into the form for editing). These Masters will be in different folders but I can try and figure this part out. When the information is added from their sheets to the Master files, the masters will (eventually) need the data to be entered in the first empty row. For the sake of ease, the titles of the Masters will be Master(Active) in file folders in the c-drive titled folder1 and Master(Archive) also in c-drive titled folder2.

If I've left any loose ends in my explanation, please let me know. I'm really desperate to finish this massive project up and this forum has provided me with 80%-90% of what's been accomplished.

I've attached a very basic form below. Thanks in advance for any help!

Save2Master (Build1).xlsm

[Orestees]

If anyone thinks I'm going about this in the worng way, I'm open to suggestions. At this point, I'm at a stand still so any assistance would be GREATLY appreciated.

If kissing up a little helps, you all rock!

[Orestees]

Friday bump

[Orestees]

New week bump.

[Orestees]

Little help please

[Orestees]

Anyone have any input at all? I'f I'm doing something wrong, please let me know. (echo)

(crickets)

[event21]

Hi -

Use access or mysql database as your backend to store the data.


Regards,
event

[Orestees]

That would be awesome but the company I work for only has Excel.

[LeapingLizard]

Back up your information daily as I do. Copy only the necessary information or the file will get to large. If you don't care how many bytes it takes up in your memory just copy all the data to a storage location.

LeapingLizard

[Orestees]

It won't be my information though. There will be 10 individual users and 3 admins. There's a huge neccesity for redundancy as well. The biggest issue is that this data HAS to be backed up after every single new/edited entry. Also, since this is a corporate environment, they will not allow connecting to external storage. Everthing will be housed on our servers.

I'm pretty limited in all of this but the solution decided on by a committe was to have everything meet the specifications from the first post and the limitations in this post. I'm sorry if this is frustrating, I'm frustrated too but I'm so glad that you guys have shown an interest in helping me. I feel like my hands are tied as to what the users want and the company will allow.

Thanks again for any help you all can offer. If anyone knows about any resources I could read up on, that would also be helpful.

Thanks,

[event21]

Hi -

You can store MySQL locally on your server and connect your excel file, so once data has been inserted into the excel file, insert it in the database as well then you have the back up.

Or better just use the MySQL database as back end and excel as your 10 users data entry.

Regards,
event

[Orestees]

The company won't allow downloading of outside software. I could ask for it but it would be tied up in red tape for months. The users are needing this solution as soon as possible. Also, I have no knowledge of MySQL other than what I just looked up in Wikipedia.

Is there no viable way to do this kind of redundant backing up with just Excel VBA programming and a server? Sorry for all the dead ends by the way, especially my lack of knowledge. Up until 3 months ago, I didn't even have programming knowledge at all. Really trying to learn fast though and I do appreciate these ideas. If this all works out well, I have a feeling they'll begin to let me do what I need to if we apply it to a larger group of users.

[Orestees]

Any other thoughts within these limitations?

[event21]

Hi -

Sorry I could not help, but I am watching this thread to see if somebody have a solutions for the below requirement using just excel without any database.

It won't be my information though. There will be 10 individual users and 3 admins. There's a huge neccesity for redundancy as well. The biggest issue is that this data HAS to be backed up after every single new/edited entry.

Regards,
event

[Orestees]

You and I both Event. Hopefully someone with the solution is watching as well.