David,

I've had that problem before when stress testing Access - the number/pool of ports open had to be increased and also the timeout lenght changed so that they would become...

Lester,

If all your tables are linked to the Access Front-end then the following routine will delete all transactions.

Function ZapTables()

On Error Resume Next   ' Gets over invalid table name ie Currency

Dim...

Paul,

Regsvr32 registers the .dll file on the computer and makes it available in the references section of the Access file.

However - you wont have SQL on every machine.  Sorry if...

Paul,

Try Coping the file SQLDMO.dll to C:\windows\system32

Then you need to register the file:

Start Run      Regsvr32 c:\windows\system32\sqldmo.dll

It should then appear in the list of references.

Richard

Why not create a view in SQL and link that as a table - it has the speed and power of SQL. Treat the View/Query as any other table object.

Having linked the Tables as above they are prefixed with dbo. unlike your other linked access tables.

I use the following to remove the dbo. and also the other function to...

The query was using NZ() function but in an Access Query - was probably the cause.

I'll be more careful of its use in future - thanks for the pointer.

Richie

Thanks Martin - I'll forgive the kludge

Richard

Finally solved the problem.  I had renamed a field in a table from "USER" to "USERNAME" because of reserved words.  A connected query in my forms held the original name...

Thanks Martin,

Sounds like you 've been down the same road.  I hadn't thought of the form objects themselves so thats a fresh idea and also just copying to clipboard and...

Thanks Jo

I've tried all that - still the same answer.

My next option is to copy out all the code modules to text files, set the form property to No Module ,...

C R

WHat exact changes need to be made to switch servers ?

Richard

I tried the Upsizing tool and found it troublesome.

I use DTS Import Wizard to get my databases into SQL from Access and then use EM to develop the scripts as...

Hi,

I use the following functions to refresh my links between Access and SQL.

The removeDBO allows my access programs to operate with either original Access tables or linked tables in SQL...

Ryan,

I found an interesting article by Danny Lesandrini on this topic at:

http://www.databasejournal.com/features/msaccess/article.php/3407531

His last paragraph provides a magically simple solution to calling stored procedures.

Richard