Sitemap

Amicuk Programming Answers

Accessing an SQL Server Database created by MS Access Web App

-0001-11-30   Views:0

Advertisement

1.I have tried to use MS Access Web App which has created an SQL Server Database. I would like to access the database using SQL Management Studio Express 2014.  In access I can see the server name on windows.net and the database name but I do not kno

1.I have tried to use MS Access Web App which has created an SQL Server Database. I would like to access the database using SQL Management Studio Express 2014.  In access I can see the server name on windows.net and the database name but I do not know
how to connect to this using SSMS Express 2014. Can you please help?                                                                         
2.I also want to view our emails on MS Exchange in real-time. In MS Access Jet I can do this by linking the folders as tables. Is there a way of doing this in SQL Server? If not can I have a separate MS Access Jet with linked tables which I can then link into
my SQL Server as an OLEDB Linked server?                                                                                                                         
3. If going for the Linked Table in Jet solution where can I store it so that my MS Access Web App will have access to it?

The replay answer
Advertisement
Hi gkounis,
I don't think it support link MS Access Jet with linked tables in SQL Server.
Can you share some info about your MS Access Web App?
Regards,
Black

Go to See the other 2 answers

Accessing an SQL Server Database created by MS Access Web App

Category:DefaultRelease time:-0001-11-30Views:130

1.I have tried to use MS Access Web App which has created an SQL Server Database. I would like to access the database using SQL Management Studio Express 2014.  In access I can see the server name on windows.net and the database name but I do not kno[More]

Move SQL Server database for App Controller

Category:DefaultRelease time:-0001-11-30Views:130

I need to migrate our App Controller server to another SQL Server. I have copied the relevant SQL Server database. How can I reconfigure App Controller to use this new database?Hi evilclive1, To minimize the risk of data loss, I recommend the followi[More]

How to create a .mdf SQL Server database from a Data-Tier Application file that has data?

Category:DefaultRelease time:2015-10-11Views:130

This is a noob question, though I do use SQL Server databases all the time with Entity Framework when I code in C# using Visual Studio 2013.  The development environment is found below at [A].  I am trying to make a clone of a SQL Server 2008 R2 data[More]

Best practise for creating an application that connects to a SQL Server database

Category:DefaultRelease time:2015-10-11Views:130

I have created an application that connects to a SQL Server database and views information using a datagrid and performs several updates when a button is selected.   I have created a SQLcontrol.vb using the following code: Imports System.Data.Sql Imp[More]

Configure Synchronization Connections An error has occurred while accessing the SQL Server database

Category:DefaultRelease time:2015-10-11Views:130

Hi, i am getting following error message Central Administration --> Synchronization Connections An error has occurred while accessing the SQL Server database or the SharePoint Server Search service. If this is the first time you have seen this messag[More]

How to create a sql server database in SQL DEVELOPER.

Category:DefaultRelease time:2015-10-11Views:130

I installed the SQL DEVELOPER 1.5.5, but i can't found where to create the sql server database in it. please kindly tell me if you feel free. Thanks so much in advance.Hi, Take a look at the main [ SQL Developer page on OTN|http://www.oracle.com/tech[More]

Create a visual web part which get data from excel sheet and import it into sql server database in sharepoint 2010 (development)

Category:DefaultRelease time:2015-10-11Views:130

Hi, I want to create a visual webpart which will read data from excel sheet and import it in to sql server database.(using sharepoint development) I want to do it using visual webpart. Please help to solve the issue. Thanks in advance! Regards RajniH[More]

How I can install and configure dg4odbc to access SQL Server database

Category:DefaultRelease time:-0001-11-30Views:130

I need to link Oracle database (installed in Solaris) to SQL Server database. How can I install and configure dg4odbc. Is there any step by step tutorial or guide available there.Thanks in advance.Hi,   You can download the DG4ODBC software from eith[More]

Converting Access application after migrating SQL Server database

Category:DefaultRelease time:-0001-11-30Views:130

I have used migration workbench to migrate an access database and application. I now have sql server databases with access applications that need to be migrated. How can I convert the access applications that currently use sql server as a database? I[More]

Using integrated security to access SQL Server database

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Currently we are using username/password combination to log in to a SQL Server database. These varaiables are defined as environment variables. For security reasons we now want to use integrated security of the SQL Server database. This way the c[More]

How can I  connect to SQL server database thru local network by using JSP?

Category:DefaultRelease time:2015-10-11Views:130

I'm currently doing a project by using JSP..And I need to display record from the SQL Server database in our school's local network. May I know how can I do that? How can I write the code so that I can able to access the SQL Server databsase Throught[More]

Hot
Sorry, I'm a bit of a newbie to imovie. Could anyone tell me if there is a way of adding text to a photo? Bascially I have a series of photos in imovie, and I want to show the picture & then have some text at the bottom - but the text is indivdual fo [More]
My 13" MBP is less than two months old. I read online somewhere that a company that buys large quantities of Macs has a strategy for combating the industry standard 5% hard drive failure in new notebooks. It said something along the lines of performi [More]
I'm having a couple of issues with my iMac desktop. After it sits idle for a while it freezes.  At first the mouse doesn't respond at all.  Then, if I can get it moving, I get the spinning wheel that won't go away.  I have to end up turning it off, t [More]
Hello, I have installed v4.6 for my desktop manager and it the Roxio media manager worked fine for a couple times and now it tries to reinstall it everytime i use it?  1) Why is it trying to reinstall? 2) How can i fix it? did you read the complete d [More]
I have set up the printer on my n-basestation. It's visible through Bonjour. All drivers are installed, and Macbook Pro restarted. But, when I try to print my mac gives a "communication error" and nothing happens on the printer. I then installed [More]
I previously started a discussion which got marked as solved when it isn't. I want to delete photos on iPad .   iMac recognises iPad but not the photos on it .  I have tried iPhoto and the application Image Capture b ut the result is the same. Can an [More]
Hi, I have not found any datasource for Infocube 0SR_FIC01. I have checked in BI content and sap.help.com. There I found like there is one InfoSource (0SR_FI_SL_GLS), DSO (0SR_FIDS1) and InfoCube (0SR_FIC01). But I did not find any DataSource, Transf [More]
I'm having difficulty connecting my BlackBerry Pearl 8100 to my Mac for transfering MP3s and photos. What is the best way to achieve this, as RIM's software does not supoort Mac?Would a bluetooth connection work? What about iSync?Read other 2 answers [More]
When I try to burn a CD I get "medium write error" message. How to fix this?Hi ramseyer, If you have difficulties burning CDs in iTunes on a Mac you will want to follow the steps outlined in this article to troubleshoot - iTunes 11 for Mac: If y [More]
Hi, I am creating a query for my client for top 5 country in europe and furher from thouse top 5 country top 5 city and in thouse city 5 top sales person. I am bit confused what should be the best approch to achive this. your suggestion will be very [More]