MNottingham
New member
- Local time
- Yesterday, 18:23
- Joined
- May 4, 2013
- Messages
- 6
The situation is as follows:
We have an Access 2007 Database that through the use of a command button performs an open/refresh/close of a corresponding excel sheet. Currently access knows where the excel sheet is through the use of relative paths in Access. However Excel is not nearly as cooperative, it refuses to do a relative connection to the access database through its connection string.
The end goal is to have the access update the excel sheets which power our primary production slide show.
Currently this is what I need to fix and have scoured the net to find:
Current connection string:
Data Source=C:\DATABASEFOLDER\MYDB.accdb
Needs to be:
Data Source=<some code to identify that the connection should look in current folder>MYDB.accdb
This is a OLEDB 12 connection.
Thanks I advance for any help you guys can provide.
We have an Access 2007 Database that through the use of a command button performs an open/refresh/close of a corresponding excel sheet. Currently access knows where the excel sheet is through the use of relative paths in Access. However Excel is not nearly as cooperative, it refuses to do a relative connection to the access database through its connection string.
The end goal is to have the access update the excel sheets which power our primary production slide show.
Currently this is what I need to fix and have scoured the net to find:
Current connection string:
Data Source=C:\DATABASEFOLDER\MYDB.accdb
Needs to be:
Data Source=<some code to identify that the connection should look in current folder>MYDB.accdb
This is a OLEDB 12 connection.
Thanks I advance for any help you guys can provide.
