PDA

Click to See Complete Forum and Search --> : ACCESS 2000 PROBLEM WITH VB


gsc1ugs
Sep 8th, 2000, 07:32 AM
I have converted my database to MS ACCESS 2000 and now this line as errors, can anyone tell me what is suitable replacement.??

Set DB = OpenDatabase(App.Path & "\configuration.mdb")

Many thanks

Any other conversion issues you feel i should know about woulb be a bonus.
ie:

Set rs = DB.OpenRecordset("SELECT netVESPAWeb.*, ISDefine.SetPreProccessor, altCarriers.Carrier FROM (ISDefine INNER JOIN netVESPAWeb ON ISDefine.ID = netVESPAWeb.ISPreProccessorType) INNER JOIN altCarriers ON netVESPAWeb.SetCarriers = altCarriers.ID", dbOpenDynaset)

Gary

Shafee
Sep 8th, 2000, 09:02 AM
Hello there,

Click this link and see if it helps.
http://support.microsoft.com/support/kb/articles/Q133/4/14.asp

gsc1ugs
Sep 8th, 2000, 09:36 AM
Nope, thanks anyhow, anyone else.?

Clunietp
Sep 8th, 2000, 10:31 AM
because you didn't give us any error messages, we can only assume what the problem is....

my assumption is this:
http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

gsc1ugs
Sep 8th, 2000, 10:58 AM
Many thnks... just the jobby.


Are you doing your bit!!!?
-------------------------------
Boycott_the_pumps@egroups.com
-------------------------------

Cheers

Gary