Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
epilotusa
Starting Member
4 Posts |
 Posted - 2011-07-24 : 03:50:41
|
| Hi Everyone,We currently have a fairly large Access DB and would like to move it to SQL. We would also like to make our software web accessible and eliminate the need to use MS Access all together.Our existing DB has:20 tables40 forms70 reports Any tips how to proceed my situations and appreciated.thank youepilotusa, |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
epilotusa
Starting Member
4 Posts |
Posted - 2011-07-25 : 03:35:41
|
| Hi khtan,Is there a way I can converted Access database to SQL Server? It is possible to make it view on web site?My existing DB has:20 tables40 forms70 reports |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-07-25 : 04:35:56
|
Please refer to the link that i posted
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
epilotusa
Starting Member
4 Posts |
Posted - 2011-07-28 : 02:13:23
|
| Hi KH,I used your "refer link" that understand the process Upsizing Wizard converted data work. But the downsize it not mention about how to converting the "forms" and "reports". These two are very important parts of information need to have in for the company.Thank youepilot |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-07-28 : 02:26:15
|
SQL Server does not have equivalent of "forms" & "reports" of Ms Access. For those you have to replace with other front end tools like ASP etc.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
epilotusa
Starting Member
4 Posts |
Posted - 2011-07-28 : 11:54:45
|
| Hi KH,Will ASP easy to develop for front end UI?thank youepilot, |
|
|
|
|
|
|
|
|
Move MS Access data to SQL Server???