September 4, 2007 at 11:22 am
Does anyone have any bug reports or white papers of known issues in using Access as a front end to SQL 2005 DB's?
Many thanks in advance!
September 4, 2007 at 1:57 pm
In true consultant form - I'll answer a question with several questions:
if using an MDB - this is a good place to start reading http://msdn2.microsoft.com/en-us/library/bb208890.aspx. The linked document keep going into the various differences between Access and "native" SQL.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
September 5, 2007 at 1:07 am
Have a look at http://msdn2.microsoft.com/en-us/library/bb188204.aspx
September 5, 2007 at 7:28 am
Thank you both, and my apologies for the vaguely stated OP.
We use Access as the front end currently to our product's DBMS files (which right now are either Oracle or Sybase, and most always we end up converting the Oracle DB to Sybase before we start editing it).
We are now preparing to go fully SQL Server 2005 as the sole DBMS for our product, and I was wanting to see if there were going to be any known issues in working with it as a front end (Semiphoric locking, locking of the DB file to where you cannot view an edit the moment you change something, etc...).
I appreciate the links, and will start there.
September 6, 2007 at 9:10 am
I have been working with Microsoft Access (1.0) with SQL Server as a back-end for quite some time.
I have encountered multiple problems with Microsoft Access 2000 and SQL Server 2005. The major problems I've had is with Data (html) Pages using SQL parameterized stored procedures. I also understand that the designers use different base code for Access and SQL Server. I have had so many problems with Access Data Pages (ADP) not working correctly, that I will have to scale-up to Microsoft Access 2007, something I was trying to avoid.
September 6, 2007 at 7:26 pm
Thank you for sharing your insights. Did you have similar problems with Access 2003?
BTW - I hear that the Office 2007 applications nearly all save natively as an XML file now - is that true? Like *.XLSX and *.DOCX and *.MDBX???
September 8, 2007 at 10:16 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply