Just some advice would be ok

[smeeks]

I am the only programmer at my company and need some advice from someone who also knows VB.NET. We have an Access Database and our user base is growing.....people are use to opening the "table" and editing, filtering, sorting using this method. I would like to "duplicate" this same functionality. Am I "reaching" trying to use a datagrid and duplicate the same functionality that Excel or Access has (search, hide columns, freeze columns, filter, etc.). I am trying to keep this "same look and feel" because I have a "crowd" that doesn't like change. They have used this access database for about 4 years now and I want to migrate it to SQL Server so I can have a better handle on security. Also the Access database is used by 30+ people at once....which is not a good thing for Access. Any suggestions would be great.

Thanks.

 

[chrissie1]

30+ people is not a real problem for access, depends on the concurrent users and the way your app is written. But I would look for another grid then the datagrid if you want it to look like access or excell. Something like Componentone's flexgrid is a lot better and is free with the vb.net resourcekit.

The only thing access has against it is the user interface, it's annoyingly slow.

So the switch all depends on what you are willing to do. And in any case it will be a lot of work.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[rhnewfie]

Do your users need the ability so persist any data changes that they make?

I recall looking into the ComponentOne flexgrid at one time and thought that it was pretty powerfull