Drew Jensen wrote:
Sorry I got distracted there..and besides I am not using Vista, so not
really sure how much this helps.
I went back and tried again to connect Base to an accdb file under
Windows 7, even after installing the MS visual studio for .net thinking
that it should work..it didn't.
Just now however I went to:
http://www.microsoft.com/downlaods
In the search box at the top of that page I entered:
Access 2007 Connectivity
The first two entries returned I then downloaded and installed:
--2007 Office System Driver: Data Connectivity Components
--Microsoft Office Access Runtime and Data Connectivity 2007 Service
Pack 2 (SP2)
Now I opened the Base new file wizard and selected an external database
type of
MS Access 2007 (note this is the entry on the list of database
types...it is not the same as selecting MS Access)
On the next page I browsed to an accdb file that I knew I could connect
with in read/write mode under XP..and there it was.
Let me know if that helps,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Drew
No, I have the same problem still. However the database is from a client
who is not very computer savvy. Do you have a small accessdb that I can
run some tests on, just to make sure it is not password protected or
something. I would ask you to look at the database I have but it is
client information and a little large to send over the internet.
Also when I looked at the --2007 Office System Driver: Data Connectivity
Components documentation I found this comment about using the download.
Did you set anything up on your computer or OOo that could have a
bearing on the solution
To use this download:
1.If you are the user of an application, consult your application
documentation for details on how to use the appropriate driver.
2.If you are an application developer using OLEDB, set the Provider
argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
If you are connecting to Microsoft Office Excel data, add “Excel 12.0”
to the Extended Properties of the OLEDB connection string.
3.If you are application developer using ODBC to connect to Microsoft
Office Access data, set the Connection String to “Driver={Microsoft
Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
4.If you are application developer using ODBC to connect to Microsoft
Office Excel data, set the Connection String to “Driver={Microsoft Excel
Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
Thanks
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
