June 2, 2004 at 9:04 pm
HAI GUYS.....
i have done a project by using VB 6.0 as frontend and SQL Server as backend. most of the quries in this project is written as stored procedures , and it is working in a good condition.
Now i have to do the same project for another company, since they are using only the orginal copies of the software theydon't have the SQL Server on their systems. so i have to convert the backend from SQL server to Access.
Is there any options avilaible for me to convert the stored procedure in the SQL into access ?
or can i use stored procedure in access with vb,if yes how? explain with an small example...
since i'm a new one in this programming area....hope u all will help me to complete my vision...
thanking u....
June 3, 2004 at 1:12 am
Why not use MSDE? There is an installation folder somewhere on the MS Office2000 CD.
This way you wouldn't have to butcher your existing code.
I've found that MS Access (running the Jet DBEngine) is fine for allowing multiple users to read the database, but absolute pants when writing information. Expect the database to hang at least once a day if you are doing writes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply