Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

VB and different versions of Access

 
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  update problems over network  
Author Message
Bert

External


Since: Jan 23, 2004
Posts: 1



(Msg. 1) Posted: Fri Jan 23, 2004 2:11 pm
Post subject: VB and different versions of Access
Archived from groups: microsoft>public>vb>database>dao (more info?)

Hi Ive developed a VB app for an external client which accesses an Access
database. When Ive been designing the app Ive been using Access 97, but the
client is using Access 2000. Because of security issues they did not give me
a full database (not all data but same design). When I ship it out to them
they install the software which includes my database and folder to put it in
then, they try to replace the database I supplied with the one they have but
now problems arise with not finding the database, the error trapping I use
gets the message "Unrecognized database format" is this a problem
differences between the two versions off access and Ive got to reference
Access 2000 in my vb app, or is it an access security feature which I have
to program round or is it.....

Any suggestions or ideas would be great...

 >> Stay informed about: VB and different versions of Access 
Back to top
Login to vote
Flying Pig

External


Since: Sep 18, 2003
Posts: 3



(Msg. 2) Posted: Fri Jan 23, 2004 3:03 pm
Post subject: Re: VB and different versions of Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

you need VB6 SP5 to enable access 2000 in VB, change your project references
to include DAO 3.6, and any data controls to connect to Access2000; Thats
for starters anyway...

"Bert" <bert.TakeThisOut@hkhkhkf.com> wrote in message
news:uSj6wFa4DHA.2380@TK2MSFTNGP10.phx.gbl...
 > Hi Ive developed a VB app for an external client which accesses an Access
 > database. When Ive been designing the app Ive been using Access 97, but
the
 > client is using Access 2000. Because of security issues they did not give
me
 > a full database (not all data but same design). When I ship it out to them
 > they install the software which includes my database and folder to put it
in
 > then, they try to replace the database I supplied with the one they have
but
 > now problems arise with not finding the database, the error trapping I use
 > gets the message "Unrecognized database format" is this a problem
 > differences between the two versions off access and Ive got to reference
 > Access 2000 in my vb app, or is it an access security feature which I have
 > to program round or is it.....
 >
 > Any suggestions or ideas would be great...
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: VB and different versions of Access 
Back to top
Login to vote
Douglas J. Steele

External


Since: Mar 14, 2004
Posts: 1626



(Msg. 3) Posted: Fri Jan 23, 2004 9:26 pm
Post subject: Re: VB and different versions of Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

See whether the following KB articles help:
PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or
2002:
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=238401" target="_blank">http://support.microsoft.com/?id=238401</a>
FIX: The Data Form Wizard May Not Open an Access 2000 Database:
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=242010" target="_blank">http://support.microsoft.com/?id=242010</a>
HOWTO: Modify the Visual Data Manager (VISDATA) to Work with Access 2000
Databases:
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=252438" target="_blank">http://support.microsoft.com/?id=252438</a>
FIX: Unrecognized Database Format Error with Data Control or Data Form
Wizard:
<a style='text-decoration: underline;' href="http://support.microsoft.com/?id=257780" target="_blank">http://support.microsoft.com/?id=257780</a>



--
Doug Steele, Microsoft Access MVP
<a style='text-decoration: underline;' href="http://I.Am/DougSteele" target="_blank">http://I.Am/DougSteele</a>
(No private e-mails, please)



"Bert" <bert.RemoveThis@hkhkhkf.com> wrote in message
news:uSj6wFa4DHA.2380@TK2MSFTNGP10.phx.gbl...
 > Hi Ive developed a VB app for an external client which accesses an Access
 > database. When Ive been designing the app Ive been using Access 97, but
the
 > client is using Access 2000. Because of security issues they did not give
me
 > a full database (not all data but same design). When I ship it out to them
 > they install the software which includes my database and folder to put it
in
 > then, they try to replace the database I supplied with the one they have
but
 > now problems arise with not finding the database, the error trapping I use
 > gets the message "Unrecognized database format" is this a problem
 > differences between the two versions off access and Ive got to reference
 > Access 2000 in my vb app, or is it an access security feature which I have
 > to program round or is it.....
 >
 > Any suggestions or ideas would be great...
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: VB and different versions of Access 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Error after converting from Access 97 to Access 2002-2003 .. - Hello, I convert my Access 97 Database to Access 2002-2003, because I’m now using WinXP. And now when I run my VB program, I get Runtime error '3343' - Unrecognized database format. I'm using DAO350.DLL. Do I have to change to another DLL? Thanks. ....

VB6 Access 2000 : Error 3085 undefined function, works wh.. - I've been using VB6 with DAO 3.6 and an Access 2000 format database fine for a few years. I recently added a module function that one of the Access queries uses. It is only called from with the Access query. When I try to set the first parameter from....

DAO reference / Access 2007 - while using an Access 2007 .accdb file I can access the dao. object very easily. the following code in VBA works well : Function getrecordcount(strTableName As String) As Long Dim dbCurrent As DAO.Database Set db = CurrentDb Dim rstRecords A...

Can't access newsgroup using NNTP Newsreader - Hi. I've been unable to access the newsgroup Vb.database.dao using NNTP newsreader. However, I can access it through the browser. The message that appeared is : The newsgroup 'msnews.microsoft.com/microsoft.public.vb.database.dao' was not availabl...

Problem with DAO (Import from Excel to Access)! :( - Hi, I am novice and I have problem. I need import some data with Excel file to Access. Problem introduces as follows: In Excel(first sheet) i have data: "TYTUL" - column "A" "NAZWISKO" - column "B" "IMIE&quot...
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]