khyber
07-31-2005, 09:41 AM
I designed and implemented a database that contains nineteen tables ? most of the fields are text fields with 255 character limits. This is an index to a repository for documents stored online.
Now I must add more tables to access more documents. The second index is different from the first. It contains the master documents that govern the documents in the first index. It will contain a lot of text fields with the same character limit ? 255. Because of the size I created a second database for this new index.
The Access front end to the first repository index contains links to the data tables. I must do this with the second repository index. Will this create a problem ? a front end linking to data tables in two different databases? The tables used for option lists and tables used for reports (results of make-table queries and keyword searches) are all local ? in the front end. The input forms write to either one or another index. Never does an input form write to both indices. Should the need arise - to write to both from one input form - will this be possible?
I will be designing reports on the contents of both indices. I have already created queries to check out the links and they are working fine.
If anybody has advice or can point me to knowledge based articles on this problem I sure would appreciate it.
TNX
Now I must add more tables to access more documents. The second index is different from the first. It contains the master documents that govern the documents in the first index. It will contain a lot of text fields with the same character limit ? 255. Because of the size I created a second database for this new index.
The Access front end to the first repository index contains links to the data tables. I must do this with the second repository index. Will this create a problem ? a front end linking to data tables in two different databases? The tables used for option lists and tables used for reports (results of make-table queries and keyword searches) are all local ? in the front end. The input forms write to either one or another index. Never does an input form write to both indices. Should the need arise - to write to both from one input form - will this be possible?
I will be designing reports on the contents of both indices. I have already created queries to check out the links and they are working fine.
If anybody has advice or can point me to knowledge based articles on this problem I sure would appreciate it.
TNX