One thing to consider is whether the VBA code is causing updating of the front-end UI. If it is then with using triggers it will be difficult to duplicate...

You might want to start from the beginning again.

1. Open a report and check the Record Source for the report. You can see the query it references by clicking...

In the Enterprise Manager you have to go in to the Data Transformation Services node and then look in the Local Packages node. If you open up a DTS...

Have you looked for SQL Server DTS jobs that export the information to Access?

Before calling this a bad design you need to consider the functionality the software is providing. If the software allows the users to define the field names and format...

.

You will probably have to use a SQL Query statement that SELECTS the fields you want from the source view.

Delete the Access LINK to that table. You can do this by selecting the table in the tables list in Access and pressing the Delete key. It should...

It may have to do with refreshing the links to the database so it gets all of the current info about the tables and indexes. Creating a new query...

You can save quite a bit of space even without R2 compression. Set the folder where you backups are going as compressed. Then any file put in there...

I wrote an article on a job information report http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/68318/ a while back. You might find it or at least the queries in it helpful.

If you use the MS Access Upsizing Wizard in Access or the Migration wizard mentioned above they both work the same way. They "convert" your tables to SQL Server...

Eric Mamet (4/18/2010)

---

That's interesting because I kind of removed the primary key from one of the tables to make sure it could not do an update on it without...

There are probably at least two reasons that you can't access it remotely. First off MSDE and SQL Express don't allow remote connections by default. Secondly TCP/IP is...

is250sp (3/4/2010)

---

That is controlled by the link to the table. The information about how the link is done is stored in the access application and not on individual PC's....