If you have a DNS issue most of the time it will result in a timeout so you won't be able to connect at all. However you can avoid that...

Make sure that your DSN uses the Microsoft SQL Server 2008 Native Client for the data provider, and that it is installed on both the server & the client PC.

There can be a lot of trial-and-error involved in reverse engineering a database. I ran into a similar problem, trying to push customer data from a membership app into Microsoft...

That of course is a ridiculous example.

Bye-bye

Matt

Here is function using regular expressions to find & replace the first occurrence of CREATE...PROC seems to work in my testing. . .

Function create_to_alter(Text As String) As String

...

Matt, I have been here in the forums for the past six years to help others. There is no need to make ignorant comments. That being said,

Matt Whitfield (9/26/2009)

---

I'm quite...

You can use optional parameters to ensure that only the very first CREATE PROC is changed:

sql = Replace(sql, "CREATE PROC", "ALTER PROC", 1, 1)

which tells VB to start at the...

Terri-92562 (4/2/2009)

---

I am using DMO and vb6 to script my database. It gives me create scripts. I would like to generate ALTER scripts for the stored procedures. ...

You need to burn the ISO image file to a DVD and then use that to install.

Head over to http://bwgburn.sourceforge.net/ and download the free BwgBurn CD/DVD Burning Software,...

Chris,

If all 3 tables are in the back-end then you could create a stored procedure & create a pass-thru query to execute that from Access, that would be much faster....

Here's another idea.

We have production, QA, test, and DEV databases on different servers & the front-end can be connected using either Windows or SQL authentication. On the opening screen of...

As I understood the OP, he has written an Access application that uses linked SQL Server tables.

Now, he is creating a setup program & is using RegisterDatabase to create a...

Is tests to see if the table or query has a connection string. If the table is a linked table or the query is a SQL pass-thru query, the existing...

If all your tables / queries connect to a SQL Server database, you could run this from an AutoExec macro before you attempt any data access from the server:

Function SQL_RelinkDatabase()

...

If you're really stuck, I would suggest starting over with the SSMA which makes things much simpler. Just Google for

"SQL Server Migration Assistant 2005 for Access V4.0"

which is the updated...