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?
Thanks
7  4373  NeoPa 32,568
Recognized Expert Moderator MVP
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.
NeoPa 32,568
Recognized Expert Moderator MVP
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)?
 Delerna 1,134
Recognized Expert Top Contributor
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.
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
Delerna 1,134
Recognized Expert Top Contributor
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
NeoPa 32,568
Recognized Expert Moderator MVP @vanlanjl
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).
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.
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 nor tutorial, "Access Cookbook,
Second Edition" (O'Reilly, US $49.95), by Ken Getz, Paul Litwin, and
Andy Baron, delivers hundreds of practical examples, up-to-date
suggestions, and handy solutions to real-world problems that Access users
and...
|
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 now!). The
application publisher went belly up years ago. Over time we've made a
number of VBA code changes (< 500 lines total). Now our CPA is urging
us to switch to Quickbooks Premier for Contractors at a cost of $,$$$
plus data entry. Argh, no...
|
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>
<HEAD/>
<BODY>
|
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 incompatibilities between Access
2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying
with Access 2000 be better?
Thanks!
Neil
|
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?????
</Jon Stewart>
| | |
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 (ms access) and put all of the tables onto
a SQL Server 2005 BE, and yet make those databases accessible to open/view
through Ms Sharepoint.
What is the simple (properties) way to grab all of those db's = 20 and upload
to server?
|
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 every user face, we should be able to use the
same FE in as before as now on Sharepoint?
ANSWER:
|
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 team and I can simply log on to check things in real time and edit forms in real time. Right now the access database is on my computer and nobody else has access to it.
would the actual share point server accomplish this? becuase as of right now...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
