Using of sql server for back end database

[Nandini]

I splitted my access database into back end and front end. Now I want to
place this back end database only to sql server in order to overcome the 2GB
limitation and after that which can be retrieved by same front end. I used
Access 2003 and I installed sql server 2005 express edition as I want to
experiment first only in my local machine. But I couldnt do that. Can anyone
help me anyway?
With regards,

 

[Gina Whipp]

Nandini,

If you are refering to Upsizing your back end to the SQL Server, tyr
this...

1. Open the back end
2. From the Menu at the top select Database Utilities... Upsizing Wizard...
3. Follow the prompts

If this is not what you meant by "But I couldnt do that..." please provide
additional information as to what you couldn't do.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Nandini]

Thanks for your response. Yes I have already gone through the process as you
told but in selecting data source I am facing problem to give 'DSN name' in
'file data source' window of the upsizing wizard. The folder containing the
back end databse shows here blank where I have chosen 'use existing database'
of the wizard.
With regards,

 

[Rick Brandt]

Thanks for your response. Yes I have already gone through the process as
you told but in selecting data source I am facing problem to give 'DSN
name' in 'file data source' window of the upsizing wizard. The folder
containing the back end databse shows here blank where I have chosen
'use existing database' of the wizard.
With regards,

SQL Server databases are accessed as a service, not as a file in a
folder. You need to have the SQL Server service running and then you
connect to it. The connection definition is normally stored in a DSN
that you create in Control Panel using the ODBC applet. It is such a DSN
that the wizard is asking for.

Frankly, not being aware of this suggests that you really need to stop
and spend some time learning how SQL Server works before you try to run
your database with it.