OpenDatabase/OpenConnection commands

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "D Huber" <DHuber@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 30 Jun 2005 12:26:03 -0700

I am trying to rewrite a database from an older version of Access to Access
2000. VBA is still fairly new to me and there is a single line of code that
is giving me a problem.

Set accrual = DBEngine.Workspaces(0).OpenDatabase("p:gautam\tables.mdb")

According to the book I have in the newer version of access, this line
should read:

Set accrual = DBEngine.Workspaces(0).OpenConnection("p:gautam\tables.mdb")

Neither of these lines work. Any help or suggestions?
.

Follow-Ups:
- Re: OpenDatabase/OpenConnection commands
  - From: Dirk Goldgar

Prev by Date: RE: How do I assign text to a table field via checkbox on a form?
Next by Date: Value dependant upon combo box choice.
Previous by thread: Use QBF to Display Search Results in Sub Form
Next by thread: Re: OpenDatabase/OpenConnection commands
Index(es):
- Date
- Thread

Relevant Pages

adding new record??
... Im just getting into this VBA for access stuff and am a bit confused. ... the database is already open how do you add data to a table in the new ... Scott ... Prev by Date: ...
(microsoft.public.access.formscoding)
Linked tables
... Is there a way to manage linked tables from VBA? ... another database with identical structure. ... Prev by Date: ...
(microsoft.public.access.formscoding)
Re: Indexs and seek need help
... > Here is the scenario. ... > Access XP using VBA. ... > This works with an Access 97 database not with an Access XP database. ... Prev by Date: ...
(comp.databases.ms-access)
Detecte ither instances of same .mde
... How do I detect an already opened - but minimized - instance of a database ... from VBA? ... Diane ... Prev by Date: ...
(microsoft.public.access.modulesdaovba)
Re: OpenDatabase/OpenConnection commands
... > I am trying to rewrite a database from an older version of Access to ... VBA is still fairly new to me and there is a single line ... connection to an ODBC database. ... You wouldn't use it to open an .mdb ...
(microsoft.public.access.modulesdaovba)