We have a billing database of roughly 3800 members which we use for a registration at an annual meeting. I've run a query from our main db with MS Access and have all the data in a table with an Access database.

I created a data access page, but for the life of me can't figure out these two items.

* How do I make a search function where a user can enter a lastname (field in db) and it grab all matches with the criteria?

* How do I make it where other users can access this with the data access page. The pc's are part of a domain environment, but no domain controllers or other servers will be at the meeting. This db will reside on a pc that will be networked with 3 others that need access to the db.

I'm not real familiar with MS Access, more PHP/Mysql.

Any help will be greatly appreciated.

It's been a long time since I used MS Access - there are some wizards to make things happen...

But it would be much much easier to export the db (in csv) and then import to mysql - write a simple php script and you are done!

Thanks for the reply.

Very true, but Access would allow for a fast update. We are needing to enter a number to show each is registered. I would have to update each individual record via php/mysql right? I suppose an Ajax script would work, but that's a little more complex than I care to get into.

I'd also have to install PHP/mysql on a pc which isn't bad, but more time.

We're also needing to print labels from this file, which Access makes it easy to do.

I'd rather do it in php/mysql, but seems Access would be the simplest as far as updating, etc.