Can't connect into Access database file
|
|
 Feb 12 2006, 03:47 PM, updated 20y ago
Show posts by this member only | Post
#1
|
 
Junior Member
286 posts Joined: Jan 2003 From: Subang Jaya  
|
I have a weird problem here. I'm using VB6 to connect to an Access database file. Whenever i try to connect my VB6 project to an Access 2002 database file, it can't recognized it. But when i connect it to an Access 97 database file, it works without any problems.
Any reason about this? |
|
|
|
|
|
Feb 12 2006, 04:08 PM
Show posts by this member only | Post
#2
|
Senior Member
1,637 posts Joined: Jan 2003 From: Munich , Bangkok, Barcelona , KualaLumpur
|
vb6 only can connect to access 97 ..
perhaps other can ... if there is pathces |
|
|
Feb 12 2006, 04:48 PM
Show posts by this member only | Post
#3
|
|
Junior Member
286 posts Joined: Jan 2003 From: Subang Jaya
|
Oh..ic. So, i guess VB.net can connect to Access 2000 and above la.
What's pathces? |
|
|
Feb 12 2006, 09:18 PM
Show posts by this member only | Post
#4
|
Senior Member
1,490 posts Joined: Sep 2004 
|
QUOTE(PrinceHamsap @ Feb 12 2006, 04:08 PM) vb6 only can connect to access 97 .. no la...vb can connect to any database as long u have a proper database driver for the connection string..perhaps other can ... if there is pathces  i think in this case, there is a problem with ur connection string or database driver. |
|
|
Feb 12 2006, 09:23 PM
Show posts by this member only | Post
#5
|
|
Validating
297 posts Joined: Jan 2003
|
QUOTE(Seventh7 @ Feb 12 2006, 09:18 PM) no la...vb can connect to any database as long u have a proper database driver for the connection string.. yea, what he said.i think in this case, there is a problem with ur connection string or database driver. |
|
|
Feb 12 2006, 09:42 PM
Show posts by this member only | Post
#6
|
Senior Member
1,245 posts Joined: Oct 2004 From: Selangor
|
yeah... need to use the correct jet driver...
i use vb6 to connect to access 2003 w/o prob... |
|
|
|
|
|
Feb 13 2006, 12:38 AM
Show posts by this member only | Post
#7
|
|
Junior Member
286 posts Joined: Jan 2003 From: Subang Jaya
|
QUOTE(EpsilonStar @ Feb 12 2006, 09:42 PM) yeah... need to use the correct jet driver... If that's the case, then what's the correct jet driver that u use? Can you recall the specific driver?i use vb6 to connect to access 2003 w/o prob... |
|
|
Feb 13 2006, 09:46 AM
Show posts by this member only | Post
#8
|
|
Senior Member
1,490 posts Joined: Sep 2004
|
if im not mistaken use jet 4
|
|
|
Feb 13 2006, 11:04 AM
Show posts by this member only | Post
#9
|
|
Senior Member
1,245 posts Joined: Oct 2004 From: Selangor
|
^ yeah i went check just now, it's Jet version 4....
ver 3.5 is older version of office... |
|
|
Feb 14 2006, 12:04 AM
|
|
Junior Member
286 posts Joined: Jan 2003 From: Subang Jaya
|
Yes, guys. I just tried out the driver that u mentioned n it work.
 Thanks for the help.  |
|
|
Feb 16 2006, 05:15 PM
|
|
Junior Member
160 posts Joined: Jun 2005
|
may I ask... VB with access db... can I make the access db become server style?? Means that one pc is become db store and other pc can access the db.
Thank you very much... |
|
|
Feb 16 2006, 05:26 PM
|
All Stars
21,256 posts Joined: Jan 2003 From: Pekopon
|
yes, but when someone is openning the access
how does theother person access it when is locked? i suggest use sql server better |
|
|
Feb 16 2006, 08:55 PM
|
|
Senior Member
1,490 posts Joined: Sep 2004
|
unless u are making ur application as a server application, so that every client communitate to the db through ur server application.
|
|
|
|
|
|
Feb 16 2006, 11:19 PM
|
|
Junior Member
160 posts Joined: Jun 2005
|
can anybody teach me how to write db in sql server?
Beside that, as Seventh7 told... So anybody can give me example of source code or program that show the application be a server application? Thank you a lot. |
|
|
Feb 17 2006, 12:18 AM
|
Senior Member
3,622 posts Joined: Jan 2003
|
hmm another fella with same case as mine
|
|
|
Feb 17 2006, 02:40 AM
|
Senior Member
1,281 posts Joined: Jul 2005 
|
QUOTE(Michael83 @ Feb 16 2006, 11:19 PM) can anybody teach me how to write db in sql server? dude...try this, really helps: SQLBeside that, as Seventh7 told... So anybody can give me example of source code or program that show the application be a server application? Thank you a lot. edit: sorry for the broken link  -->SQL This post has been edited by yingchai: Feb 17 2006, 03:38 PM |
|
|
Feb 17 2006, 07:08 AM
|
|
Junior Member
160 posts Joined: Jun 2005
|
QUOTE(yingchai @ Feb 17 2006, 02:40 AM) I tried to click SQL link as yingchai said. But cannot get thru wor...YingChai,can give the link again? thanks. |
|
|
Feb 17 2006, 11:07 AM
|
|
Junior Member
286 posts Joined: Jan 2003 From: Subang Jaya
|
QUOTE(Acey @ Feb 17 2006, 12:18 AM) hmm another fella with same case as mine Izit me or Michael83? Yes, i think i heard of ur case b4. |
| Change to: |  0.0209sec
 0.97
 5 queries
 GZIP Disabled
Time is now: 23rd December 2025 - 09:28 AM |
Quote