Re: restrict design access

A. Is it as simple as having 2 databases with the tables in the BE &
everything else in the FE?

Yup


B. It will be a multi-user environment. As I understand it the BE will be
on the server & multiple copies of the FE distributed to the various user's
computer

Yup


C. What is the best way to link my tables to the FE?

When you split the db, access will take care of this for you (if you use the
wizard). However, if you change the location of the BE after you split, you
will need to update it on the frontend (using the linked table manager). Or,
see this code to programatically relink on startup (a bit more advanced...)

http://www.mvps.org/access/tables/tbl0009.htm

If by chance you do take this route, only run this code if the tables are
not already linked, rather than on each startup (relinking every time it
starts causes 'bloat').

Your best bet here is to use the server path in the MDB with the linked
table manager, then you can deploy it to any computer on the network without
having to screw with it (the server path should be the same for every client
computer... \\Server\Folder\File.mdb... avoid mapped drives at all costs).



D. Right now I have the following references enabled. What else will I
need to enable?
* VB for Apps
* MS Access 9.0 Object Lib
* OLE Auto
* MS ActiveX Data Objects 2.1 Lib

Nothing.

References play no part in splitting a database... whatever you currently
require will not change (expect maybe with the code to programmatically
relink... if I remember correctly this may require DAO3.6 (or ACE(?) for
'07). But you probably won't use this right off the bat anyway.

hth

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Del J" wrote:

Ok, I'll give this FE/BE structure a try. I'm self-taught with gaps in my
understanding of the whole. Here are some questions I can think of right
now. Is there anything else I might need to know?

A. Is it as simple as having 2 databases with the tables in the BE &
everything else in the FE?

B. It will be a multi-user environment. As I understand it the BE will be
on the server & multiple copies of the FE distributed to the various user's
computer

C. What is the best way to link my tables to the FE?

D. Right now I have the following references enabled. What else will I
need to enable?
* VB for Apps
* MS Access 9.0 Object Lib
* OLE Auto
* MS ActiveX Data Objects 2.1 Lib

Thanks for all the help

"Jack Leach" wrote:

Keeping the workable MDB and executable MDE is actually very easy. When you
have the MDB at the next distributable version, simply make a copy and
convert the copy to an MDE, and continue updates with the MDB until you're
ready for the next distribution.

In fact, if you do have multiple users, you can automate the update process
using Tony's AutoFE Updater (a very helpful peice of work for those of us on
the lazy side).

http://www.granite.ab.ca/access/autofe.htm


And I would definately recommend splitting the database, even if there's
only one copy being run and it's not on a true multiuser setup. Splitting
the db has many advantages even for the single user, updates without
compromising your data being one of them. Again, this is suprisingly easy
and takes about 5 seconds by your second of third time around.


--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"Del J" wrote:

That looks good but my management is notorious for requesting expansions,
etc. Because of difficulties reconciling data between the mde file & saved
copy of the database this looks like it would work best as a
front-end/back-end database. The problem here is that I have no experience
with front-end/back-end databases.

Is there another way to prevent users from accessing form design?

"Stuart McCall" wrote:

"Del J" <DelJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B73D81F6-7FD0-4666-A3AD-6A162498BC98@xxxxxxxxxxxxxxxx
How can I prevent users from accessing form design in Access 2000?

Search help for 'make mde file'.



.

Relevant Pages

  • Re: Log shipping and Replication
    ... Then ship your msdb, distribution, published database to the standby server. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Combining Multiple Databases
    ... It supports the data synchronization of multiple ... > central database and gets all the same reports, I just need to be able to ... > where they can connect to our server then transfer that information to it. ... > have accurate reporting. ...
    (microsoft.public.access.externaldata)
  • Re: Browser Issue
    ... What about situations where there are multiple front-end web servers ... connecting to multiple database servers. ... You don't really want to allow users to upload images (profiles, forums, ... every server to every other server every few minutes. ...
    (comp.lang.php)
  • Re: restrict design access
    ... Would it be best to complete the database and then split it into BE/FE? ... "Jack Leach" wrote: ... on the server & multiple copies of the FE distributed to the various user's ... Your best bet here is to use the server path in the MDB with the linked ...
    (microsoft.public.access.modulesdaovba)
  • One Database vs. Multiple Databases
    ... I need to design a system which represents multiple "projects" in SQL ... Each project has the same data model, ... My inclination is to use one database to store all projects. ... better performance by using multiple databases, or does SQL Server have ...
    (comp.databases.ms-sqlserver)
Loading