Re: Saving Back-End Data As mdf

Thanks much. I'll give it a try.

James

"Brendan Reynolds" <brenreyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23peV9etuGHA.976@xxxxxxxxxxxxxxxxxxxxxxx

My understanding is that if you use the new file format you will need to
use the new provider, with a connection string something like so ...

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\usenet\test.accdb;Persist
Security Info=False

... however, because this new provider is a component of Office 2007, and
not a component of the operating system as the older JET provider is, this
requires Office 2007 to be installed on the target PC, which is presumably
why it won't work on your PC now that Office 2007 has been uninstalled.

If you stick with the older MDB format, you should be able to get to it
from .NET with the older JET provider, using a connection string something
like ...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\usenet\test.mdb;Persist
Security Info=False

At the following URL ...

http://www.microsoft.com/office/preview/beta/getthebeta.mspx?showIntro=n

... under the heading 'IT Content for 2007 Office System Beta 2' there is
a reference to 'an authorization control that provides you access to the
Microsoft Office Online Beta site'. I can't say for sure, but I would
expect that access to the Beta site would probably include access to the
Beta newsgroups, and possibly you might get more help with your
installation issue there.

Good luck,

--
Brendan Reynolds
Access MVP

"JamesJ" <jjy@xxxxxxxxxxxxxxxxxxx> wrote in message
news:O92Xt%23suGHA.4460@xxxxxxxxxxxxxxxxxxxxxxx
Ok. Just trying different things.

Thanks
James

"Arvin Meyer [MVP]" <a@xxxxx> wrote in message
news:OILGKBpuGHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
Yes it is beta software, and not really ready for production databases.
Not too many are using it at all, and those of us on the beta, are not
using it in production. It should therefore be understandable that we
can't (or don't) answer questions on Access 2007.

Try a stable release, such as XP (2002) or 2003, and you will be able to
do what you need to do. I also suggest that you keep the databases in
the default Access 2000 file format. That way you will be able to share
it with a wider range of users.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"JamesJ" <jjy@xxxxxxxxxxxxxxxxxxx> wrote in message
news:ucUNe9luGHA.5084@xxxxxxxxxxxxxxxxxxxxxxx
Why? Ready? Here goes.
It all started when I attempted to evaluate Access 2007 Beta.
I needed to uninstall the Office 2007 Beta 2 times. The third
time I tried to install it the install failed. So I'm
unable to evaluate Access 2007 Beta. I've posted and posted to
these newsgroups and no one has replied.
I understand it's a beta but if I can't install it I can't
evaluate it.
So, I decided to try Visual Basic 2005 Express Edition. Now a
problem with that. I get an error when I try to
connect to my Access back-end db. Again, I posted and posted...
nothing.
I was hoping I would have better luck if I would save the mdb
as a mdf file for Visual Basic 2005 Express Edition.
Any way I'm a bit frustrated now.
It's sort of funny I was able to connect to my Access
back-end db with Alpha 5!? Maybe I'll go with that.

James

"Arvin Meyer [MVP]" <a@xxxxx> wrote in message
news:OIBWNnbuGHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
mdf files are the SQL-Server data files. You need to have an instance
of SQL-Server running in order to save anything to the file. Once you
do it is easy. Access forms can connect directly to the data tables in
SQL-Server. My question to you might be, why use VB.NET if you alrady
have a more efficient database application front-end in Access?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"JamesJ" <jjy@xxxxxxxxxxxxxxxxxxx> wrote in message
news:uKF04hYuGHA.1852@xxxxxxxxxxxxxxxxxxxxxxx
Ho do I save or export my back-end data db as
a mdf so I might use it in Vb 2005.

Thanks,
James













.

Relevant Pages

  • Re: Saving Back-End Data As mdf
    ... My understanding is that if you use the new file format you will need to use ... the new provider, with a connection string something like so ... ... Microsoft Office Online Beta site'. ... time I tried to install it the install failed. ...
    (microsoft.public.access.formscoding)
  • Re: how the heck can I get office 2003 back after uninstalling off
    ... There is a beta of the Twin-Pack downloads (File Format Awareness and Compatability/Converter set) that will add the ability to ... LINKS to the 2007 Office System ... Install the ActiveX access control ...
    (microsoft.public.office.misc)
  • Re: Saving Back-End Data As mdf
    ... My understanding is that if you use the new file format you will need to ... not a component of the operating system as the older JET provider is, ... Microsoft Office Online Beta site'. ... time I tried to install it the install failed. ...
    (microsoft.public.access.formscoding)
  • Re: Can we have some Office 2007 for mac screenshots ?
    ... Office Mac releases are generally one year later than Office Windows ... there has never been a public beta for Office Mac. ... Can we have some Office 2007 for mac screenshots? ... XML file format, no VBA, ...
    (microsoft.public.mac.office)
  • Re: Can we have some Office 2007 for mac screenshots ?
    ... Office Mac releases are generally one year later than Office Windows ... there has never been a public beta for Office Mac. ... Can we have some Office 2007 for mac screenshots? ... XML file format, no VBA, ...
    (microsoft.public.mac.office)
Loading