May I ask how this problem is finally solved.
View Complete Post
I have an Access2000 ADP that I want to run under Access2007.ÃÂ The problem I have is that some forms take up to 45 seconds to open in Access2007!ÃÂ These are not complicated forms--just simple navigable reference forms like setting up transaction types etc.ÃÂ that are based on basic select statements like:
SELECT * FROM ArReceivableType
Where ArReceivableType is a reference table (less than 10 columns, all int or nvarchar(100) max) containing about 15 or 20 rows.ÃÂ They open instantly in Access2000.
I put a trace on to see what is happening on the SQL Server, and I noticed heaps of nastyÃÂ code like this that generates tens of thousands of reads:
select object_name(sotblfk.id), user_name(sotblfk.uid), object_name(sotblrk.id), user_name(sotblrk.uid) from sysreferences srfk, sysobjects sofk, sysobjects sotblfk, sysobjects sotblrk where srfk.constid = sofk.id and srfk.fkeyid = sotblfk.id and srfk.rkeyid = sotblrk.id and user_name(sofk.uid) = N'dbo' and object_name(sofk.id) = N'FK_FaAssetTransactionWork_ArReceivableType_ArReceivableTypeId'
It looks like Access2007 is reading all of the constraints for the underlying table, including all foreign keys.ÃÂ My SQL database contains 1400+ tables all with properly constructed foreign keys and other constraints.
Any suggestion on how to NOT have Access2007 do this?ÃÂ Right now, Access2000 works gr
Is there a program that I can download that aids in converting an access (accdb) file to sql express 2008 R2?
I have a bunch of databases running on a SQL server 2008 instance. They're all set to the default Latin collation, and the server is set to UK English locale.
I have an access database using linked tables to the SQL server. The lcal PC is Windows 7 and also set to English UK locale.
However, the date fields in the SQL server tables are interpreted by Access as "text" type, not date. When I type a date into them in standard UK english format - dd-mm-yyyy, access accepts them but the SQL server rejects them because for some reason
it is wanting to store the data in the format yyyy-dd-mm.
I realise I'm no expert, this is probably something really simple and I'm probably being stupid, but can anyone shed any light on WTF i going on here and why, and how I fix it. I realise I could code in access forms something to force the date into
yyyy-dd-mm format and re-interpret it to English when I want to display it, but that's clunky and horrible.
Any ideas gratefully received. Thanks.
i wana know how can i export data from a table to access through a sql job
i am using sql server 2008 and office 2007
I am trying to open a List with the Actions / Link with Access functionality. Every time I try, it simply opens up the MS Access interface as though I had gone through the Start button and selected MS Access. However, it shows the name of the
database, in the right side panel, that was in the "Open with Microsoft Access" dialog box that opens after you select Link with Access. If you click on the database name, I get an error box saying that the database doesn't exist.
The caveat here is that it used to work. I have a database that I have been using to run reports and custom queries on a List. Now, if I click on the Linked Table, I get the error message "You do not have the necessary permissions to use
the '[object]' object. Have your sys admin or the person who created the object establish teh appropriate permissions for you."
I am the one who created the list and I have admin rights to this area of Sharepoint.
I have also tried to perform the same tasks to another Sharepoint site where I have full Admin rights over the entire site. Same problem.
The version of Sharepoint is 22.214.171.12439.
I also have MS Office 2003, Project and Visio, installed on my PC.
Any ideas or thoughts on what the problem may be? Our Sharepoint techs and our
I have what I thought was a simple task. Create an OLEDB connection to an Access2007 MDB data file within SQL Server 2008 R2. Here's my environment:
My first attempt was within SQL Server's Management Studio by navigating to Server Objects - Linked Servers and right-click selecting New Linked Server...
First indication of some trouble began when I didn't see an ODBC Provider for my Access database. After trying a few options, I turned to Google expecting a quick resolution. Here is the beginning of 5 days of going round in circles!!!
Eventually I found some links that led me to potential solutions:
When I click on a pdf document uploaded in a document library it comes up with a blank page.
I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.
I tried other browsers too, it's the same issue.
I am able to open all other pdf files local to my machine fine.
I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.
I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could
find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.
I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application
however when i do click the new report builder report it kicks me over to
http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.
Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.
all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu
I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:
Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?
I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.
But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.
I repaired .NET Framework 3.5sp1 installed
1. I tried again, in C Prompt: Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini" it says initiation file cannot be found
2 i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"
it says reloaded from the system restored
i am still getting the same error.
When i manually go to my C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..
I dont know what is happening i am trying it from 2 days and still no solution.
any ideas would be real great help for me.
My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.
.Net Framework 3.5 sp1
and WSP builder the one from Codeplex for 64 bit machines
When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.
I am using IE7 and the path of the folder does not contains more than 100 characters.
Also it opening on few on the machines which has IE7.