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 |
|
mym21
Starting Member
10 Posts |
 Posted - 2003-03-06 : 09:06:14
|
| HiI have a new project to do with VB and MSDE. I really don't know how to begin with MSDE. It's installed but except that...I don't know anything else. However, I know how to code in vb. I usually take access database, but now I have to use MSDE. Maybe you could give me some site or example how to connect my database and to be able to transfer some data. Also, I began my project with Access and they decide to change for MSDE. Will the code that I already did lost? Or is it possible to do recordset as with Access?Thanks in advance guysMyriam |
|
|
precept
Starting Member
5 Posts |
Posted - 2003-03-06 : 10:20:23
|
| MSDE fully functional SQL Server compatabile DBASE......yes you can return recordsets....to connect just need to modify your connection string that you used with access...just like connecting to SQL server .....go to MS website will get more information from there....Anyway VB has many objects that build the connection string to automatically adodc |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-06 : 12:50:49
|
| If you were using JET (DAO) to connect and work in Access, you will no longer be able to use that. MSDE will work with ADO. There are small quirks that differentiate MSDE, which is basically SQL Server, and Access in the way data is handled, but you won't notice it at first. To kick-start you:Access MSDETable TableQuery ViewReport N/AForm N/AN/A Stored ProcedureN/A RuleN/A User Defined TypeN/A User Defined Function (MSDE 2000 only)Module N/AAnother tip: Get Books On Line. You may think it's only for SQL Server, but keep in mind that MSDE is SQL Server, and most of the information there applies to MSDE equally.Sarah Berger MCSD |
|
|
|
|
|
|
VB with MSDE