Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Diya
Starting Member
11 Posts |
 Posted - 2010-05-07 : 23:24:16
|
| Hi, everybody,I have created a mdb file using MS Access 2003. After splitting this, the back end containing tables only has been migrated to sql server database (2005 express edition)using SSMAforAccess2005. The front end containing queries and forms is remained in the mdb file. In this situation is it possible to create an exe file for this? If its possible, please let me know.Early response will be appreciated.with regards,diya |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-05-12 : 02:33:25
|
| sure. you can use the mdb file connected with front end. But you have to transfer the data from the mdb file to SQL server db periodically. we are doing this in two ways. first through an exe file created using VB. second through a stored procedure.Regards,Sathieshkumar. R |
 |
|
|
Diya
Starting Member
11 Posts |
Posted - 2010-06-05 : 10:34:19
|
| Hi,I am so grateful for your answer. Just I want to know how can I creat that exe file.Please help me.With regards,diya |
|
|
|
bravo
Starting Member
7 Posts |
Posted - 2010-06-24 : 16:11:20
|
| Hi,yeah only these methods are there, you have to transfer the data from the mdb file to SQL server db periodically. we are doing this in two ways. first through an exe file created using VB. second through a stored procedure.Nice Forum |
|
|
|
|
|
|
Exe file