Using of SQL server for back end database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Using of SQL server for back end database

Author

Topic

Diya
Starting Member

11 Posts

Posted - 2009-03-15 : 01:42:25

I created an access database using Access 2003. It is splitted into back-end containg related tables and front-end database containg queries forms etc. Now I am trying to upsize only the back-end database to sql server database through upsizing wizard of Ms Access in order to overcome the 2GB limitation of Access database. I want to retrieve data through jet database engine. But I couldnt upsize. I got following message after going through the upsizing wizard:
"Connection failed:
SQL State 01000
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed
SQLState: 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQLServer does not
Exist or access denied"
I installed SQL Server 2005 express edition.
My work is limited within the local machine. I dont want to use networking.
What should I do?
Anyone can help me anyway?
With best regards,
Diya

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-03-16 : 17:23:48

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121792

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources