scotthutchings
Registered User.
- Local time
- Yesterday, 16:52
- Joined
- Mar 26, 2010
- Messages
- 96
I am not sure where to go next...
Over the past year I have developed an Access FE/BE database that has exceeded the original design and scope. As a result, it has slowed dramatically. When it is run on a local machine, it works great. When it is run over a LAN, it works but several of the forms and reports run way too slowly. When is it run over a WAN, it essentially doesn't work anymore (unless you have 20-30 minutes for each step).
Here's what I have done: I have successfully installed MSSQL Express 2008R2 on the server and have connected successfully. I have tried to use the SSMA tool to migrate my BE Database to SQL. This seems to work but I don't know how to use the BE (how do I link my FE to it and how do I get my queries in the FE into SQL?) I have also tried to combine my FE/BE into a single database before I migrate it, which appears to work, but the front end doesn't run.
I am not sure even where to turn... Essentially I need some step by step help understanding how to migrate my database and how do I use the migrated database. I would love to find someone with experience in SQL/Access to help me.
Does anyone have any idea where I go next?
Over the past year I have developed an Access FE/BE database that has exceeded the original design and scope. As a result, it has slowed dramatically. When it is run on a local machine, it works great. When it is run over a LAN, it works but several of the forms and reports run way too slowly. When is it run over a WAN, it essentially doesn't work anymore (unless you have 20-30 minutes for each step).
Here's what I have done: I have successfully installed MSSQL Express 2008R2 on the server and have connected successfully. I have tried to use the SSMA tool to migrate my BE Database to SQL. This seems to work but I don't know how to use the BE (how do I link my FE to it and how do I get my queries in the FE into SQL?) I have also tried to combine my FE/BE into a single database before I migrate it, which appears to work, but the front end doesn't run.
I am not sure even where to turn... Essentially I need some step by step help understanding how to migrate my database and how do I use the migrated database. I would love to find someone with experience in SQL/Access to help me.
Does anyone have any idea where I go next?