472,363 Members | 2,074 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,363 software developers and data experts.

Access to SQL Server Express with web/sharepoint interface

Okay this is a general question.

I have an Access 2007 databse and am wanting to push it to sql server 2008 with either a web interface or sharepoint interface.

How would I go about doing this.

I have Acess 2007, Visual Studio Pro 2008, Sql Server 2008 and Microsoft Expression, and Sharepoint.

I do not know alot about thses apps except Access 2007, so I know there will be alot of learning for me, but was wondering if anyone had done this, and how to start?
Apr 30 '09 #1
7 4235
32,511 Expert Mod 16PB
I'm not sure many of the members here (Access forum specifically) will know much about the non-Access areas either Vanlanjl.

You're welcome to leave it here in case, but I can move it to the HTML/CSS forum instead if you prefer.

Alternatively, post a thread in there which has a link to this one, but ask that any answers are posted in just this thread. If you choose to do that, then you can let me know about it and I will lock it for you, to keep any and all responses tidily in the one place.

Good luck anyway.
Apr 30 '09 #2
32,511 Expert Mod 16PB
As a matter of curiosity, have you stopped using your other account now (It's not a serious problem but we don't encourage members to use more than one account)?
May 1 '09 #3
1,134 Expert 1GB
I use SQLServer 2000 (progressing towards 2008) as well as DB2 as data backends for webpage frontends.

If you don't know much about visual studio then you could be a long time learning to use it before you can even begin to start writing database apps.

Where to start depends on what you know?

1) You can pull tables and their data from access into SQL server in "SQL server enterprise manager". Look in the help files for "Importing data". Its not hard once you have done it a couple of times

2) If you already know HTML and either jScript or vbScript (other scripting languages also) then you might get results faster using something simpler than visual studio, like notepad++ (or even notepad) to write html web pages that connect to SQL server, retrieve and display data, insert records, update records, delete records etc. ASP is a more secure way of accessing databases than ordinary HTML

While doing that you could get yourself familiar enough with visual studio to begin taking over the development of your web front ends from notepad++. What you learn using notepad should help you when learning to do it with visual studio

I hope that is in line with your question and it helps.
If you have any specific questions then we are here to help.
What you want to do spans several topics so think about your question and ask it in the forum that covers that topic.
May 1 '09 #4
Yea, I wasn't sure which topic to ask it in. I am most fammilar with Access and with this Access forum, and its users. I have little knowledge in Visual studio, but have Visula Studio 2008 and enjoy the tutorials in it very much. I also have a little sql experiance. I have succesfully installed SQL Server 2008, and have succesfully migrated the Access tables into SQL. Form that point I am not sure what to do.

If you feel my post is in the wrong area, I understand and woulod not be at all offended if it was moved to one that you (NeoPa), as a admin, is feel more appropiate.

Thanks for all your help
May 4 '09 #5
1,134 Expert 1GB
Youre welcome.
Something I didn't mention and should have!
If you dont have much experience with HTML and scripts then you might as well jump straight into visual studio. Especially since you enjoyed its tutorials.

Are there any database tutorials amongst them?
If not microsoft have many video tutorials for developing with
the express edition of visual studio. There are database tutorials there.
Google "Visual studio express" and you should find them
May 4 '09 #6
32,511 Expert Mod 16PB
Not really. My only reservation is how much expert help you'll get here.

Any time you want it moved, or even another posted in a different forum, just let me know and I'll either A) move it or B) lock it so the answers do not get split up (depending on which option you've chosen to use).
May 5 '09 #7
What i have done so far is:
I have imported my Access tables and queries to SQL Server Express
I have connected my Sql Server Express Database to Visual Studio Pro 2008
I have created a aspx page conected my tblContacts to it and createda basicsearch parameter.

What I would like to do is re-create my Access Forms and Reports in Visual Studio for web access.
May 5 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
by: Matt Alanzo | last post by:
Our SOHO 2 person compay sells furniture (not programmers). In '98 we paid $,$$$ for a VBA -Access '97 accounting application, including VBA source code .... an huge investment for us then (and...
by: DMc2005 | last post by:
Hi All I have a big problem, I am always getting an error message when I browse a ASP page I created with Dreamweaver MX, the page is supposed to use VBScript, the page consists of: <HTML>...
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some...
by: David W. Fenton | last post by:
I just read the latest post on the Access 12 Blog: Tracking Application Overview http://blogs.msdn.com/access/archive/2006/02/06/525888.aspx and just have to say: <Jon Stewart> Whuh?????...
by: Bob Alston | last post by:
Anyone know of any features of the new Access 2007 that will improve on the ability of Access to work in a web environment??? Bob
by: Anns via SQLMonster.com | last post by:
I have about 20 Ms Access Databases to need to be upload onto a SQL Server 2005. Currently the are on a network/server residing on a specific drive. The goal is to keep the user face the same...
by: Anns via AccessMonster.com | last post by:
My establishment has about 20 ms access db's that will be converted over (see subject). When we pull all the BE's over to SQL and the FE's on Sharepoint (.net) surely we don't have to change...
by: mbatestblrock | last post by:
So I have been reading up on this, and I could sure use some advice... I have sharepoint services 3.0 running on a server... I have a database I would like to be accessed via Web interface so my...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.