access to sql server express connection

[grahamsyuk]

Hi guys, im new to Access and SQL server. Im trying to connect to SQL server express on my own PC but im not having any luck. Is there any documentation anywhere that will explain what i need to do? any help would be much appreciated

 

[shadow9449]

Hi guys, im new to Access and SQL server. Im trying to connect to SQL server express on my own PC but im not having any luck. Is there any documentation anywhere that will explain what i need to do? any help would be much appreciated

You didn't really describe what you are trying to do or what the problem is. I will point out that SQL Server Express comes with a setting not to allow outside connections. You need to use the SQL Server Surface Area Configuraton to change that.

SHADOW

 

[grahamsyuk]

sql server express and access front end

Hi sorry for not explaining myself. I have a test database created using SQL server express on my own PC. This is my first time using it. I also have access 2002 running on my PC. i wish to connect access to the SQL server database and create a front end GUI for the database. Is there a step by step guide on how to do this connection? I have tried various ways to do this and each gives me errors. im not even sure if i am doing it correctly.

 

[shadow9449]

Hi sorry for not explaining myself. I have a test database created using SQL server express on my own PC. This is my first time using it. I also have access 2002 running on my PC. i wish to connect access to the SQL server database and create a front end GUI for the database. Is there a step by step guide on how to do this connection? I have tried various ways to do this and each gives me errors. im not even sure if i am doing it correctly.

Without knowing what errors you are getting, it's hard to give specific advice. In general, make sure your database is set to accept connections as I mentioned in the previous post, and then link the tables. There's a number of ways to do this, so make sure you have read enough on the topic to determine what approach is best for you.

SHADOW

 

[AngelsGuardian]

Comon.. the guy ask for something simple... how to connect to a SQL Server database with Access ... he doesnt want to know where he failed in his previous attempt to connect... just.. HOW to connect to a SQL Server.

I would also like to know the ways to do it.

So now i am asking ... How do i connect my ACCESS Front-End to a SQL Server without using the upgrade wizard.

Thanks

 

[AngelsGuardian]

BTW grahamsyuk

In the table window of ACCESS, right-click and do a "link tables..."
Choose the "ODBC Database" , it will give you a pop-up asking for database source.
From there.. just folow instruction.. i was able to connect in 20 min utes after few try and error.

Keep trying man !