By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Find and Export backend from Frontend

P: n/a
DD
Hi
I have a split database, that is packaged and used in a runtime
enviroment.

I want to make it easier for the user, a button on the frontend
"Export Backend"

They can click on the button then search for the backend and then save
the backend to a CD or Floppy.

Can anyone assist,as i have looked at the OpenSave dialog but i must
be missing something

Regards
DD
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Go to www.mvps.org/access and look at the first two examples in the API
section.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...
Hi
I have a split database, that is packaged and used in a runtime
enviroment.

I want to make it easier for the user, a button on the frontend
"Export Backend"

They can click on the button then search for the backend and then save
the backend to a CD or Floppy.

Can anyone assist,as i have looked at the OpenSave dialog but i must
be missing something

Regards
DD

Nov 13 '05 #2

P: n/a
Yes i understand to use these.

But i am not able to work out how to once i have browsed and found the
backend to save it to a external drive A or Cd

any help please
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

P: n/a
A few comments:
First, you shouldn't need to browse to the backend; you can extract its
location from the Connect property of the TableDef for any linked table.

Second, most backends rapidly exceed the 1.44 MB you can store on a floppy.

Third, it's generally considered unwise to copy an MDB file while there's an
open connection to it.
At the very least, you should make sure that all bound forms in your front
end are closed. (Put your button on an unbound form - e.g. a switchboard or
main menu.)
Since you have a split application, I'm assuming that there may be other
users using the backend at the same time. It would be best to check for
this condition and not allow copying in that case.

Fourth, the FileCopy command is all you'd need to copy the file to a new
location on a hard drive or floppy drive. Under WindowsXP, I would expect
it to move the files to the D drive for you, but not to actually burn the
CD. If you come up with some API calls to actually do the burning, please
post back. I'd like to know those myself!

HTH
- Turtle

"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...
Hi
I have a split database, that is packaged and used in a runtime
enviroment.

I want to make it easier for the user, a button on the frontend
"Export Backend"

They can click on the button then search for the backend and then save
the backend to a CD or Floppy.

Can anyone assist,as i have looked at the OpenSave dialog but i must
be missing something

Regards
DD

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.