Hi Terry,
Based on my understanding, you can add a connection to a Access database
file in VS.NET2003, but couldn't do this in VS2005. If I'm off base, please
feel free to let me know.
I performed a test in VS2005, but didn't reproduece the problem on my side.
The following is the steps of my test.
1. Create an Access database file called Database1.mdb and save it to the
root path of D:\.
2. Open VS2005. In the Server Explorer, right click the 'Data Connections'
node and choose 'Add Connection'.
3. In the 'Add Connection' dialog, if the text in the 'Data source' textbox
isn't 'Microsoft Access Database File(OLE DB)', click the 'Change' button
and 'Change Data Source' dialog appears. In this dialog, select 'Microsoft
Access Database File' in the 'Data source' list(at this time, the below
'Data Provider' combobox only contains '.NET Framework Data Provider for
OLE DB'), and press OK and return to the 'Add Connection' dialog.
4. In the 'Add Connection' dialog, click the 'Browse' button to browse to
the Database1.mdb file and press OK.
5. A new node 'Access.D:\Database1.mdb' appears under the 'Data Connection'
node in the Server Explorer.
The version of VS2005 on my machine is Visual Studio 2005 Team Suite
Version 8.0.50727.42(RTM.050727-4200). What's the version of VS2005 on your
machine?
Sincerely,
Linda Liu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.