Recent content by gerrythefish

Ok - so how do I count connections on the server? If I look on the server at the activity monitor or run sp_who it looks like there is one connection/session per user plus one for each table/view/passthru query that user has opened. I tested this by creating a brand new empty desktop app...

Thanks - when I look on SQL monitor, each user has about 8 connections - should there be only 1 per user, or is this normal when a form/subform is open with multiple combo boxes. Often I link comboboxes to pass-thru queries.

Hi all, I need advice on the most efficient way to connect to SQL to reduce user wait times. I recently moved access 2013 backend to SQL Server 2012. We have about 150 users over the company WAN (typically 10 concurrent) and have some latency issues accross the network. The front end is on...

Dumb newbie mistake - cant use views as the source of the form. Gah! seems like this would make it so much easier. I have some complex queries in access that are really slow and completely bombed when I moved the backend to SQL. This is why I really want to use linked views as the source of a...

Yes, but, as I said, the record gets deleted just fine, I get the error if I try to requery the datasheet form with a me.requery in the on delete event. Here is what I have I have a parent table (Teams) shown on the main form Team_ID Team_Name The_Timestamp 1 Orange 2...

Hi all, What am I not understanding? Access 2013 with SQL backend. I have a subform datasheet. If I try to right click to delete a record I get an error that I cant delete because its based on a view that has 2 tables in it. So I tried to cancel the delete event, run a simple delete query on...

Thanks Markk but I'm looking for examples in Access.

Yes, I'm trying to learn how to use objects and classes in Access.

Anyone have a good reference for using objects and classes in Access. I have searched here many times. I get the basics of OOP, but any of the VB books I've found always disconnect the data, so you have to deal with managing updates by multiple users. I want to leverage access to manage the...

Please explain!

This is an excellent point and one that I need help on. I have about 10 main tables with related child tables for each. For the most part I display a long datasheet list of records for the parent table. When the user clicks a link on a record in the datasheet I open a record in a single main...

I created most of them in Access, with referential integrity, cascade updates and cascade deletes turned on except for a few exceptions. These were then added to SQL by SSMA (version 6) in the migration. We had lots of problems with data that no longer fit the rules in access (for example a...

Yup - this made me look closer at these. Some indexes and relationships were missing in access or didn't come over in the migration and some indexes were duplicated in SQL in the migration. So Im going back thru all the tables in SQL and reviewing those. As a separate issue - would you have...

Thanks for the response. I saw a little improvement with SQL Serer Native Client but still slow. I cant move to Citrix or any other solution. Zero budget (of course). I have Office 2013 and SQL 2012 to work with only.

Lots of great info from your blog - thank you. See below. I saw no noticeable improvement from these. Some improvement from using native sql server 11 connection - but still way too slow. From reading your blog, my forms have several bound comboboxes that are basically lookups. Im guessing...