access 2003 front-end with SQL server as the backend

[Lifeseeker]

Hi there,

I would like to upgrade my backend database to SQL server.

Right now, Access 2003 database is stored on my local hard drive(hasn't been split yet), but I would need to put the backend on the server so that everybody else can share the same application wherever they are.

The front-end is all built with forms and queries. The backend right now has all the fields and values in them.

I wonder how to interface to the new SQL backend. This is my 1st time doing this, and I appreciate any comment/feedback at all.

Thank you

 

[SmallTime]

Your going to need a couple of tools for this

1. Microsoft SQL Server Migration Assistant 2008 for Access
2. A version of SQL server, There is a free version called SQL Server Express.
3. An sql server management tool, SQL server management Studio is a good option.

Then you'll have to link the SQL server tables to your front end , Douge Steel has nice instructions for a DNS less link http://www.accessmvp.com/DJSteele/DSNLessLinks.html

Although after some adjustment the process is fairly, sort of, sometimes strait forward there's possible a lot of changes you'll have to make to the front end to get it working as before. Trust me, this isn't something for the faint hearted. Things like date formats have, for me a least, proven a major headache. I'm not trying to put you off but do be prepared for some hard work to get it rolling as you expect. It's worth it in the long run.

Give it whirl and see how it goes

SmallTime

 

[SmallTime]

Your going to need a couple of tools for this

1. Microsoft SQL Server Migration Assistant 2008 for Access
2. A version of SQL server, There is a free version call SQL Server Express.
3. An sql server management tool, SQL server management Studio is a good option.

Then you'l have to link the SQL server tables to your front end , Douge Steel has a nice instructions for a DNS less link http://www.accessmvp.com/DJSteele/DSNLessLinks.html

Although after mid of adjustment the process is fairly, sort of, sometimes strait forward there's possible a lot of changes you'll have to make to the front end to get it working as before. Trust me, this isn't something for the faint hearted. This like date formats have, for me a least, proven a major headache. I'm not trying to put off but do be prepared for some hard work to get it rolling as you expect. It's worth it in the long run.

Give it whirl and see how it goes

SmallTime