Re: client/server application using Access as front end
From: T. Gylver (nospam_at_tgylnospam.no)
Date: 08/07/04
- Previous message: Andrew J. Kelly: "Re: Timeout Expired for no apparent reason"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 7 Aug 2004 21:00:06 +0200
Access project is a quick (and easy??) way to create clients.
You can remove the standard Access menus from your your client so that users
cannot easily change your design. Access has about everything when it comes
to security
If you have some experience with access databases you can benefit from this
when you create an access application working with sql server. You can
create your forms by using wizards in access. For more sophisticated
functions you can write ADO calls from Access (in VBA) to SQL Server, for
instance to let the client call stored procedures on the sql server.
Regards
Tore
"ming" <anonymous@discussions.microsoft.com> wrote in message
news:2056f01c45955$9629f1c0$a301280a@phx.gbl...
> Hi, i have this Access database with data entry forms. Now
> i want to move the data to SQL server and keep the entry
> system in Access. I tried to create a Access project which
> is linked with SQL server. the access project is just like
> a local application, i could make any changes on data and
> even the design of the database, which is not i have in
> mind. I could set up the startup form but it's really easy
> to bypass it. What should i do, Access project or ADO
> programming? please help!
- Previous message: Andrew J. Kelly: "Re: Timeout Expired for no apparent reason"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
