Hi,
I have a question concerning the RMS database. I would like to know if it is feasable to modify the RMS database from an interface in VB. Such modification would be adding/deleting/modifying items. I think that the RMS database creates a .mde file witch is a protected database. I may be wrong on this one. Any input on that will be greatly appreciated.
Thanks
RMS uses SQL Server (it installs MSDE if you don't already have it).
You can create your own interfaces to the database, but you have to be really careful as almost all of the data validation and referential integrity in RMS is embedded in the application, not the database. This means that the database will allow you to insert or update data in a way that would make the RMS Application crash when it tried to use it...
I think RMS uses ADO/OLE DB for it's connections, but you can use any technique you like to create your connections, including ODBC or the newer SQL Server providers used in .Net framework...
Glenn Adams Tiber Creek C> Hi,
Thanks Glenn. What I have in mind is to create a data entry interface into the RMS database. I am thinking about another solution ... that would be to create another database and then import it into the RMS. Is there a way to import a table into an existing RMS database?
thanks
"Glenn Adams [MVP - Retail Mgmt]" wrote:
It's just a SQL Server database, so there are tons of options for importing. There are a couple of RMS specific import tools that have been mentioned to death here. There are also many many generic third party import tools that can be used with any SQL Server DB. Not sure why you would want to store to a separate database then import - it's actually harder that way...
Glenn Adams Tiber Creek C> Thanks Glenn. What I have in mind is to create a data entry interface into
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.