To Upsize Or Not To Upsize, That Is The Question
Apr 13, 2005
I have a dilema, my db is hosted on our shared drive, and with +-15 users at any given time there shouldn't be a problem. However, quite often the users get the message that they cant log on because the file is already in use. This will pose a bigger problem very soon, because there will be about 100 users total at any given time. My question is this; should I upsize or not? I haven't found much written on the subject, so I don't know if that would solve my problem or not. If it is a good idea, can someone tell me if it's possible with a split db? And since I'm new to this portion of Access, can anyone tell me what I should be aware of (unforseen brick walls). Any help would be greatly appreciated.
Thanks,
Scott
View Replies
Jul 5, 2005
Hi.
Your help is very appreciated.
I want to upsize large MS ACCESS(2002) app to MS SQL SERVER 2000.
[ By "large", I mean 250 queries, 78 tables, 110 forms].
The app will be used by 25 concurrent users.(therefore the need to upsize).
I have time constraints of 2 weeks to deliver.
My questions:
1. In order to finish it asap, upsizing ONLY the tables - might be a good solution. However, will it work with a workload of 25 concurrent users?(read/write).
2. If upsizing all the tables, would it be possible to upsize SOME of the queries and leave the rest untouched?
If yes, what is the process to do it?
That will save me lots of QA time (there are 250 queries).
Mind you it's not simple, since the forms need to reference Stored Procs as well as ACCESS' SQL queries.
3. In the upsizing documentation, it says that there might be situation that the query will be upsized , no errors will appear in the log BUT it won't work anymore :mad: .
Do you have any methodology for QA the upszied queries in order to ensure the system's robustness?
Thanks a lot
Roy
View 6 Replies
View Related
May 2, 2006
Hi
I am looking to upsize a Access BE database to SQL Server. The FE database will still be MS Access. I would like to keep the FE as it is and use an ODBC connection to the SQL BE database. My problem today is that I need better performance since we are using the database over a WLAN connection. As I understand it, Access sends the entire dataset/table across the connection whilst SQL Server only returns the requested data.
Is there anyone familiar with SQL Server that can guide me in the right direction here. Any insights are most welcome and appreciated.
TWe aare using computers with WinXP, server running Windows 2003 Server
hanks in advance
View 1 Replies
View Related
Dec 27, 2006
Hi All,
I just "upsized" an mdb front and back end SQL Server Express using the upsize wizard.
I have a sub-form with a list box that does not seem to work. Here is the recordsource:
SELECT tblProjectSegment.strSourceCodeID, tblProjectSegment.strEventCodeID, tblProjectSegment.lngProjectCodeID, tblProjectSegment.SourceCodeLink, tblProjectSegment.strStatusID FROM tblProjectSegment WHERE (((tblProjectSegment.lngProjectCodeID)=[Forms]![frm_ProjectData]![frmSourceCodeInfo].[Form]![lngProjectCodeID]) AND (Not (tblProjectSegment.strStatusID)="utad")) ORDER BY tblProjectSegment.strSourceCodeID;
Any help?
TIA
View 3 Replies
View Related
