Save changes to reports/forms with other users in DB?

[Melagan]

Greetings,

I recently migrated a shared database from Access 97 to Access 2000. In Access 97, I was able to edit and save changes to forms and reports even while users were logged into the database, but Access 2000 (or Access 2003 having the Access 2000 formatted DB open) will not allow me to do so; I aparantly have to have exclusive rights to the database. What gives? I can't delete a control off of a form that nobody even has open at the time; or create and save a brand new form/report? If Access 97 allowed this flexibility, why wouldn't Access 2000, 2002, or 2003?

Thank you in advance,



~Melagan
______
"It's never too late to become what you might have been.

 

[dhookom]

More recent versions of Access support proper application development. You should split your applications into a front-end MDB with forms, queries, reports, code,... and a back-end MDB with only the tables.

You develop and work on an off-line copy of the front-end. When you are ready to move the new front-end into production, you attach it to the production back-end and make it available to your users.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Melagan]

I understand - I've researched this idea quite a bit and will look into implementing it. Thank you for the heads up!


~Melagan
______
"It's never too late to become what you might have been.