Kind of hard question I think?
I have for some time planed to get my databaseapp working but I need to add some features to it. I need to start it as a "Server" that ppl can connect to
and add, update, delete or search in the database from some kind of clientapp.
I use a standard Microsoft database made in access(*.mdb) and I have made all features execpt to search and "sever" abilities, these 2 I dont know how to do.
Please help me with this!
MvH Mattias Holmström(Sweden)
Re: Kind of hard question I think?
May be you have to trsnsorm your app in an ActiveX exe running as remote component. However, access will give you some maddtime trying to use locked tables...
Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
The Rater
Re: Kind of hard question I think?
You can connect to an mdb using ADO. So you can place your mdb somewhere on the network, and people can connect to it. It's like connecting to a file on your local disk, only over a network, and probably a bit slower.
There are alternatives, like SQL server, which is a *real* database server. But this should be used when the mdb is not capable of getting the wanted performance.
About the searching, that isn't to hard. There are several posibilities.
1) search on the recordset: use the available commands of the recordset object to search the data. Commands like Find, Filter, or any variants of that should be available depending on the data access provider you are using (ADO or DAO).
2) select the filtered data in a recordset. In stead of opening a table, and then searching the recordset, open the filtered data (like all names starting with the letter A and work with that. This is probably the faster one
Tom Cannaerts
[email protected]
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook