View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000817 | MMW v4 | DB/FileMonitor | public | 2003-10-28 17:50 | 2007-09-11 17:05 |
| Reporter | rusty | Assigned To | |||
| Priority | low | Severity | feature | Reproducibility | always |
| Status | new | Resolution | open | ||
| Summary | 0000817: Add official support for shared db | ||||
| Description | Currently, shared dbs are not officially supported, primarily (I think) because we're not certain that the Access db will behave properly in such an environment. From what I've read, it is possible to design an Access-based application to support multi (<5) user environments, provided certain rules are adhered to. I would like to be able to officially support this functionality, but that would require confirmation that we adhere to these guidelines. Note: I've found some info about this at: http://www.embassysoftware.net/dbovervw.htm http://dotnetadvisor.net/doc/13043 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrmultiuserdatabasesolutionarchitectures.asp http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q110/7/32.asp&NoWebContent=1 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | |||||
|
|
Note: prerequisite to this is resolution of 0000807 |
|
|
Note: it seems as if there may be a bug with using a shared DB and trying to update it. See: http://www.songs-db.com/forum/viewtopic.php?t=652 |
|
|
Sharing DB is generally working, there is a couple of minor issues that aren't easy to solve related to updating data shown on one computer that were updated by another computer (e.g. new media added to DB). However, I would rather defer solving such things until we add support for other DB engines (e.g. MS-SQL Server), which would probably be a feature of an "Expert" version of MM (useful for companies). |
