Is there any way to make a form that looks JUST LIKE a table or query?

[RSW]

I have a simple database (right now it only has one table and one form) that many users are using. Actually the table is on a shared server, and I distributed a separate client (with the form) to a bunch of users.

Some of the users here are not very computer literate, especially with Access, so before I distribute I take away the menu options so the database looks more simple and they won't accidentally delete the data or something. However, one user wants to be able to see the raw data and link or export it to his own database.

Is there any way I can make a form, page, or report that looks exactly like raw data (or a query of it), without letting users get at the menu options or the design view screens? (they could still get at it by holding down shift when they open the file, but they don't know that, and I don't especially want them to.) And is is also important that it can be exported into Access or Excel.

SIMPLEST solution would be appreciated! The database is very simple; I really don't want to get into security roles and such.

The sole table is pretty big, though; ~100 columns maybe?

Thanks in advance.

 

[ted.martin]

Will the form in datasheet view help?

 

[RSW]

I tried that--with the wizard, at least--but I only got one row at a time, and the number of fields prevented it from looking like the table.

 

[missinglinq]

You might want to try that again! A form created by the wizard with datasheet selected as the style should look identical to the table, and you should be able to see more than one record at a time!

 

[boblarson]

I agree as I use Datasheet view forms to make it look like the table or a query all of the time. You must be viewing in single form mode.

 

[RSW]

Wow, it worked that time.

I have no idea what I was doing wrong, but thank you for telling me I was wrong but doing so politely

 

[RSW]

OK, I see what I was doing wrong.

The wizard was bringing it up in Design View, and not being familiar with this type of form, I assumed that's what the regular view would look like.

Still feel dumb though