Database splitter

[domino3]

I would like to know if it is possible to split an access 97 database into front and back end, as it is with access 2000.

Thank you.

 

[jrbarnett]

Yes it is.

John

 

[alvechurchdata]

The Database Splitter wizard is on the Tools menu under Add-Ins.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[domino3]

Thank you.

I'm wondering how stable a split database is? Currently I have 10 users on a sbs using access 97. They all need their own input forms, which all have various sub forms in them.

They keep getting messages to say that the forms they are using are being used already, and are locked, and all I can think of is that somehow the macros behind them are getting confused.

I don't know whether splitting the database so they each have their own frontend database would solve this, but I don't want to cause other problems in the process.

Any advice would be gratefully received.

Thanks.

 

[jrbarnett]

Very stable, just make sure that you have all the forms set to optimistic concurrency (no locks).

John

 

[domino3]

Would it be possible to have only the forms on the individual frontends, but have the queries, reports and tables on the backend? All I can find on the web is how to split it to have the tables on the backend and everything else on the front end.

 

[jrbarnett]

I'd not recommend that approach. Remember that the code is run from the context of the front end application, so if you were to put the reports, queries and tables into either the backend database or another one, you would need to modify your code to specify where to open the relevant object from.

Certainly I've never had need to put forms, reports, queries etc in the back end.

John