We are trying to convert VBA functions to SQL Server, ideas plse?

[Joe Francis]

We are trying to see if there is a quick way to convert an MDE program using
an MDB database to SQL Server?
Does it need a lot of code work to recognize the VBA functions as SQL
functions - know there is a converter.
Can we change it so that the MDE is made to recognize SQL functions instead
of VBA?

Is this the correct conversion process?

Any help would be much appreciated.

Regards,

 

[Douglas J. Steele]

You can't change anything about an MDE: you'll need the MDB that was used to
create the MDE.

 

[Rick Brandt]

We are trying to see if there is a quick way to convert an MDE
program using an MDB database to SQL Server?
Does it need a lot of code work to recognize the VBA functions as SQL
functions - know there is a converter.
Can we change it so that the MDE is made to recognize SQL functions
instead of VBA?

Is this the correct conversion process?

Any help would be much appreciated.

Regards,

You can for starters just change you jet tables to links to the SQL Server
tabels and keep all of your queries and VBA code as it is. You might find
that it works pretty well like that. There will probably be a few areas
where moving to views or stored procedures on the server will help
perfomance, but you will be surprised how few of your existing queries will
need to change at all.