Hi,
I'm new to SQL and databases in gnereal but am trying to source an
application for windows that will sit on top of a small SQL database I
have (created for local scout troup), I want an easy way to retrieve/
add/view data from backend in nice menu-driven GUI format (no cmd-
line).
Can anyone recommend a useful app I could source to do this
task....
thanks in advance
terry
If I'm using an Access front-end, and the data is on SQL Server being accesses via a linked table, and I create a query in Access, Where is all the work done?
I know access has the option of using a pass-through method, but if I do not use it, is Access processing the query locally? I plan on migrating several tables to SQL because the sizes are getting to large for Access and want to know if their will be a performance increase with out re-writing the queries in Access.
Thanks in advance,
Adam
how can i do an access frontend to sql server backend
View 4 Replies View RelatedThis maybe belongs in the Data-Access Forum, but I'm not sure.
Is it generally a better idea to enforce things like unique constraints in the Database or the Webform? Say for example I want to make sure no duplicate Social Security Numbers are entered. Is it better to have an "If Exists" clause in my query, with a function to deal with it in the application or is it better to just fire the data to SQL Server and let the unique constraint on the dbase column deal with it? I then still have to have some code in my application to deal with the potential exisatance of that number, so is it a case of tomatoe, tomahtoe? If I understand things correctly, SQL server will return an error code if the piece of data does exist, and I will be able to parse the error code and display a message to the user.
Are there performance/coding issues involved? Best practices?
My company currently has about 20-25 Ms Access Database that they want toreplace the FE with .net and the BE on SQL.This will be done using Visual Studio 2005. Once the FE is converted to .netand the BE is SQL they all will be accessed through our intranet (sharepoint).I work in Ms Access and intermediate at VBA and just learing SQL through theENTERPRISE MANAGER SCREEN.I am just now looking at what Visual Studio 2005 is, but can some one tell mehow this will all connect?What is the typical route for this process?Ms access to SQL - upsizing wizard or SQL importing?????Ms Access FE to .net - summarize how this is done in visual studio (user facerebuilt) then placed on sharepoint?Can anyone sum this up?--Message posted via http://www.sqlmonster.com
View 4 Replies View RelatedI have an application that uses Acces as a backend and VBA as front end. Application is secured and is supplied on a CD with setup.exe.
Can I use VB 2005 and MS SQL to achieve the same?
Would I be able to package my application with all the neccessery files (assuming that client does not have any e.g. SQL server) so that multiple front ends can access data from common source?
Would I be able to secure such an application using only VS 2005?
What would I need to quickly learn how to achieve the above ( any books you can suggest maybe)?
Hi there,I sincerely hope that someone out there can help. I have twoinstances of the SQL 2000 Desktop Engine running. One is on my localmachine for development and the other is on another machine on ournetwork which is the production environment. I have built an Access2003 front end application which connects to this database. Thisworks fine locally, as you would expect. I successfully installed thedatabase on the production machine and am able to connect to it viaAccess 2003 (using the Data Link Properties window) and from thirdparty database manager software (similar to Enterprise Manager). I amnot able to to connect to the database via my application.I am using the "sa" account with a strong password. This is myconnection string:strConnection = "Provider=sqloledb;DataSource=server02;UserId=sa;Password=strong;Initial Catalog=Test"The error I'm getting is:"Connection cannot be used to perform this operation. It is eitherclosed or invalid in this context."The connection string is the only thing that changes in my code when Iswitch from my local to my production database. Is there some reasonthat I can't use the "sa" account in this fashion that I'm not awareof? I'd rather not use integrated security for simplicity's sake asthis is a small, internal application. Also, I would have thoughtthat if that was the issue, I couldn't use "sa" at all, even locally.I'm going to post to the Access group as well but thought someone heremight have some advice to offer as well.Thanks,Barb
View 2 Replies View RelatedI have a database being built that has a java front end, a SQL 2000 back end, and most of my clients are win98, will this work ok?? And if not do I need to upgrade to all w2k?
Thanks for any information.
Charlie
Can both be run on the same service I have a asp.net application that need to use the MS sql 2005 and I have another application PHP that requires MySql. Can bot be run ont hte same server at the same time???
View 1 Replies View RelatedHi,
We are new Access users and trying to take our database live...here are some of the problems we're facing.
When we split our Access database into a Backend and Frontends, a couple of strange things happened in the Frontend:
1.) When we run our queries, multiple copies of the same record are displayed (this is wrong).
2.) When we look at those queries in design view, the field names are preceded by Expr1, Expr2, Expr3, etc.
We have a large number of queries. How can we fix this problem?
Also, if anyone knows any websites or resources that can help us understand what things like Expr1 mean (a reference) that would be helpful too!
Thank You!!!
Hi,
We are not a very advanced group of access users and are trying to split our database for a research study...here is our question:
When we split our Access database into a Backend and Frontends, a couple of strange things happened in the Frontend:
1.) When we run our queries, multiple copies of the same record are displayed (this is wrong).
2.) When we look at those queries in design view, the field names are preceded by Expr1, Expr2, Expr3, etc.
We have a large number of queries. How can we fix this problem?
Also if anyone has a good source for trouble shooting this or simmilar difficulties we'd appriciate any spots or advice.
Thanks!
Hi!
I have some questions about the MSDN article "Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005" (it is msdn2.microsoft.com/en-us/library/Aa454892.aspx).
Everything works good up to Exercise 3: Synchronizing Data Between Any Backend Database and SQL Mobile Database Using a Web Service. It is said that we need a DataService.asmx file to be enetered into "Web reference name". Unfortunately I can't find the HOL302_SQL_Mobile to download and install this file. Where I can find this file?
Can anyone tell me how can I do such a replication(C#)?
How can I synchronise data from mobile device to SQL Server using GPRS connection? (I only know replicating over USB).
Hello all. Yes, this is another question relating to how to make a front-end to a SQL database using ASP.NET. I performed a search in this forum and did not find the exact answer to my questions (one responder to the other threads about this topic even said this is the incorrect sub-forum for this question, but I found no other appropriate place; considering this sub-forum is for asking beginner questions).
Besides the "quickstart" tutorials linked off this site, can you point me to other web resources (tutorials, walk-throughs, etc) or books that would provide the necessary information to develop a SQL front-end? Specifically I need help creating the Update Record and Delete Record pages.
I was hoping a "rapid development" tool could be used. At my disposal I have Visual Studio .NET 2003, Dreamweaver MX 2004, and FrontPage 2003.
Thank you for your time.
please go easy on me as i have had this dumped on me with no Real knowledge of sql.
a company i maintain their pc's for has had a program made for them which uses a sql database. unfortunatly the guy that made it has now emigrated.
they are now wanting a web fornt end so customers can check the status of their order etc..
is this possible
terry jones
I need a value in the SQL2000 database to be returned as a text field in the front end.
i.e. value set as '0' or '1' in the database field needs to be returned as 'No' or 'Yes' in the front end.
If anyone can help with this daft query, it would be greatly appreciated.
I am currently designing an adp front end that links to a Sql Server database.
In terms on front end upgrade prespective i am thinking about a logon routine procedure ( which should be a vba code code that runs at startup) to check wheter the adp front end which is being used is the latest release hence compatible with the database current version.
Create and manage version number at back end level is quiet easy however to set a version number or whatever else information in the adp is somewhat a big hassle as database properties are not available from visual basic when using adp.
Was also thinking about using my xml file which holds my configuration information such as Data source - catalog but that's mean deployment of new front end must be carried out with local xml file change.
Also any manual update of information about version in xml file could allow old front end to run with database.
Please any tips and advises on how to handle this issue highly appreciated.
Regards to everybody
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
Hi,I need to set up a generic table in Oracle that allows users to enterdata that can later be retrieved in reports.I was thinking of a 3 column table in this structure:DATE,ITEM,VALUEfiguring that you can store anything in this way because ITEM can beanything and you can have multiple instances of a particular value byhaving a new date.Does that seem reasonable?In any case, what are my user front end options? I was thinking aMicrosoft Access database but its not ideal because not everyone herehas Access?Can you do it with Excel? Or what other options are there as a simpleuser front end to enter the data?Thanks for any advice.Kim
View 1 Replies View RelatedI have a database that is in mssql and I'm using an odbc link to an access database where I want to add records to the mssql table. When I open the linked table in access it does not allow me to add a record. I have created a user account in mssql that has ownership to the database and I use this user in setting up the odbc link.
View 3 Replies View Related4 Layered Web Application for Inserting data into a database using sql server as the back end and a web form as the front end using C# .
Can someone provide with code as I am new to this architecture and framework.
Better send email.
Thanks In Advance,
A New Bie
We have a Customized share point application with Very minimal data usage and we have used only 5 to 6 lists and libraries only in the share point.
Configuration is
Clients -- fire wall --- Load Balancer ---- WF1 and WF2 --- SQL DB
ROUTING IS VIA FIRE WALL.
SUDDENLY THE SITE GOT DEAD SLOW AND UNABLE TO TRACE THE PROBLEM AS EVERY THING LOOKS FINE.
Checked with the firewall Team and they stated its fine from their end & even we have verified the counters, CPU, Memory & Page life expectancy, buffer counters all looks good and even we do not have huge data in the database. We have only 50 concurrent users are working...
Hi there SQL TEAM
Can someone please point me in the right direction?
We have a customer who would like us to write an application in flash that has a SQL 2005 Backend
Can Flash integrate with Microsoft sql 2005?
And if so are there any tutorials?
I created a SQl Server 7 database and used an Access 97 frontend on the same computer. The Access frontend uses linked tables to reach the SQl server. The security setup I have is based on the NT Domain Accounts and whatever group
I have them in (example: Mr. D is in Marketing therefore he is in a NT Domain
Group called "SQL_MARKETING"...the SQL Server recognizes that everyone in this
group has access to whatever role I have designated for it in the database").
I can access the linked tables fine on my computer at my desk or at the server. Another person with the exact same administration rights as me can
get to the server through the network neigborhood or by mapping..and they
can access the Access frontend with no problem from their computer. But
when they try to open a linked table they recieve an error message that
the ODBC connection has failed. We are all running Access 97 service pack
2 and another person and me have the exact same administration..but only
I am able to access the Access linked SQL tables but not him.I tried deleting
the ODBC system dsn on the server and the linked tables and then re-adding them and the ODBC link but to no avail. Does anyone know why this would
be occuring? Thank You in advance.
and the
I have create an Excel application which connects to an SQL Server backend.I have written an Excel vba procedure to update a table via ADO.But it couldn't---the error message says the provider (sqloledb) does not support updating database.
View 2 Replies View RelatedWe are entertaining the idea of moving our data to a cloud and I need to know how to convert my Access backend DB to SQL. which version of SQL will I need to use to do the conversion and will also work in a cloud environment.
View 2 Replies View RelatedHi,
I have some knowledge of SSIS and CRM. But i don't know how to create Integration Service using CRM 3.0 as my external data source. If anybody know about this, pls give steps to create Integration Service as soon as possible.
Thanx in advance.
I have an exe file which was generated using a visualbasic application and has a backend sqlserver database. the exe works fine on my computer which is also connected to sqlserver and the same exe when i run on the clients computer does not work and gives an error ...related to converstion of datetime datatype ...
View 2 Replies View RelatedI have a database with a sql backend and an access frontend. I put it in a folder on the network for users to access. First, they were getting errors like not being able to access the database if someone else had it open and not being able to perform certain functionality. It was suggested that i put a mde on each of the users pc. i gave them all access to their own front ends on the folder because they use different pcs. this solved the problem. however, i need a way to perform updates without manually creating mdes for every user. i used to work for a co that there was one mde was put into a folder on the network with a config file. The users access the database through CITRIX. Whenever they accessed the shortcut on the server, it created the users their own front end. Whenever we need to provide updates, we simply made a new mde from the mdb and whenever the user accessed the database again, they would have the latest mde and it would created an update frontend for the user. Does anyone know of such an utility or know what I am referring too? I encounted several suggestions like a batch file; but they refer to putting the file and the mde on each users pc. This is not how i'm set up. Thanks
I add a table to sql studio express, but i cand see it in access backend in the other computer.
What is wrong?
Thanks,
Azi
My question is this: "Does anyone know where to set up the connectivity for an access database to store data on an Sql Server?"
View 6 Replies View RelatedHi,
Currently I am developing a project which requires to generate time-consuming reports in ad-hoc real time basis. The mechanism is
(1) User submits report request with required parameters
(2) The request will be processed one by one (I guess a queue is required to monitor the number of requests and the status of each request)
(3) Reporting service will get the report request and generate report in real time.
(4) Once report is generated, send the report to user
So, is there any idea on how to handle this type of mechanism in reporting services? Any tool in MS reporting services that can help?
Thanks in advanced.
Hello. I have an Access 97 frontend and a SQL 7 backend. When I try to open up the linked SQL tables in the frontend I recieve the error " This recordset is not updatable" from Access. I have the permissions in SQL set at this point to public having all permissions but it still does not change my problem. Does anyone know the answer?
View 3 Replies View RelatedWhenever we run the mdx query in SSMS, how it will fetch the data from cube.
Using XMLA script used to fetch the data or any thing else ..