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
I need to set the page size everytime I go to print from my Adobe Reader in my windows 8. Is there a way to set the page I want letter (8.5 by 11) as a default? So I do not have to do this everytime I print something?I can't help but wonder why Adobe [More]
How do i make an apple id without a credit card on ios 5.1.1If you only want the free apps, take a look here: http://support.apple.com/kb/HT2534 Read the steps carefully as the order in which you follow them is  critical. Note that you can do this on [More]
I have a form with an e-mail submit button that opens an outlook email with the .pdf file as an attachmnet, and addressed to the e-mail addresses i put in tthe address field. What we are trying to abvoid is sending a bunch of attchement to numerous p [More]
Hi -- I have 2 prompts - the second prompt is constrained by the first so when I select Southeast region in prompt one, it only gives me the States in that region within the second prompt. I am hoping to only show the second prompt after the first on [More]
Hi, I'm an infrequent user of AI, so have a very pathetic question. We have been sent a lovely AI file. We need to save part of the file in .wmf format so we can include it as a nice crisp vector banner graphic in Word (yes, Word). We can't figure ou [More]
Is there a way to add JavaScript to a button when creating an Interactive PDF in InDesign (CS6)? This Interactive PDF is being turned over to other developers, who need to tack on a Certificate/Completion process, which is called to from a script tha [More]
Hi, I have a G5 tower with ATI Radeon 9600 Pro running two fujitsu LCDs, both at 1680x1050, 60 hz. Today, they're both incredibly fuzzy - bordering on unusable. They remain this way if I step down to lower res. This is only on my login. My wife's log [More]
I noted before that I was unable to open a wmv file. I have tried VLC, DIVX, and XDiv all without success. the VLC application gave me a little extra information that should be relevant. It tells me that it can't open a wvp2 file. Can that help anyon [More]
I have created a simple search page in the OA Framework. What I need to do is that when this page is launched, I need to do auto execute query of VO based on set_of_book of responsibility so that it displays only USD records if responsibility is in U [More]
I just started using Time Machine three days ago, and it seemed to be working. Every hour the tool bar icon spins, a disk image appears on the desktop, and in Preferences it'll give me the last back up (currently 2:25 PM. When I enter Time Machine to [More]