Showing posts with label project. Show all posts
Showing posts with label project. Show all posts

Thursday, March 22, 2012

Access and extended properties

Hello,
Can I read and write the extended properties with Access?


If it’s possible is better create a project (ADP) or a classic MDB?

When I try with this query in the query panel (in a MDB)

SELECT objtype, objname, name, value
FROM fn_listextendedproperty
(NULL, 'schema', 'Person', 'table', default, NULL, NULL)

I have this error message:

The size of a field is too long

If I try with an ADP, when I ask a new query in design view, I have a message for some roblems between the Access version (2003) and SQL Server version (2005) and I can’t save the query.

Tanks.

Hi,

yes - there's no support for SQL Server 2005 in an Access 2003 ADP (you cant save tables, ,,,). If you have this combination it would be better to make a mdb file with odbc connection.... access 2007 supports sql server 2005 more or less...

if you create a mdb you can execute your sql query with ado or pt querys...

regards

audi

Access and extended properties

Hello,
Can I read and write the extended properties with Access?


If it’s possible is better create a project (ADP) or a classic MDB?

When I try with this query in the query panel (in a MDB)

SELECT objtype, objname, name, value
FROM fn_listextendedproperty
(NULL, 'schema', 'Person', 'table', default, NULL, NULL)

I have this error message:

The size of a field is too long

If I try with an ADP, when I ask a new query in design view, I have a message for some roblems between the Access version (2003) and SQL Server version (2005) and I can’t save the query.

Tanks.

Hi,

yes - there's no support for SQL Server 2005 in an Access 2003 ADP (you cant save tables, ,,,). If you have this combination it would be better to make a mdb file with odbc connection.... access 2007 supports sql server 2005 more or less...

if you create a mdb you can execute your sql query with ado or pt querys...

regards

audi

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
JonSounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:

>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
JonSounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:
>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
Jon
Sounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:

>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>
sql

Tuesday, March 20, 2012

Access 2007 Project - SQL Server 2005

Does anyone know whether it is possibe to create an Access 2007 Project - SQL
Server 2005 and have the ability to switch the current database within the
project?
I have multiple customer databases that need updating.
Thanks in advance.
Why don't you read the reply to your yesterday's post in the other group?
"Ed C" <Ed C@.discussions.microsoft.com> wrote in message
news:FA02AA5A-11A7-49C1-8923-E1A9C1CB8830@.microsoft.com...
> Does anyone know whether it is possibe to create an Access 2007 Project -
> SQL
> Server 2005 and have the ability to switch the current database within the
> project?
> I have multiple customer databases that need updating.
> Thanks in advance.
sql

Access 2007 Project - SQL Server 2005

Does anyone know whether it is possibe to create an Access 2007 Project - SQL
Server 2005 and have the ability to switch the current database within the
project?
I have multiple customer databases that need updating.
Thanks in advance.Why don't you read the reply to your yesterday's post in the other group?
"Ed C" <Ed C@.discussions.microsoft.com> wrote in message
news:FA02AA5A-11A7-49C1-8923-E1A9C1CB8830@.microsoft.com...
> Does anyone know whether it is possibe to create an Access 2007 Project -
> SQL
> Server 2005 and have the ability to switch the current database within the
> project?
> I have multiple customer databases that need updating.
> Thanks in advance.

Access 2007 Project - SQL Server 2005

Does anyone know whether it is possibe to create an Access 2007 Project - SQ
L
Server 2005 and have the ability to switch the current database within the
project?
I have multiple customer databases that need updating.
Thanks in advance.Why don't you read the reply to your yesterday's post in the other group?
"Ed C" <Ed C@.discussions.microsoft.com> wrote in message
news:FA02AA5A-11A7-49C1-8923-E1A9C1CB8830@.microsoft.com...
> Does anyone know whether it is possibe to create an Access 2007 Project -
> SQL
> Server 2005 and have the ability to switch the current database within the
> project?
> I have multiple customer databases that need updating.
> Thanks in advance.

Access 2003 Project Connecting to SQL 2000 & 2005 Servers

We have an Access 2003 Project that it's primary server is a SQL 2000 server. When I link a table to the 2000 server and execute the view, I get data with no problem. I link a table to the 2005 server and execute the view...once again, no problem. However, if I try to write a query to pull data from both views......times out. I have changed the timeout value to "0" and never returns the data.

So then I created a new Access 2003 Project to use the 2005 as the primary server. Once again I create a linked table and execute the view on the SQL 2000 server and it works just fine. Then create a linked table to the 2005 server and the view works just fine. However, here's the difference. When I try to create a query to pull data from both views, I get:

  1. This version of Microsoft Office Access doesn’t support design changes with the version of Microsoft SQL Server your Access project is connected to. See the Microsoft Office Update Web site for the latest information and downloads. Your design changes will not be saved.

  2. You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems. Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected. You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools.

Any assistance would be GREATLY appreciated. I'm stuck and wish I could make this happen.

PS:....

The version of Access 2003 specifically is: Microsoft ? Office Access 2003 (11.6566.6568) SP2

I've even made two linked tables to the 2005 server and executed each view by themselves and it worked fine. However, if I try to create a query off of those linked tables, same errors just posted above.

I'm afraid that Access ADPs aren't going to work all that smoothly with SQL Server 2005--they are created for SQL Server 2000 and earlier. If you're creating a new app, it's recommended that you use an mdb with linked tables because it gives you more flexibility. ADPs were designed around the scenario that you would connect to *one* SQL Server database, not multiple databases. One option if you must use ADPs is to create views to access data in another database. You can then use those views in your Access FE.

--Mary

sql

Access 2003 and SQL Express

Is there a way to integrate Access 2003 as the Front End for SQL Express?

I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow.

As you can see, I am totally new to SQL and any help would be appreciated.

Thank You,

James

The default login/password would probably be sa, with an empty password. That's generally what SQL Server uses before it's changed by the end user.

|||Create an ODBC connection using administrative tools, and then connect to it from ACCESS.|||Where can I find the appropraite adminstrative tools?|||

Run the following from DOS:

%SystemRoot%\system32\odbcad32.exe

This creates ODBC connections. Administrative tools gives you access features of the OS to meddle with, important if you are a programmer. I would suggest you get familiar with them, although I believe you need to be an administrator to access them. To add the shortcut to the Start Menu\All Programs menu

Right Click on taskbar\ start menu:

Properties>Start Menu Tab>Customize>Advanced Tab

Also, you have access to a full range of management utilites from mmc.exe. Run this, then add the appropriate snap ins.

Check out this link from MS:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/app_misc_pr_load_snapin.mspx

HTH

|||

Thanks a lot for the help. Defintely helped out a lot!

Monday, March 19, 2012

Access 2000 project

Hi,

I am using Access 2000 to access a SQL Server 2000 database. The records are
read only, and I can't make any changes to them. How can I change this? I've
checked Help, but don't seem to be able to find what I need to know.

Thanks! JillJill,

Make sure the tables in SQL Server had a "primary key". If it does not,
Access can not modify the records. I hope this solves your problem.

Oscar...

"JA" <jarmour@.kc.rr.com> wrote in message
news:tLF8g.68068$Tf1.27575@.tornado.rdc-kc.rr.com...
> Hi,
> I am using Access 2000 to access a SQL Server 2000 database. The records
are
> read only, and I can't make any changes to them. How can I change this?
I've
> checked Help, but don't seem to be able to find what I need to know.
> Thanks! Jill

Access 2000 Frontend MS SQL 2000 backend - Locking Problems

We are using an Access 2000 project to view our SQL Tables and using Access 2000 Runtime to Access the forms in the project. We have written in a locking system in VB and removed the video controls to prevent users from accessing the same records. But of course now we need to make the video controls available. This has now thrown up the problem of multiple users accessing the same records. We have tried to write code to lock records when then video controls are used but this is not working as well as we hoped. Can anyone please suggest any way of setting up locking on SQL using triggers from the Access frontend? or any other types of locking systems that could be written in the Access front end.

The safest and easiest way to use locks having to do with SQL Server in a distributed application is to use SQL Server locks themselves. See the links below for information on how SQL Server locks work and how to use them.

http://msdn2.microsoft.com/en-us/library/ms189857.aspx

http://www.informit.com/articles/article.aspx?p=26657&rl=1

http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm

http://www.databasejournal.com/features/mssql/article.php/3289661

http://www.sql-server-performance.com/articles/per/advanced_sql_locking_p1.aspx

http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/

Hope that helps,

John

Access 2000 Frontend MS SQL 2000 backend - Locking Problems

We are using an Access 2000 project to view our SQL Tables and using Access 2000 Runtime to Access the forms in the project. We have written in a locking system in VB and removed the video controls to prevent users from accessing the same records. But of course now we need to make the video controls available. This has now thrown up the problem of multiple users accessing the same records. We have tried to write code to lock records when then video controls are used but this is not working as well as we hoped. Can anyone please suggest any way of setting up locking on SQL using triggers from the Access frontend? or any other types of locking systems that could be written in the Access front end.

The safest and easiest way to use locks having to do with SQL Server in a distributed application is to use SQL Server locks themselves. See the links below for information on how SQL Server locks work and how to use them.

http://msdn2.microsoft.com/en-us/library/ms189857.aspx

http://www.informit.com/articles/article.aspx?p=26657&rl=1

http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm

http://www.databasejournal.com/features/mssql/article.php/3289661

http://www.sql-server-performance.com/articles/per/advanced_sql_locking_p1.aspx

http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/

Hope that helps,

John

Access 2000 connection failing to SQL Server2000

Hi guys,
I have an Access .adp project which is connecting to a SQL Server 2000 database. I am using Windows NT authentication.
When I open my access project I get an error message indicating that the stored procedure called from my start up form could not be executed. The problem is that the connection does not appear to have created.
In the main menu I click File and select Connection
The server is correctly selected in the drop down list on the pop up screen.
I click on 'Test Connection' and the I get a message indicating success. Now my project is connected and I can continue through the other forms and reports, executing stored procedures and getting records in my reports.
Any ideas on why the project is not connecting on start up, and why simply testing the connection appears to resolve the problem?
Has it something to do with DNS?First of what is the SP level on SQL server and what is the exact error message?

Sunday, March 11, 2012

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Thursday, March 8, 2012

absolute path information is required

Hi all,
When i transfer my c#.net project to other computer,the report part of my project that worked correctly in my computer,did not work and give me this error :
"absolute path information is required"
what is my problem? i use access database for my reports
I try to create a blank report with no database,but i get this error again.
thanks for your help.Would you please send your code for loading, showing report.
I want to know, if you used untypedreport or typedReport,
WebApplication or windows application.|||public class ReportForm : System.Windows.Forms.Form
{
Thread waitThread;

ProgressBarForm pb;

private CrystalDecisions.Windows.Forms.CrystalReportViewer reportViewer;

private Reports.PulseReport pulseRpt = new Swiching.Reports.PulseReport();
private Reports.AllPulseReport allpulseRpt = new Swiching.Reports.AllPulseReport();
...
...
...

public ReportForm(string type)
{
InitializeComponent();
this.reportViewer.ReportSource = this.pulseRpt;
}

public ReportForm(string type,FileConnect.customer[] p,string bdLabel)
{
InitializeComponent();

waitThread = new Thread(new ThreadStart(wait));
waitThread.Start();
int temp;

TextObject beginRp = (TextObject)this.allpulseRpt.Section1.ReportObjects["beginRp"];
beginRp.Text = bdLabel;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =@."......Data Source=""Swiching.mdb""......";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
conn.Open();
string ffirst = Config.GetNum("FirstNum");
string fcap = Config.GetNum("CapNum");

for(int counter = 0;counter < int.Parse(fcap);counter++)
{
temp = int.Parse(ffirst)+counter;
cmd.CommandText = @."insert into pulse values("+temp.ToString()+","+p[counter].city.ToString()+","+p[counter].intercity.ToString(+","+p [counter].national.ToString()+")";
cmd.ExecuteNonQuery();

}
conn.Close();
this.reportViewer.ReportSource = this.allpulseRpt;

}

private void wait()
{
pb = new ProgressBarForm();
pb.ShowDialog();
}

private void ReportForm_Load(object sender, System.EventArgs e)
{
pb.Close();
}

}

When i transfer my project to other computers and call ReportForm with each of above constructors i get "absolute path infomation is required" error.|||Hi.
Where do you load report? Is it typedReport?
I read your code. But I didn't understand where you set datasource of report. It seems you connect to database directlly.

I am sorry. I don't know reason. But you can examin
Initialize reportClass PulseReport in constructor, no difinition.
Try showing report without any datbase fields.
Trace code to find exact line of error
load report by using path, not instance of typedreportdocument.|||Try hardcoding the path into your connection string
Data Source=""Swiching.mdb""......";

should be

Data Source=""D:/anywhere/data/Swiching.mdb""......";|||Hi all and thanks for your reply

I add following code after InitializeComponent() :

crConnectionInfo.ServerName = Application.StartupPath + @."\swiching.mdb";
crDatabase = allpulseRpt.Database;
crTables = crDatabase.Tables;
for (int i = 0; i < crTables.Count; i++)
{
crTable = crTables [i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
rTable.ApplyLogOnInfo(crTableLogOnInfo);
}

Then I try to install my program on 6 computers and i found that only two computers have this problem and my report run correctly on other computers !!!
All computers have Windows XP SP2.

Dear zdehkordi ,i load report by following code in other form :

if(type == 1)
{
ReportForm rf = new ReportForm("AllPulse",p,bdLabel,edLabel);
rf.Show();
}|||Sounds like the directory structure is different on those two computers.
How does it differ from the others?
Are all the components in the right place?
Is Application.StartPath declared and valid?

Friday, February 24, 2012

about SQL Server Express

i am current developing a project. in visual studio i can create a database file. if i use the database file in my app. does it require SQL Server Express install on a user pc in order to run my app?

thanks

If you can create a DB within Visual Studio, then you already have the SQL Express installed on your PC.|||

i meant when people using my app, will they have to install SQL Server Express?

thanks

|||If this is a web application, then only the web server requires SQL Express. Clients only require the browser. On the other hand, if you're building a Windows application that run locally on each PC, then yes, you do need local installation of SQL Express.

Sunday, February 19, 2012

about related parameters

a reporting project with 4 parameters,eg.paraA paraB paraC paraD if the
user selects paraA=B then paraB will appears.can this be achieved?Yes, sort of.
You can't have them hidden, but you can have them dependent on one
another so that B can't be selected until after A is, etc.
You would need seperate data sources set up for stored procedures
similar to the following, the paramiters would need to be set up to
query the data source for values:
(optional, you could manually add these values or allow the user to
type a value)
GetParaAList
(required)
GetParaBList @.ParaA
GetParaCList @.ParaB
GetParaDList @.ParaC
You could then have a final stored proceedure:
GetMyReportValues @.ParaA, @.ParaB, @.ParaC, @.ParaD
Note that in this case the report cannot be run unless A,B,C, and D
have values selected.

about publish

supposed the reporting project has been finished in the vs.net,i have
to submit
it to my client who has a server with the reporting servive running on
it,
how can the project be submitted to the client?
on my local server with vs.net,pressing run will publish the report
automaticlly.
but if i want to publish it on another computer without vs.net,how can
this be done?
is reporting manager the only method?
btw:the client means the one who buy the code,not the one who view the
report...
can u understand?
thanks in advance.You can use ReportManager to upload the report file, you can use VS to
publish to the Production server, or you can write a script to upload using
the ReportServer web service.
"Spirit" <qmxlf@.163.com> wrote in message
news:1132632108.323687.48160@.g44g2000cwa.googlegroups.com...
> supposed the reporting project has been finished in the vs.net,i have
> to submit
> it to my client who has a server with the reporting servive running on
> it,
> how can the project be submitted to the client?
> on my local server with vs.net,pressing run will publish the report
> automaticlly.
> but if i want to publish it on another computer without vs.net,how can
> this be done?
> is reporting manager the only method?
> btw:the client means the one who buy the code,not the one who view the
> report...
> can u understand?
> thanks in advance.
>