Need An Opinion: Access Vs. SQL Server Express Or Another Alternative?

Apr 30, 2007

I inherited this website from a previous developer that uses an Access DB as a backend.  Ugh.  Apparently, he was extremely limited in what databases he could use.  The website is filled with problems related to connecting to this database, which is no surprise.  Most of them are related to permissions to the database file, multiple user access, etc.
 
I am thinking about moving this to a SQL Server Express DB and upgrading the site to the 2.0 framework.  Most of my experience is in SQL Server, but since they can't, or won't, pay for the SQL Server Database, is this a good solution?  I've considered using MySQL as well, but their host won't provide support for this.  Are there any other recommended alternatives?

View 2 Replies


ADVERTISEMENT

Sql Server Express And Access

Jul 23, 2007

Hi,
i am very new to databases. I use VWD 2005, Sql Server Express 2005 and have a remote database through a host rather than my own server. i have managed to create sql databases fine. Its with Access Databases Im really geting confused:
Can i use an access database I have created using VWD and sql server Express 2005? Or would it run just through VWD and the remote ?
If i use VWD I dont usually need to use IIS but if the latter of the two options is what I must do then i would manually need to create a virtual folder?
Nick

View 3 Replies View Related

SQL Server Express Access

Nov 29, 2007

I just downloaded SQL Server Express from online and I'm unable to access it now. I cant make a connection nor can I create a database. Could anyone help me out with this and let me know what I've done incorrectly?
 Thank you!

View 4 Replies View Related

Can't Access SQL Server DBs From VS Express

Sep 14, 2007

Hi,

I've installed Visual Studio Express C# and Visual Studio Express Web Designer along with SQL Server. I've downloaded the example databases and have installed them - I can access the databases using the SQL Server tools.

When I try to access any SQL Server databases (specifically the Northwind example DB) via the Add Database Connection dialog in either C# or Web Designer, I get an error box with message "Exception has been thrown by the target of an invocation".

I get this when I manually enter Northwind in the Database Name field; if I try to browse, the whole dialog exits, or, sometimes Visual C# Express crashes. Since the same problem occurs both within C# and Web Designer, I'm assuming the problem is in SQL Server, which is why I'm posting in this forum.

I'm sure I have some configuration problem, and a complete uninstall/reinstall is certainly a possibility, but I'm hoping someone has an idea about how I can around this problem without having to reinstall.

Thanks for your time,
Larry

View 4 Replies View Related

MS Access Or SQL Server Express

Aug 27, 2007

I have been developing a database application in MS Access that is intended for distribution. Before I go any further I would like to make sure that I should be using MS Access and not SQL Server Express. Can someone point me to a good source of information on this topic?

View 3 Replies View Related

Access Vs. Sql Server Express

May 23, 2008

What would be the reasons for choosing (or not choosing) SSEE over say Microsoft Access in a Desktop application?

View 13 Replies View Related

Convert SQL Express To SQL Server Or Access

Dec 15, 2006

Is there anyway to convert an SQL Express database to SQL server or Access format?

View 1 Replies View Related

Unable To Access SQL Server Express

Jun 14, 2007

I logged on to my SQL Server Express this morning and received the following error:
 Cannot connect to MICHELLEWSQLEXPRESS.
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
 
What is interesting is that its on a local computer.  I followed one recommendation to enable the pipes and tcp but that didn't work either.  How do I change the default settings to allow remote connections (on a local computer) when I can't log into the server?

View 2 Replies View Related

Convert Access Into SQL Server Express

Dec 7, 2007

Sorry if this has been answered before. Could not find any answers.
OS Vista Business, SQL Server 2005 Express.
I have a CSV file which I imported to Access only 100 records with 8 fields. Then ran Tools >> Database Utilities >> Upsizing Wisard. The result was I exported the table field headers but not the data. Is there any method on how I can get the field headers and data into SQL Server Express? 

View 2 Replies View Related

Need Access-like Security Of SQL Server Express

Jun 8, 2007

Is there a way to implement Access-like password protection on a SQL Server Express dataset?



The database will be deployed on individual's PCs with no centralization of control. I want to restrict users from being able to see table definitions, stored procedures, etc. Access-like password protection is what I want, but I don't see any similar feature within SQL Server Express. Am I missing something?

View 1 Replies View Related

Access 2003 And SQL Server Express

Sep 4, 2006

Does anybody know if there is and update for access 2003 which could make it compatible with SQLServer Express. Actually XML Field are not supported, Diagram too, and surely much more.

Any help would be appreciate.

View 1 Replies View Related

SQL Server Express And Access 2003

Apr 7, 2006

I recently started developing a new Access project for a client, and decided to try out Access 2003 with SQL Express 2005. Everything was going fine until I tried to modify a table from within Access. I got an error message that SQL Express is incompatible with Access 2003, and it suggested I go to the Microsoft website and search for a patch/upgrade to solve this.

I tried to ignore it, and it started warning me that none of my table edits would be saved.

I looked around, but I can't find anything about this.

Is this true? Is there a patch to fix this?

View 7 Replies View Related

ACCESS USE WITH SQL SERVER EXPRESS QUESTION

Oct 8, 2007

HELLO,

I DEVELOPED AN ACCESS DATABASE FOR MY WORKPLACE THAT IS REALLY AN APPLICATION FORM. THE INFORMATION IS ENTERED THROUGH AN ACCESS FORM. THE PROBLEM I HAVE OF COURSE IS THAT ACCESS IS ONLY A ONE USER APPLICATION. I NEED IT WHERE MORE THAN ONE PERSON CAN USE MY ACCESS FORM AND ENTER INTO THE DATABASE AS THEY ENTER THE APPLICATION INFORMATION OF OUR CLIENTS. I WAS TOLD THAT WE COULD USE SQL SERVER TO MAKE AN ACCESS DATABASE A MULTI-USER PRODUCT. IS THAT TRUE AND HOW IS THAT DONE?
THANK YOU!

View 10 Replies View Related

Migrate To SQL Server Express From Access

Jul 31, 2007



Anything I should know about before I start?

Also I want to work with SQL Express from another workstation instead of directly with the server, which tool do I use to build with it?


Probably very obvious answers but since it is critical to do it right, I wanted to check.

What is the best tutorial in regard to these kinds of functions?

THANKS!

View 1 Replies View Related

MS Access To SQL With SQL Server 2005 Express

Nov 2, 2007

Trying to convert my access DB to SQL using 05 express using the upsizing wizard but receiving "SQL Server does not exist or access is denied"
[microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionOpen(connect())

I'm brand new to this. My site is currenty running cold fusion with MS Access on a remote hosting server that doesn't allow me to update the DB. They suggested migrating to SQL with CF so I can make changes without bring down the entire server.

I'm trying to make the conversion on my local machine running XP pro. I have just installed the .net framework and SQL server 2005 express. Do I need a different version?

Suggestions?
Atlantisherbs.com

View 4 Replies View Related

How Can I Access SQL Server Compact Edition With SQL Server Management Studio Express?

Jul 26, 2007

Hello,

I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.

To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.

To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1".

Is there perhaps an additional step that I left out to complete the installation?

Might I need an upgrade to some other components? My Management Studio Version is:

- Microsoft SQL Server Management Studio Express 9.00.2047.00

I would appreciate any help you can provide.

Thank you,

WTW

View 7 Replies View Related

SQL EXPRESS Reporting Server (Access Denied - Windows 2000 Server Domain Controller)

Apr 4, 2007

Subject problem has me quite vexed.



I am receiving the following error when attempting to access reporting services... to sum things up real nice and tidy-



I get three login prompts - then the access denied response. It is almost as if it is unable to authenticate the user... anyway... here's the actual error response, I'd really appreciate any input/insight/resolution.




Server Error in '/Reports' Application.


Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[UnauthorizedAccessException: Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +2014163
System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) +1817
System.IO.Directory.GetDirectories(String path, String searchPattern, SearchOption searchOption) +36
Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures() +112
Microsoft.ReportingServices.Diagnostics.Localization..cctor() +66

[TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Diagnostics.Localization' threw an exception.]
Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[] localeList) +0
Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object sender, EventArgs e) +157
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

View 1 Replies View Related

Alternative To Link Server

Oct 10, 2007

Hi all,

I am having two databases(MS-Sql) on two different servers.Let say they are Server1 and Server2.I am having some stored procedures(sps) which are executing on Server1.Results given by these sps are 6 different tables(Theses tables are temporary tables e.g #Table1 and they are created in one of the sps on Server1). And I want to use these 6 tables on Server2.
But constraint here is, i can create link server for Server1 from Server2 but not from Server1 to Server2.So i can not access Server2 directly from Server1.
Even if i am using custom tables here instead of temp tables(#) it will take me to solution but that is again a constraint i can not do this.
Is there any alternative solution for Link server in this case?
I dont want to go for OPENROWSET and OPENDATASOURCE b'coz of performance issue.

Thank you in advance!!

Kedar Waghmode.

View 9 Replies View Related

Sql Server 2000 , DAC Alternative ?

Oct 30, 2007

Hi There

I have a Sql Server 2000 SP4 Enterprise Edition instance that experiences tremendous performance issues.

Problem is when i try analyse what is happenng , with profiler or Query analyser the server is under such strain that nothing works.

Profiler time's out, queries cannot execute due to insufficient memory.

There is no dedicated admin connection in SS2000.

Any alternative methods around this in SS2000 ?

Thanx

View 4 Replies View Related

Importing Access Tables To Sql Server Express

Oct 29, 2006

hi. this is a beginner question as i am new to databases :)so, I have an access database and I want to take 2 tables from it and copy it to sql server in my ASP.NET application (.MDF file)I have visual studio 2005 installed on my computer and got no sql server 2005 installed on it. what is the way copy 2 tables to the ASP.NET database application?thanks alot guys.

View 2 Replies View Related

How To Access Sql Server Express From Other Computer On The Netwrok

Jan 8, 2007

Hi expertsI use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error. Thanks 

View 2 Replies View Related

Only Local Access To SQL Server 2005 Express Ed. ?

Aug 2, 2007

Hello!
I run an application with a SQL Server 2005 Express edition.

I read under

Start menu
--> all programs
--> Microsoft SQL Server Express
--> Configuration Tools
--> SQL Server 2005 Surface Area Configuration
--> Surface Area Configuration for Services and Connections
--> Database Engine
--> Remote Connections

That:
"By default, SQL SERver 2005 Express, Evaluation and Developer editions allow local client connetctions only. Enterprise, Standard and Workgroup editions also listens for remote client connections over TCP/IP. Use the options below to change the protocols on which SQL Server listens for incoming client connections. TCP/UP is preferred over named pipes because it requeres fewer ports to be opened across the firewall."


Here I chose the option "Local and remote connections only, using TCP/IP only".


But still, does this mean that other users can't connect to my database since I'm running the Express edition?

If that's the case, could this be changed by using mySQL instead?

Is it hard to transfer a MS SQL Server .mdf database file into a new mySQL database?

View 3 Replies View Related

Granting Users Access To SQL Server Express

Mar 3, 2008

I have now succefully setup SQL Server Express on an Admin PC in my office and can see it and connect to it easily from my PC using my NT logon.

My application is complete and runs a treat for me connecting to the server from my PC.

I have now deployed the application using ClickOnce and it has all gone smoothly, except for other NT users gaining access to the database?

Within MSMSE I have clicked on Security-Logins and can see my NT login details are present and as me I can administrate the server/db.

I have added a few new logins and even tried to match them to my settings but from their computers the application fails to logon to the server/database.

Within the ODBC setup the server is visible for them but they cannot connect?

If I logon to their computer it works for me?

This section is new to me so I am struggling to get it to work, can anyone throw me a bone please?

Thanks

View 1 Replies View Related

Importing Access Database Into Sql Server Express

Feb 15, 2006

[Note: originally posted this on microsoft.public.sqlserver.programmingbut had no luck there...sorry if you're seeing this twice]Some facts:1) I have an Access database (.mdb file) sitting on my harddrive.2) I have Visual Studio 2005, Sql Server Express, and Sql ServerManagement Studio Express.3) I do *not* have Microsoft Access.What I'm trying to do:I simply want to import the Access database into Sql Server Express. Inother words, I want to end up with a Sql Server Express database thathas all the same tables, keys, and relationships as the Access databaseas well as all the data from it. I can live without the queries storedin the Access database, but those would be nice too.What I've tried so far:I'm able to connect to the Access database using the "Linked Servers"features in Management Studio Express. From there, I was able to writesome simple Transact-SQL queries to find out what tables are in theAccess database and copy them, one at a time, into a Sql Server Expressdatabase.This is definitely a good start, but it doesn't take care of theprimary keys or foreign keys. There appear to be procedures for thoseas well (sp_primarykeys, sp_foreignkeys), but I keep thinking theremust be an easier way.Which brings me to...Questions:Without having to buy additional software/tools, can I import thisAccess database without a lot of programming? If so, how?Thanks in advance,-Dan

View 1 Replies View Related

SQL Server 2005 Express Remote Access?

Jan 8, 2006

I am currently using a Microsoft Access (MDB) for my application. But I am looking at allowing other users on the network access the same database -- I know a Microsoft Access database is not the best solutuon for this enviroment.

I'd like to use SQL Server 2005 Express in this case. I am very fimilular with SQL Server 2000 Std/Ent editions. My question is, can I use the free SQL Server 2005 Express edition and allow remote users to connect to that database? Or  is it supposed to only be used as a local database accessed by only the machine it's installed on?

 

Thanks,

Jason

View 7 Replies View Related

2Gb Access Database Became Nearly 4Gb Migrated To SQL Server Express - Why?

Jan 8, 2007

I have just installed SQL Server Express 2005 to get around the 2Gb database size limits under Access 2003. My simple 2Gb Access database (simple meaning only 10 tables with 2-10 fields each, vast majority of the data in one of them and mainly Long Integers) became nearly 4Gb when migrated using SSMA - not great when the SQL Server Express database limit is 4Gb. Shrinking makes no difference.

Can anyone suggest why in general a SQL Server Express database would be nearly twice the size as its Access equivalent. Are there some useful tricks or techniques to reduce the apparently massive overhead?

View 3 Replies View Related

SQL Server 2005 Express Import Of Access

Jan 15, 2006

  

  I have installed SQL Server 2005 Express on a laptop for development purposes and would like to import some Access databases that I was using coupled to programs written in VB 6.

 If using SQL Server 2000 I could use the management studio to automate the import but I can not find any way to do this in Management Studio Express. Would have thought that this would be the typical migration route - Access to Server Express

   Is there some way to automate this procedure?

Thanks

 

 

View 8 Replies View Related

Link To SQL Server Express From Access 2000

May 22, 2006

i'm trying to set a data source in Access 2000 to link to SQL Server express..I have mixed mode set..what user/password do I put in? I tried sa, but get error server does not exist, or access denied..
thanks!

View 1 Replies View Related

SQL Server 2005 Express Connection And MS Access

Dec 14, 2007

I just installed SQL Server Management studio express. I am trying to remotely connect to a SQL Server Express 2005 remotely. I was given the server name, user name and password, and used SQL Server authentication. It connected fine, and I was able to get at the intended database.


I then went to ODBC data sources to add this SQL server using SQL authentication. I entered the server, user and password, and I got a nebulous "could not connect" error. I thought is may be because I still was connected in SQL Server Management studio express, so I closed it and tried again with the same error. I then reopened SQL Server Management studio express and tried to reconnect, and got the same nebulous error, and have not been able to connect since.

I tried rebooting and reinstalling SQL Server Management studio express, but had the same result. Does anyone have any idea what I may have done and how to undo?

Thanks,

Steve Colino

View 14 Replies View Related

Is SQL Server Express A Replacement To MS Access Databases?

Feb 27, 2008

I have a small client installable web application which used to work great on 32 bit machines. Well now clients are starting to use x64 Windows 2003 servers and things have begun to unravel. W2K3 x64 does not have any of the JET database drivers needed to communicate to the Access databases and it doesn't look like they're coming anytime soon.

Is SQL Server Express the new replacement for Access databases on x64 machines. Does Microsoft intend on moving some of the JET drivers over from 32 bit servers. I know that you can run IIS in 32 bit mode and everything is fine, but I can't ask everyone to do that.

Is SQL Server Express something that I can expect people to have installed, it sure doesn't sounds like it. After reading some posts, it sounds like it's a bit of a hastle to install.

Thanks in advance for your time.

-Mark

View 3 Replies View Related

Migrate MS Access To SQL Server Express 2005

Jun 30, 2006

I have a database in MS Access that I would like to migrate to SQL Server Express 2005. How do I do this? Is there a software I need to download?

View 4 Replies View Related

MS Access 2002 / SQL Server 2005 Express

Aug 31, 2006

I have few queries:

(1) What is the maximum database size of Access XP and SQL Server 2005 Express?

(2) Is SQL Server 2005 Express edition FREE for development use?

View 1 Replies View Related

SQL Server Express Error: 5 Access Denied

Feb 22, 2007

After installing SQL Server express to my WinXP machine, when I attempt to restore a database from a 2000 backup, I get the following error:



System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTEST.MDF'. (Microsoft.SqlServer.Express.Smo)



Any ideas?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved