Access XP

[Unlimitedesigns]

What i would like to do is pull data from a live system SQL and store the info in a Access
database which can be minipulated but not changed using excel. then Access to be updated either daily or weekly but not to lose what is already in there ?

thank you for your time and help - cheers

Jason

Cross-post link: http://www.mrexcel.com/forum/showthread.php?t=563892

 

[xenou]

It seems to me that yes, what you are asking for is possible and there are in fact a few options available to you for interfacing Access and a larger database. But I doubt anyone can actually build such a database for you without a bit more specific information (even then, it may be something you would want to hire a consultant for rather than trying to piece it together from forum posts - it sounds like you need a lot done here, not just some tips).