Creating a Template/Publishable Form

[plumsmugler]

Hello all!

Our office just just got Access and we're having a couple of hiccups along the way.

Our secretary just created a client contacts list by opening a blank database and entering names, numbers, etc. in an exel-like grid. Her computer is the only one with Access on it and we're planning on distributing the contacts list through Access Run-Time.

The problem is we can't share this list through Run-Time unless it's created through a template. When we attempt to open the file through the regular database she created nothing appears. When we do it through a template I see all of the information.

My question is, how do we create a template so we can create our own forms to share through Run-Time? I really don't like the pre-loaded templates. I'm also having trouble finding a tutorial online of creating your own template.

My ultimate goal, I suppose, is to create something from scratch on Access and then be able to share it via Access Run-Time.

 

[jdraw]

Perhaps you should start by telling us more about the "issue". Is there anyone in your group that has some knowledge of relational database?
Has anyone been trained in any level in Access or Database design?
Do you have anything in writing as to the scope of the "project" - how many users, what list(s), future development, interfaces with any other lists/databases/software???

You mention excel. Was there an issue with publishing a list with excel? What is driving this new acquisition and approach?

 

[plumsmugler]

At the moment it's just a client contacts list. Addresses, phone numbers, etc. Our secretary took some online introductory lessons into Access but has no special training in database design.

I browsed some introductory tutorials myself and believe the problem may be that our secretary has merely filled out a table of information but she must now save it withing some kind of "form." (As is listed under "Objects")

Will creating a form of something make it viewable within Run-Time?

 

[spikepl]

TO be honest - what is the purpose of it all? The web is inundated with various kinds of such most basic business utilities for free, for money, hosted, rented, leased, .. you name it.. You also probably have outlook or some other mailer/calendar/contact thing.. What is it that drives you to reinvent the wheel? If it is the wheel you are reinventing? And if you wish to have the wheel reinvented, why not pay someone who knows how to do it? You can expend a lot of effort and money on learning how to do something, and perhaps you are not better off afterwards than before. So what is the business case?