Do not underestimate the amount of effort to convert an Access app to the .NET platform. In my experience, this can easily cost $100K US and take 6 months or...

Something that might have initially discouraged people from the new certs:

"In our initial communications about the Professional Series certifications, we announced that a "refresh" or recertification of the MCITP and...

Lynn Pettis (5/8/2008)

---

I am curious, however, would we be having this same discussion if the physical names of master, model, msdb, and tempdb were sqlmaster, sqlmodel, sqlmsdb, sqltempdb but were...

I agree that Resource is a system database with the physical name mssqlsystemresource.mdf, in the sense that the system uses it. But I can also see a physical file named...

I've used the SQL Server Migration Assistant (SSMA) and it works very well. But if the Access tables and relationships are substantially different from your SQL database, or if the...

Hurray! I found a job, full-time, permanent, with a good salary.

I can highly recommend Ed at the MDI Group, he works with Access, SQL, Oracle, Java, .NET, Business Analysts, etc....

I posted the code at my web site, the Forms version (shown above) is at

http://www.wvmitchell.com/tips/GetDataSources_Forms.htm

and the Reports version is at

http://www.wvmitchell.com/tips/GetDataSources_Reports.htm

Yes, this is VBA. Create a new standard module in Access:

From the database window, select Modules and then click New

And then paste this code in, and place your cursor anywhere...

You could loop through all the objects and build a table with that info. Here is an example how to do the forms; the reports would be similar:

Sub GetDataSources_Forms()

...

The biggest challenge will be with the images - they are usually stored in sub-folders on the web server. In some cases they are hosted on another domain like akamai.

If...

I agree, the worst questions generate the best discussions.

BTW that Express trace flag was originally undocumented, until the msdn article was updated 14 April 2006.

I was assuming that Access was just going to be an additional layer in-between the VB app and SQL Server. If the VB app uses ADO then just changing the...

Matt,

The OP was going to connect from VB6 thru Access to SQL Server, and I don't think that AutoExec would run in that scenario.

Quoting from the msdn article...

"the DAC exists solely for diagnosing server problems in rare circumstances"

"To conserve resources, SQL Server 2005 Express Edition does not listen on the DAC port unless...

Maintenance problem:

In Access, when you create a link to an ODBC data source, Access will memorize the schema of the underlying table. If you make a change to the table,...