By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

access database for storing word documents,presentations, excel sheets an any text fi

P: 1
Hi

I need to set up a database that can store any text files,word documents, presentations,excel sheets etc with a sophisticated interface on the front end to enter and data retrieval..should ve certain level of security.
Jul 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: 16
Hi back at you.

I strongly recommend against what you are proposing. Access is not the tool for this.

At the very least just use Access as an interface storing file paths with the actual files saved on a proper file system. Locking the documents inside Access prevents them being indexed and makes for a massive access database, which when it corrupts will lose all your files.

There are plenty of open source document management systems out there that you would be better off investigating than going down this path that have built in security, indexing options, metadata management and conform to document storage standards making them more portable and scalable.

Cheers
Jul 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.