Question Spltting vs running a single entity off a server

[RexesOperator]

I have reached the point in the database development where it will be loaded onto a server.

What are the advantages/disadvantages of splitting the db to be/fe vs leaving it intact on the server?

The db is to used load five excel spreadsheets. Otherwise all activity (reports, forms etc) is confined to db itself. At most there will be four or five users. There are currently about 2500 "sites" (the last link in the relationship design: Company->Contact->Transactions->Sites). This will grow to about 4000 in the next few months (I will be adding some historical information). It is anticipated to grow at an average of 1000 transactions per year.

I will not be maintaining it.

 

[boblarson]

The big one is

How many times do you want to lose it due to corruption? A non-split database running over a network is very, very much more likely to suffer corruption.

See here for more about splitting:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Banana]

Frankly, in multi-user setting, there's just no choice. It has to be split.

The only valid reason for having a unsplit database is if it's a single user application. You've obviously already past that point.

 

[RexesOperator]

Thanks Bob - points to ponder over the holidays.

One question I have - I seem to recall reading in the forum that a split database can't be compacted and repaired. Is that true? If it is how do you get around it?

I hope you have a good Christmas and didn't get too much of that nasty weather over Oregon this week.

 

[boblarson]

Thanks Bob - points to ponder over the holidays.

One question I have - I seem to recall reading in the forum that a split database can't be compacted and repaired. Is that true? If it is how do you get around it?

Check this out and see if it helps:
http://www.rogersaccesslibrary.com/...?TID=378&SID=16b3ece699587zbba12c852z768ec5fd

I hope you have a good Christmas and didn't get too much of that nasty weather over Oregon this week.

We're snowed in at the moment. We can't get out of our driveway or onto our street because we have too much snow. The main streets are not too bad at the moment but we can't even get out to them. So, we're here until it melts a bit. Fortunately we have enough supplies to make it through (although hopefully the electricity won't go off again like it did for 4 hours last night).

 

[RexesOperator]

Thanks for that link. I am also importing your update routines (with appropriate recognition).

We're snowed in at the moment. We can't get out of our driveway or onto our street because we have too much snow. The main streets are not too bad at the moment but we can't even get out to them. So, we're here until it melts a bit. Fortunately we have enough supplies to make it through (although hopefully the electricity won't go off again like it did for 4 hours last night).

Fingers crossed the power stays on. Have a merry Christmas anyway.

Remember the old Dodgems/Bumper cars from fair grounds? You might appreciate this video from Portland :http://www.youtube.com/watch?v=CySmFGxU6Bk