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 |
|
makbd
Starting Member
1 Post |
 Posted - 2004-05-25 : 09:12:39
|
| Hi,I have an application developed in MS Acess . I need to use SQL server now as my back end. How can I use existing form of Access when I change my back end?How to use SQL server with MS Access formthanks in advancekashem |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-05-25 : 11:04:44
|
| Yes, But you will have to recreate your Query’s in SQL format. JimUsers <> Logic |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-05-25 : 20:00:40
|
| Kashem, Access has an up-sizing wizard that you can use for this. You don't necesarily need to modifiy your queries, as Access does the query processing locally. I think Jim may be referring to using Access Data Projects, which require SQL-Server compliant statements. If you have the time, an ADP will offer better performance and maintainability than the standard Access database (MDB). Tim |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-25 : 20:43:36
|
| When you use the upsize wizard, you might want to consider doing it in two phases. One, move the tables to another access file and upgrade it. Two, begin the migration process of your procs and begin modifying your forms to use vba and ADP.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
connecting sql server