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,
Microsoft Access

Avatar of undefined
Last Comment
Nikolay DMITRIEV

8/22/2022 - Mon
SOLUTION
OllarConsulting

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Nikolay DMITRIEV

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
OllarConsulting

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Nikolay DMITRIEV

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.
ASKER
Nikolay DMITRIEV

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,
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Nikolay DMITRIEV

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,