USING SQL Server back End for MS ACCESS Database Front End

Printable View

10-19-2009, 12:27 PM
FMKA

USING SQL Server back End for MS ACCESS Database Front End

Gents,

i Have data base (MS ACCESS) that will work in home server with more than 250 Users the Size is 84,816 Kb but this will increase to achieve 1 GB i did not finish the project yet

to Avoid data Rupture I Want to use SQL Server for Back end will reside into the server and front End linked to each computer what kind of SQL server Product can I Use and how much does Cost to buy is there a free down load or a trial please i need your help
10-20-2009, 08:53 AM
skhanal

You can download SQL Server Express from Microsoft, it is free.
10-20-2009, 09:27 AM
FMKA

1 Attachment(s)

Quote:

Originally Posted by skhanal

You can download SQL Server Express from Microsoft, it is free.

I did it but i do not find the functions have a look what i have
10-21-2009, 08:08 AM
skhanal

What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.

You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.
10-22-2009, 11:01 AM
FMKA

Quote:

Originally Posted by skhanal

What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.

You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.

Thanks, Bro but is not Available
10-27-2009, 06:32 PM
Island1

Functions can be Created within the Application, of Course ...

You can build your functions in MSSQL Server.

Did you examine the upsizing tools?

Bill
10-28-2009, 09:36 AM
FMKA

Quote:

Originally Posted by Island1

You can build your functions in MSSQL Server.

Did you examine the upsizing tools?

Bill

Bill

I selected sql management studio. what do you say ?
10-28-2009, 02:42 PM
rmiao

Sqlexpress doesn't have data imput tool, should use access' upsizing tool like Bill said.
10-30-2009, 11:18 AM
FMKA

Quote:

Originally Posted by rmiao

Sqlexpress doesn't have data imput tool, should use access' upsizing tool like Bill said.

What about SQL Server Import Export Wizard is not good
10-30-2009, 03:01 PM
rmiao

Not available on express I believe.
10-31-2009, 12:26 AM
FMKA

Quote:

Originally Posted by rmiao

Not available on express I believe.

is available I downloaded MS SQL Express 2008 the tool is there too that i am using

thanks
10-31-2009, 06:38 PM
rmiao

What's the issue then? You can use vb script in access to query sql tables.

All times are GMT -5. The time now is 02:58 AM.