Access Frontend/Sql Backend

[Guest]

Hi,

I currently have an interface in Access as a frontend and another database
in Access as the backend. I can input information into the frontend
interface, which is linked to the backend part and then sent to the web via
Coldfusion. I want to convert the backend to SQL Server.

I converted all of the data to SQL Server, and can display that information
on the web via Coldfusion. If I make a change to the data on the backend,
that change is shown on the frontend part. However, I cannot make a change
to the frontend part. I can open the tables and the interface to input data,
but when I type all I get are beeps and cannot type anything.

Any advice would be helpful.

Thanks,

Matt

 

[Dirk Goldgar]

Hi,

I currently have an interface in Access as a frontend and another
database in Access as the backend. I can input information into the
frontend interface, which is linked to the backend part and then sent
to the web via Coldfusion. I want to convert the backend to SQL
Server.

I converted all of the data to SQL Server, and can display that
information on the web via Coldfusion. If I make a change to the
data on the backend, that change is shown on the frontend part.
However, I cannot make a change to the frontend part. I can open the
tables and the interface to input data, but when I type all I get are
beeps and cannot type anything.

Make sure every table has a primary key or unique index.

 

[Tony Toews]

Make sure every table has a primary key or unique index.

Also Access really likes a datetime field. Now know as rowversion
which is better nomenclature.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Dirk Goldgar]

Also Access really likes a datetime field.

You mean timestamp?

Now know as rowversion
which is better nomenclature.

Agreed.

 

[Tony Toews]

You mean timestamp?

You're correct.

Agreed.

As this example shows. <chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm