Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / March 2007

Tip: Looking for answers? Try searching our database.

FE/BE question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Slez - 29 Mar 2007 17:59 GMT
I'd like to load a database on a laptop for demonstration purposes, but don't
really need it to be a FE/BE version.  (I don't need current data.)  Is there
a way to "rejoin" a split database?...Or do I just need to load a copy of
both ends?

Thanks!
Slez
Jerry Whittle - 29 Mar 2007 19:24 GMT
Load a copy of both. Now the big problem happens when you don't have the same
drive mappings. In that case you can just go up to Tools, Database Utilities,
Linked Table Manager and relink the FE to the BE.

Another way is to create a virtual drive on your laptop to match a network
drive used for the BE. You can use the old DOS subst command.

Subst--Example

The following command creates a virtual drive Q for the path
C:\USER\BETTY\FORMS:

subst q: C:\user\betty\forms

Now, instead of typing the full path, you can reach this directory by typing
the letter of the virtual drive, followed by a colon, as in the following
example:
q:

If you are using long file names for the folders, use quotes.
subst q: "C:\My Databases"

To remove the virtual drive:
subst q: /d

You can also create more than one virtual drive at a time. I have two that I
load automatically on my home machine by putting the command lines in the
Autoexec.bat file.

Note: I haven't tried this with Windows Vista, but it does work up to XP.
Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I'd like to load a database on a laptop for demonstration purposes, but don't
> really need it to be a FE/BE version.  (I don't need current data.)  Is there
[quoted text clipped - 3 lines]
> Thanks!
> Slez
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.