Link to home
Create AccountLog in
Avatar of Nikolay DMITRIEV
Nikolay DMITRIEVFlag for Switzerland

asked on

upgrading access db

Good day,

This time I need strategic advise, because the things are coming to the critical point.
1. Background.
Access application designed since 2006 (MS Acc2003) for personal use to make the life easy.
2. Recent events.
Company did like the application a lot and asked to deploy it not for me only. I have split the database to FE and BE+.mdw with passwords and access rights.
Both FE and BE are deployed in the same directory on the server (there are no PCs, there are workstations=monitor+keybord). Means, all users are addressing to the same FE file.
3. After 8 month of multiuser operation ( 4 persons) database was quite reliable. Growing of the BE file about 12Mb per month. Now the complete database is BE=220MB(about 130 tables) + FE= 128Mb(more than hundred forms+ extra reports, qrys,macr etc.)
4. Now some more users want to join (theoretical maximum- 32 users);
5. The amount of changes I'm doing (new tasks/tables forms etc.)is decreasing compared to previous months, but the modification of the forms is constant.
6. Also there is an idea to give an acces to certain parts of the db for  some remote sites, which are not always online (means uploading or synchr or I dont know).
Considerations (I simply can not know this):
- Stability of the database in case of bigger number of the users;
- Maximum size of the BE declared as 2 GB , which is not an extraordinary figure; (there is a tendency to ask for big memo fields);
- Speed of the database in case of many users and bigger BE size. (some sql applications here are simply slow).
- From time to time, there are complaints that memo field text formatting options are poor;
- A lot of docs are linked to the db(OLE). Any trouble, will damage the links= tragedy;
Summary:
- I have a feeling that Access itself will soon become not enough;
- I am investing huge amount of time to this db (I'm not a professional programmer, I am  supervising engineer. Thats my job actually).
May be stop spending time with Access and start digging something else? Lifting something new from scratch will need time also.
If the decision will be taken, it will have to last years and years. Limitations with further development can hardly be accepted.
Any ideas which way to turn? Or maybe continue with Access? One time I can afford to loose data but only one time and we must be sure that the platform will not be changed in general in reasonable future.(better not to loose of course).

Best regards,
SOLUTION
Avatar of OllarConsulting
OllarConsulting

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Nikolay DMITRIEV

ASKER

First of all thanks. Actually, FE does not bother me a lot at this stage. I fact, my nice coloured forms is the last thing i want to touch. Others did like the db because of handy forms finetuned during years.
What about 30 users online?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks to all. Noted from my side and much appreciated. From above posts understood tw main things:
1. I should not start anything new from scratch (something like Oracle project l have no idea about yet).
2. Upsizing of be to Sql is inevitable.
Thanks to all. Noted from my side and much appreciated. From above posts understood tw main things:
1. I should not start anything new from scratch (something like Oracle project l have no idea about yet).
2. Upsizing of BE to Sql is inevitable. This is better because sounds more realistic (although i have never did it before either=exsiting study ahead).
Few more details:
Im not sure about remote desktop terms, but im loging in remotely via citrix when at home or travelling. Moreover, login  process both from home and from office is identical (for me it means we all are using a kind of remote desktop all the time no matter from where).
Also understand that support of off-line users is problem. To be clear enough we are speaking about the ships sailing at sea and periodicaly uploading some technical data (some of them have internet access, some not. Satcom mail only). Now above data is retyped manually for further analysis. 3rd party software is not a solution: we need at least dozen of specialized soft to cover complete task. Bulky, expensive and not offer what we need exactly.
Thats all what is nice to have from remote sites.

best regards,
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks. Noted. Clear in general but not in details. But more than enough to start digging. Main thing that l dont need to start anything from scratch.Hopefully, our admin will be able to explain all these Rdp details.
Import/export stuff(second part ofthe question) is more clear. We are using such approach with some sql applications (exchange with export/import batches).
Thanks again. Will mark multiple solution in few hours. (Writing on the go).

Best regards,