[AccessD] Access 2K subforms bound to SQL Server.

jwcolby jwcolby at colbyconsulting.com
Fri Jan 20 11:48:07 CST 2012


My client is moving to SQL Server at my persistent prodding.  They have outgrown Access database 
containers, we have had to split their original single Access BE many times and now have about 6 
different BEs with as much as 800 megs of data in some of them (after compact / repair).  "Another 
user has locked this record" kinds of issues.  All that stuff.

So we are slooooowly moving the database to SQL Server.

The problem is that they remain firmly mired in Access 2000.  Yep.  Sigh.

The biggest issue with Access 2K from the perspective of SQL Server is that forms cannot be bound to 
recordsets and still be editable.

So I am searching for a way to emulate what has always mostly worked, yet at least maintain the 
current speed (not great) or speed things up.

I have been using SQl Server with Office 2003 for a long time and it works very well but I don't 
have that here.  I am considering trying to use Access 2007 runtime, which I am using in other 
places and seems to work quite well.  The biggest problem with doing that for this client is simply 
that the application is *very* complex and I program "to the metal".  When something doesn't work in 
runtime, it is extremely difficult to troubleshoot.

So I am looking for thoughts on my predicament, and how you may have handled a similar situation.

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it



More information about the AccessD mailing list