Ms Access Error 3423
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 18:50:49 GMT by s_wx1085 (squid/3.5.20)
Unanswered Topics Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access DAO Run Time Error 3423 - VB6 to Access2000 User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-2007-odbc-db7-error-3423/7886ae4f-8a8e-48c6-a36b-39c7de1912ef guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) September 25th, 2003, 12:56 AM Iblys Registered User Join Date: Sep 2003 Location: , , . Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts DAO Run http://p2p.wrox.com/access/4261-dao-run-time-error-3423-vb6-access2000.html Time Error 3423 - VB6 to Access2000 Hi all, this is my first post. I am very frustrated with Microsoft Visual Studio 6 - Visual Basic, I am trying to use DAO to talk to a database that was created with Access 2000 and am having no luck. I have the latest service packs for Office and for Visual Basic and Jet and everything like that, but the code still isn't working. The database file has a system DSN of "lsdata" and I have tried referring to it using both the DSN and the full path. Basically what I'm trying to do is to open the database using ODBC so that I can change the structure of it using DAO. I was able to get it to work using SQL but I need more control (you can't add autonumber fields using SQL). Here is the code: 'First I do this Dim TheDatabaseThingy as Database 'And I have tried both of these Set TheDataBaseThingy = OpenDatabase("lsdata", dbDriverCompleteRequired, False, "ODBC;UID=;PWD=;DSN=lsdata") 'or Set TheDataBaseThingy = OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\Connexions Project\Connexions Databases\50.mdb", False, False, "ODBC;DSN=lsdata") Both "Set" statements return run time error 3423 which has me greatly puzzled. We have tried exporting it as an earlier version of access, and then we got error 3170. I am tearing my hair out, any help would be appreciated. #2 (permalink) September 25th, 2003, 09:31 PM Bob Bede
GoogleВойтиСкрытые поляПоиск групп или сообщений
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Visual Basic(Microsoft) Databases Forum at Tek-Tips HomeForumsProgrammersLanguagesVisual Basic(Microsoft) Databases Forum DAO error when talking to Access 2000 db thread709-663730 Forum Search FAQs Links MVPs DAO error when talking to Access 2000 db DAO error when talking to Access 2000 db Iblys (Programmer) (OP) 25 Sep 03 02:06 Hi all, this is my first post. I am very frustrated with Microsoft Visual Studio 6 - Visual Basic, I am trying to use DAO to talk to a database that was created with Access 2000 and am having no luck. I have the latest service packs for Office and for Visual Basic and Jet and everything like that, but the code still isn't working.The database file has a system DSN of "lsdata" and I have tried referring to it using both the DSN and the full path.Basically what I'm trying to do is to open the database using ODBC so that I can change the structure of it using DAO. I was able to get it to work using SQL but I need more control (you can't add autonumber fields using SQL).Here is the code:'First I do thisDim TheDatabaseThingy as Database'And I have tried both of theseSet TheDataBaseThingy = OpenDatabase("lsdata", dbDriverCompleteRequired, False, "ODBC;UID=;PWD=;DSN=lsdata")'orSet TheDataBaseThingy = OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\Connexions Project\Connexions Databases\50.mdb", False, False, "ODBC;DSN=lsdata")Both "Set" statements return run time error 3423 which has me greatly puzzled. We have tried exporting it as an earlier version of access, and then we got error 3170.I am tearing my hair out, any help would be appreciated. RE: DAO error when talking to Access 2000 db CCLINT (Programmer) 25 Sep 03 03:36 Why use ODBC for JET?This is not as effective (limitations) as u