I am running access 2003 frontend with tables linked to sqlexpress 2005 backend. I upsized the data from access and all was great ran very well for some reason I now get login (Error: ) and when I access it from the server I can logon but it is really slow. I have been on this for two days any help here?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Frontend and SQL Backend (Slow Problem) 1
- Thread starter anon1971
- Start date
-
1
- Thread starter
- #2
Did you create indexes when you created the tables?
Also have you tried relinking the tables?
Incidentally I would not rely on the upsize wizard, it often chooses the wrong datatype. Data types are not exactly the same between the two and what Access must use memo for, SQL Server can handle with a varchar or nvarchar field. If it converted to ntext or text, you need to change that immediately as those data types are being phased out.
"NOTHING is more important in a database than integrity." ESquared
Also have you tried relinking the tables?
Incidentally I would not rely on the upsize wizard, it often chooses the wrong datatype. Data types are not exactly the same between the two and what Access must use memo for, SQL Server can handle with a varchar or nvarchar field. If it converted to ntext or text, you need to change that immediately as those data types are being phased out.
"NOTHING is more important in a database than integrity." ESquared
- Thread starter
- #4
Yeah I went threw and made sure they were working correctly when I first did the upsize and all was well until I tried to upgrade to 2008 then uninstalled everything reinstalled 2005 express and I think that is when it started being really slow but its not slow on our web base front-end just access front-end. Could it be the certificates sql creates
Express is SLOW!!!
Try to install other version of SQL Server.
Express is limited to use only 1 GB RAM and it is VEEERY slow.
A query that usually takes less than a second on SQL Server Standard edition on express takes almost 10 seconds.
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Try to install other version of SQL Server.
Express is limited to use only 1 GB RAM and it is VEEERY slow.
A query that usually takes less than a second on SQL Server Standard edition on express takes almost 10 seconds.
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
- Thread starter
- #6
- Thread starter
- #7
I said that the Express can use only 1 GB of RAM not the DB, DB is limited to 4 GB 
Also what you use to connect to Server?
Make sure you have the lates version of SQL Native Client and use it, not standard driver that comes with Windows (SQL Server)
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Also what you use to connect to Server?
Make sure you have the lates version of SQL Native Client and use it, not standard driver that comes with Windows (SQL Server)
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
- Thread starter
- #9
I have got to be the biggest idiot on this planet. Please check this if you have linked table issues running really really slow before you check anything else:::
I went to ODBC Data Source Administrator clicked on the Tracing Tab and low in behold there was a trace running I stopped the trace and it is like lighting.
I went to ODBC Data Source Administrator clicked on the Tracing Tab and low in behold there was a trace running I stopped the trace and it is like lighting.
KirbyWallace
Programmer
Wow. I don't think ANYONE would have guessed to look there, at least not until they were way down the "desperation/grasping at straws" road.
Good for you!
Good for you!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
