I just figured out a way to more easily manage my database items...
You can use a linked table in MS access to connect to the SQL server and. Then the table can be edited in a spreadsheet-like view.
Generally, you create a new blank database in Access. Then click on Tables. Right click and create a new linked table. Go through the motions to select your SQL database server and select the dbo.Item table.
For more detailed information, search google or go to:
I did made connection with MS Access but had an error when I try to access or change same record twice. I'm getting error: "The data has been changed. another user edited this record and saved the changes before you attempted to save your changes. re-edit the record."
then this record shows up as "#Deleted"
Be very careful editing the Item table in this way, you have to bear in mind it has relationships and keys - that although not defined in the database, are necessary for the correct operation of RMS. You should also ensure you are the only person connected to the database if editing in this fashion.
Regards, Richard
What software do you suggest to directly edit database? is MS SQL Enterprise Manager good enough?
I don't really recomend doing direct table edits in any tool - you will always have to possibility of the concurrency issues you saw in Access, and the record locking issues that you probably didn't notice (while you are editing a row, POS probably can't find it to add it to a transaction...
If you are going to just open a table and edit, you should: Always take a backup before you start Make sure no one else is using the system while you have tables open
Access and other tools are fine for running select queries or building reports, but you need to be extremely careful if you are going to do any sort of updating...
Jason and all,
Do a backup and be VERY, VERY careful doing this.
You are no longer using the validation rules that are built-in to RMS. Change the wrong thing and you will never figure out why something screwy has happened!!
You've be _warned_!!
Walter,
You do not want to edit the database directly without RMS validations.
If you want to see some in an spreadsheet format, create a report that allows a drilldown into the record and then change the record within RMS.
Backup? What's that?
Just joking... Of course... That goes without being said in my book...
I typically do this kind of work AFTER HOURS, AFTER BACKING UP.
If you are careful, there is nothing wrong with accessing the database using this method. The key is to close and reopen the table frequently to be able to change the database items twice...
I'd love to see someone develop third party apps using Access with some safety built into it. The lack of an easy way to modify the item database and extremely poor import features is a huge downside to RMS.
I should have stayed with Quicksell, where you could go into Access and play all day without issue with the mdb file. I NEVER had a problem accessing tables this way.
I guess it's the price we pay for progress... I probably shouldn't be expecting "open source" anything from Microsoft!!!
Jason
"Jeff" wrote:
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.