Is this still active?

gisdude · February 3rd, 2013, 01:08 AM

Just checkin'.

gjgriffith · February 4th, 2013, 06:04 PM

I'm still monitoring...is there a specific question I can help with?

Thanks,

gisdude · March 2nd, 2013, 01:44 AM

Hey Geoffrey,
I'm creating a new DB using existing excel spreadsheets that are pretty long (records wise- some approaching 1,000 records).

The basic design is what I'm struggling with. Basically, I have a spreadsheet that have autocad files, revision dates, drawing number, notes, last user edit. Bear in mind, some of these excel files go back to 1997 and (possibly) haven't been opened since them. But, a lot of them are newer and are used quite frequently. There is also another spreadsheet that has the drawing number, person requesting changes to drawing, status.

What I'd like to do is use excel as a front end UI for the DB and have them press a button to update the DB when they've edited it.

This DB would be basically for me and another user (my backup) and possibly a handful of engineer types.

I'm basically looking for a template of some type for this unorthodox situation. I have a some ACCESS experience, mainly as a user, but I've also created some pretty simple (but useful) DB's. This size of this project is what is daunting.

Any help would be great.

gjgriffith · March 2nd, 2013, 02:23 AM

Hello gisdude,

Thanks for the message back here. Hmm, I'm not really sure what to say about this. I don't know of any Access template that would store the EXACT data that you are looking for, but I might suggest the following:

1. The Access "Assets" template (possibly). You would probably need to modify it to store the exact data fields you want, but it sounds like a good place to start.

2. Given what you've said here, it sounds a lot like a "SharePoint Document Library" to me. I'm not sure if you have usage of a SharePoint server, but there are lot of options available out there and the "Document Library" might really be the thing you want to use here. But you would probably need to modify that "Document Library" from the base template (slightly) as well.

Anyway, I hope this all makes sense and at least puts you on the right track! Also, I should say that this forum is really about the Wrox "Access 2010 24-Hour Trainer" book and related questions, and really isn't monitored by a lot of people (as you can see by the number of posts, or lack there of). You might have better luck asking questions like this in main Access thread at: http://p2p.wrox.com/access-18/. Otherwise, if you have specific questions, need consulting or custom development work, please feel free to contact me via my website below, we offer low-cost services!

Regards,

gisdude · March 2nd, 2013, 04:46 PM

Where is it?

I appreciate the reply. I'll do a little more homework on my end, sharepoint may be an option, but not sure. I think I can tweak the "ASSETS" template to what I need, but my confidence level...

gjgriffith · March 3rd, 2013, 07:47 AM

Hello gisdude,

Thanks again for the follow up message. GREAT - that sounds good, I'm sure you'll be able to get the Assets template to do what you need it too. Also, the "Thanks" link can be found all the way on the bottom right of any post box that isn't a post you wrote. I hope that makes sense and if there is anything else I can do to help, please just let me know!

Thanks again,