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

Copying forms in database

P: n/a
Is there any way to copy only the forms from one .mdb file to another?

Sep 26 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a

abprules wrote:
Is there any way to copy only the forms from one .mdb file to another?
just import them into the new db... what's the problem?

Sep 26 '06 #2

P: n/a
On 26 Sep 2006 10:15:13 -0700, abprules wrote:
Is there any way to copy only the forms from one .mdb file to another?
Open the database into which you wish to copy the forms.
Click on File + Get External data + Import
Navigate to the database that contains the forms you wish to copy.
Select those you wish to import. Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Sep 26 '06 #3

P: n/a
Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?

Thanks,
Bart

fredg schreef:
On 26 Sep 2006 10:15:13 -0700, abprules wrote:
Is there any way to copy only the forms from one .mdb file to another?

Open the database into which you wish to copy the forms.
Click on File + Get External data + Import
Navigate to the database that contains the forms you wish to copy.
Select those you wish to import. Click OK.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Sep 26 '06 #4

P: n/a
Bart wrote:
Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?
Change their RecordSource to something else? It's not clear what you want to
accomplish. Do you want to use the same form design in another context or what
exactly?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Sep 26 '06 #5

P: n/a
Hi Rick,

Thanks for the reply!

I have an mdb file which is the "front end" (form design?) of an
Access application. The data itself is stored in a SqlServer. When I
open the front end, it tries to connect to the SqlServer, which isn't
online.

I've exported the data on the SqlServer to an mdb "data" file.
Opening the "data" file and "importing" the "front end" does not work
for tables (it works for reports, queries, etc).

While importing the tables of the "front end", Access tries to
contact the SqlServer. How do I explain Access that it should look for
a "data" mdb file?

Your comments are highly appreciated!

Thanks,
Bart

Rick Brandt wrote:
Bart wrote:
Hi,

In my case the forms try to connect to a server that isn't online.
How do I get around that issue?

Change their RecordSource to something else? It's not clear what you want to
accomplish. Do you want to use the same form design in another context or what
exactly?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Sep 27 '06 #6

P: n/a
Bart wrote:
Hi Rick,

Thanks for the reply!

I have an mdb file which is the "front end" (form design?) of an
Access application. The data itself is stored in a SqlServer. When I
open the front end, it tries to connect to the SqlServer, which isn't
online.

I've exported the data on the SqlServer to an mdb "data" file.
Opening the "data" file and "importing" the "front end" does not work
for tables (it works for reports, queries, etc).

While importing the tables of the "front end", Access tries to
contact the SqlServer. How do I explain Access that it should look for
a "data" mdb file?

Your comments are highly appreciated!
Go the other way. Delete the links in your front end and then create new links
to your MDB back end. If the tables/links have the same name as beofer then it
will work.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Sep 27 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.