client/server solution? 1

[mmaz]

Hello,

My company is using an Access db to manage a set of data. Up until now, only one person was adding/editing records. But now, they want 2+ people to modify records. I'm not very familiar with Access, but is it possible to have only the tables on a server, and to have the forms on each user's pc?

Or what would be the best solution for something like this?

Any suggestions?

Thanks,

Marie

 

[mmaz]

Also, I should mention that this will only be a temporary solution, as we are moving the data to MySQL. So the easier this will be, the better.

Thanks!

 

[WildHare]

Actually, front end on User Machines and Back-End (Tables) on Server is recommended by those "in the know" (and you know who you are....

Just make sure that you have record-level locking on, and that any forms you use against the table have their "record locks" property set to "Edited Record".

Basically, you will be allowing "> 1 Person to Edit Data in the Table At The Same Time"

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm