Messages

1

General Software Discussion / Re: Customize Snap DB?

« on: July 13, 2012, 12:15 PM »

Thanks, I will take a closer look at Datacrow. My hope was originally of finding a modern version of old PC-File which was just complex enough to do most things. Upon more thinking another option is to go with one Word doc per part number, and all the PN docs in one folder.

2

General Software Discussion / Re: Customize Snap DB?

« on: July 13, 2012, 07:34 AM »

Yes, I saw your reply  to my original post:



1) I've tested it with around 80,000 records but, as the number of records grows, it's slower to load the file.  The largest database that I, personally, use it with has a few thousand records.
***** I will probably use it for less than 10,000 records, so this is good.
2/3) Sure, a single user could store the files on a network share (I do that with mine).  That said, I wouldn't recommend using it simultaneously in a shared environment as Snap DB is not multi-user aware whatsoever
***** We use Excel right now (setup as one tab per part number, which is really not working, as we add a lot of new part numbers), which does lock  the file so a second user gets read only mode. But SnapDB is so much simpler and has better search and data entry I would like to use it if possible.

A quick check did not show any bad results from 2 users accessing at the same time. If they both were on the same record, the last one 2 save or change seems to be the one that had the data recorded his way. It is unlikely my users would be on the same record.

Any suspected problems I need to test for in using with multiple users on a network?
Any chance of using some simple form of file locking (of the database file on the server) which starts for the first user to open the file?

Thanks!

3

General Software Discussion / Customize Snap DB?

« on: July 12, 2012, 02:07 PM »

Is it possible to customize snap DB (hopefully here!) to the extent to removing or disabling  certain commands,(or at least add a yes/no confirmation)  such as:

DEL record
Convert Row data to header names
Find/replace

I think I need a little protection of existing data from some of the users.  An undo command would be nice too.
Thanks!

4

General Software Discussion / Snap DB shared on a network?

« on: July 12, 2012, 10:55 AM »

I am thinking about using Snap Db for a serial/ part number database.  It will be used intermittently by 4 users, from a shared folder on a SBS 2008 server.
Questions:
1) Is there a limit of how many records can be stored?
2) Does it get along with being shared on a network? Any issues to look out for?
3) Will it work as multi-user (simultaneous) or only be one user at a time?
Any help or comments are appreciated!