IMPORTING STORED PROCEDURES TO AN SPLIT DATABASE (FRONT/BACK END)

[stocto]

I have an application developed in Access , the database is in SQL, I split the database manually ( i couldnt find the library where the required wizard was) i have now a front end database and a back end database, I imported everything but the Stored procedures, When i go to the option :
File
Get External Data
Import
there is a tab option for Tables, Forms, Reports, Pages, Macros, Modules, but there is not a Tab for importing Stored Procedures.
Any idea how can i import into the new database the stored procedures of the original database?

 

[rr191]

I believe the stored procedures will show up once you relink to the SQL database. Do you have access to the SQL database?

 

[PWise]

is this database this a .mdb or a .adp?

if this is a .adp refreshing the connection should bring the stored procedures, but if this is a .mdb you cannnot view the stored procedures.

however you can run the stored procedures as a passthru query