Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2005

Tip: Looking for answers? Try searching our database.

Access to MS Project export problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
radillac - 17 Mar 2005 23:20 GMT
I have an Access DB exporting schedule data to MS Project via code. It works
fine on my laptop. The DB and Project files are on a server. When anyone else
runs the export function in the DB from another PC it reports a syntax error
at the "Set oProject = GetObject(PathName)" statement below and won't export
data to the Project file. I had the same problem on my PC at first but adding
the DAO 3.6 library and couple of others fixed the problem. The added
references are there regardless of which other PC I open the DB with. Also
checked the ones in MS Project and they all match what my PC shows too.  

Any idea what's causing the error and how to fix it so other Users can run
the export function from their PC's?

Function Main_Update_Project(PathName As String, TableName As String)
'This is the second procedure called.
   
   'Assign this as a recordset variable.
   Dim rstExportTable As Recordset
   'Now fill the recordset with the records in the table identified by the
TableName argument
   Set rstExportTable = CurrentDb.OpenRecordset(TableName)
   
   Set oProject = GetObject(PathName)
   
   Call Sub_Update_Project(oProject, rstExportTable, PathName)
   
   'Set oProject = Nothing
   Set rstExportTable = Nothing
Alex Dybenko - 18 Mar 2005 07:22 GMT
What error line:
Set oProject = GetObject(PathName)
causing?
probably you have different versions of Projects and use early bindings?
then try to use late bindings

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>I have an Access DB exporting schedule data to MS Project via code. It
>works
[quoted text clipped - 28 lines]
>    'Set oProject = Nothing
>    Set rstExportTable = Nothing
AZWM - 26 May 2005 17:40 GMT
What code did you use to do this?  I am a fairly new user to Access, and I
need to create a Gant chart based on dates from my Access database.

> What error line:
> Set oProject = GetObject(PathName)
[quoted text clipped - 34 lines]
> >    'Set oProject = Nothing
> >    Set rstExportTable = Nothing
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.