Slow connection to Access 2007

[DerWol]

created an app in visual studio, that uses a sql2005express database to
store a lot of text. The sql-server is located on a machine in a domain,
access, editing, and everything else works fine. After exporting this
database to MSAccess 2007 (and changing the connection properties in the
designer of visual studio), the app became very slow when acessing is. The
difference to toversion with sql2005express is, that the database now is
located on a network store harddisk, which is connected by permissions. By
the way, the database is also encrypted. Can anyone help me with this issues?

 

[Sylvain Lafontaine]

First, this newsgroup is about ADP and SQL-Server and the relation between
these two products and has nothing to do with MDB or ACCDB database files or
with ODBC Linked tables or with Visual Studio (Classic or .NET). While
you're always welcome to post here on whatever subject, you can eliminate a
good part of bad luck by posting to a more relevant newsgroup.

Second, to come back to your post, I have trouble understanding what you
mean exactly with « Exporting your database to MS-Access 2007 ». Do you
mean that an Access MDB or ACCDB database file is now replacing the
SQL-Server Express as the backend for the data or is it that you have linked
a MDB or ACCDB database file to the tables on the SQL-Server Backend?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Sylvain Lafontaine]

First, this newsgroup is about ADP and SQL-Server and the relation between
these two products and has nothing to do with MDB or ACCDB database files or
with ODBC Linked tables or with Visual Studio (Classic or .NET). While
you're always welcome to post here on whatever subject, you can eliminate a
good part of bad luck by posting to a more relevant newsgroup.

Second, to come back to your post, I have trouble understanding what you
mean exactly with « Exporting your database to MS-Access 2007 ». Do you
mean that an Access MDB or ACCDB database file is now replacing the
SQL-Server Express as the backend for the data or is it that you have linked
a MDB or ACCDB database file to the tables on the SQL-Server Backend?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)