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 |
|
tacket
Starting Member
47 Posts |
 Posted - 2007-12-03 : 17:06:40
|
| Hi,I have a lot of questions on what are the best methods to convert access database to point to SQL server. I have already succesfully created an access project pointing to a SQL backend-db. I also was able to "copy" all the existing forms/reports/macros over from the old project into the new one. However, most of the buttons don't work. I usually get a "Error accessing file. Nework connection may have been lost" error. I then go and try and view the Visual Basic code and it won't let me make any changes. I'm wondering if that's because when I copied the old files over it's still pointing there or something.I'm kind of new to Access, so I have no idea if this was the best way to point a project to SQL. I would like to not have to redesign all these forms and reports from scratch. If any body has a nice proven way to switch the back-end to SQL I would appreciate any help.Thanks,Phil |
|
|
Bit Wrangler
Starting Member
9 Posts |
Posted - 2007-12-05 : 08:30:42
|
| You might try looking into the Upsizing Wizard: http://support.microsoft.com/kb/325017 |
 |
|
|
|
|
|
convert 2000 access backend to SQL 2005