Search results

Found a solution http://www.utteraccess.com/forums/showflat.php?Cat=&Board=8&Number=673571&Forum=,All_Forums,&Words=linked%20tabledef&Searchpage=1&Limit=25&Main=672930&Search=true&where=bodysub&Name=40232&daterange=1&newerval=6&newertype=m&olderval=&oldertype=#Post673571&bodyprev=

Thanks for your reply. The ACCESS app (which is front-end) will be distributed to tens of computers. From that reason it will be easier to use one user name and password for all the front-end ACCESS app, then to insert all the computers' network-names into the SQL SERVER (so it'll work on...

Hi. I recently created SQL SERVER backend for my MS ACCESS app. (I upsized ONLY the tables, so the ACCESS app contains linked tables). The SQL SERVER resides on a different machine than the MS ACCESS app. Every time that I run the ACCESS app, it fails to connect to the SQL SERVER ("Login...

Thanks a lot for the advices. You helped me with a very valuable info. I will upsize only the tables. Performance issue can be addressed later through optimisation , with the process you suggested. :)

The performance issue is only part of the problem. The more significant part of the problem is number of concurrent users. It supposed to support 20-25 concurrent users!!! [currently after 10 concurrent users (r/w) the system dies (it hangs , or closes unexpectedly).] Your solution doesn't...

Thanks for your quick reply Pat. In the application, filtering is done on the queries, not on the forms, and the performance is poor. I think that Hybrid solution might be good: I mean: 1. Upsizing all the tables. 2. Create linked tables in ACCESS 3. Create Stored Procs only for the queries...

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...

Hi. Thanks a lot for your help. In my ACCESS app, I'm detecting at run-time the user's screen resolution. If it's lower than 1024*768 I'm modifying it to 1024*768 and then I maximize the ACCESS window (NOT the forms). My problem: After changing the resolution, maximizing the window will...

Hi. Your help is highly appreciated. I recieved an aready made ACCESS 2003 application that I need to distribute (build installer). 1. This app uses ActiveX controls. Is there a way to get a list of all the ActiveX controls that the app uses? 2. How can I install ActiveX components to the...